Approved
Last Updated: 27 Sep 2019 16:18 by ADMIN

The issue is a regression introduced in R3 2019. When the cells in a hidden column are with IsWrapped=true, an ArgumentOutOfRangeException is thrown during the text measuring.

Workaround: Remove the wrapping from the hidden cells:

 

var usedCellRange = workbook.ActiveWorksheet.GetUsedCellRange(new IPropertyDefinition[] { CellPropertyDefinitions.IsWrappedProperty});

for (int row = usedCellRange.FromIndex.RowIndex; row <= usedCellRange.ToIndex.RowIndex; row++)
{
    for (int column = usedCellRange.FromIndex.ColumnIndex; column <= usedCellRange.ToIndex.ColumnIndex; column++)
    {
        if (workbook.ActiveWorksheet.Columns[column].GetHidden().Value)
        {
            workbook.ActiveWorksheet.Cells[row, column].SetIsWrapped(false);
        }
    }
}

 

Completed
Last Updated: 10 Sep 2019 14:17 by ADMIN
Release R3 2019
A resource cannot be found and an exception is thrown for a WPF Net Core project.
Approved
Last Updated: 04 Sep 2019 12:19 by ADMIN
Print Preview's "Fit All Columns on One page" does not fit columns on one page.
Completed
Last Updated: 13 Aug 2019 14:00 by ADMIN
Release LIB 2019.2.819 (08/19/2019)
For example, the default namespace prefix for BlipElement is r: if the namespace prefix is different an exception will occur.
Completed
Last Updated: 08 Aug 2019 08:05 by ADMIN
Release LIB 2019.2.812 (08/12/2019)
The scale factor is not imported from documents with no information about the selection state.
Completed
Last Updated: 08 Jul 2019 11:17 by ADMIN
Release LIB 2019.2.708 (07/08/2019)
When there is a document with wrapped cells in it, often the content of the cell is not properly displayed in RadSpreadsheet. This results in the content also being shown over the cell below.
Completed
Last Updated: 26 Jun 2019 06:34 by ADMIN
Release R2 2019 SP1
If a document contains many and complex formulas (with many functions having other functions as arguments) it may take a long time to show in the control.
Approved
Last Updated: 05 Jun 2019 14:29 by ADMIN
At the moment the print settings set to the WorksheetPageSetup class are not passed to the Print dialog which leads to bad user experience. If you set the print settings of the RadSpreadsheet like so:

WorksheetPageSetup pageSetup = this.radSpreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup;
pageSetup.PageOrientation = PageOrientation.Landscape;

and then select Print, the Spreadsheet print menu will show the print preview as landscape. However, when after that you click on Print for the default print dialog to appear and then click Preferences, you will notice that the preference is set to Portrait. The print job will be Landscape, but the incorrect information in the default dialog creates confusion.

This is an example of how to set the preference of the default dialog:

PrintDialog printDialog = new PrintDialog();
var printTicket = printDialog.PrintTicket;
printTicket.PageOrientation = System.Printing.PageOrientation.Landscape;
Approved
Last Updated: 18 Apr 2019 08:13 by ADMIN
Applying a Number number format in a cell and then entering fractional number values like 1.2/2 results in cell value equal to 37258 if it is formatted as a date it will be 1/2/2002.
Completed
Last Updated: 17 Apr 2019 10:44 by ADMIN
The exception is thrown when pasting in a protected sheet and canceling the warning message box using the MessageShowing event.
Approved
Last Updated: 16 Apr 2019 06:05 by ADMIN
When entering values in the cells fast some of the values are skipped.
Approved
Last Updated: 01 Apr 2019 11:39 by ADMIN
The SheetSelectorTabItem background is not properly applied and the text is not readable. This is easily noticeable in themes with a dark color palette. 
Approved
Last Updated: 19 Mar 2019 14:29 by ADMIN
Currently, when the user is editing a cell and saves the document without leaving the edit mode first, the current value is not preserved in the saved document.
When pressing the File -> Save button in the ribbon, the Save dialog doesn't appear at all.
 
Workaround: Manually commit the change before saving. This workaround will also respect data validation:
var layer = ((NormalWorksheetEditorPresenter)radSpreadsheet.ActiveWorksheetEditor.ActivePresenter).UILayers.GetByName(WorksheetPredefinedUILayers.CellInput);
CellInputUILayer cellInputUILayer = (CellInputUILayer)layer;
cellInputUILayer.ApplyChange();
Approved
Last Updated: 08 Mar 2019 11:15 by ADMIN
When a user setups a page and chooses to customize the Header's Odd and Even pages, the tab headers become clipped.
Completed
Last Updated: 06 Mar 2019 07:22 by ADMIN
Customers are reporting an issue when trying to copy content in an application hosted on a remote machine (there are reports using TigerVNC and Citrix).  The exception is thrown from the Clipboard class with a message: OpenClipboard failed (Exception from HRESULT: 0x800401D0 (CLIPBRD_E_CANT_OPEN))

It seems like such a behavior could be reproduced when the clipboard is already opened by another application. Here is a discussion on the matter: https://stackoverflow.com/questions/68666/clipbrd-e-cant-open-error-when-setting-the-clipboard-from-net
Completed
Last Updated: 15 Feb 2019 08:56 by ADMIN
Resizing images always position the image at the cell where the image has been inserted. Flipping image also results in a wrong behavior.
Completed
Last Updated: 08 Feb 2019 13:48 by ADMIN
When you chose the Expand XAML option of the RadSpreadsheetRibbon control, the Charts group which should be in the Insert tab, is missing.
Approved
Last Updated: 08 Jan 2019 19:24 by ADMIN
Some of the RadSpreadsheet child controls do not apply the new theme, but stay with office black applied when theme is set on control level.
Completed
Last Updated: 25 Dec 2018 15:10 by ADMIN
ArgumentException is thrown when protecting a worksheet having missing algorithmName information
Completed
Last Updated: 12 Dec 2018 13:36 by ADMIN
Xlsx documents with a global filter defined cannot be imported. Message box "The name that you entered is not valid." is shown and internally SpreadsheetNameException is thrown. MS Excel can import such document and even preserve the filter, but do not respect it and doesn't have UI to clear it.

Workaround 1 (includes processing the document with MS Excel):
- Open the document in MS Excel
- Choose Formulas -> Defined names -> Named Manager
- Choose Filter -> Names with errors
- Find all Filter defined names and delete them
- Save the document
1 2 3 4 5