Last Updated: 31 Mar 2020 11:10 by ADMIN
Release R2 2020
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;
Last Updated: 02 Oct 2015 14:46 by arnaud
Created by: Tanya
Comments: 1
Category: Spreadsheet
Type: Bug Report
The fix will be available in our next LIB release (v. 2015.03.1005).
Last Updated: 31 Oct 2018 07:53 by ADMIN
The BitmapImage class throws the exception. We could show some kind of no-image-placeholder instead of throwing exception, or skip the image.

Telerik Reporting creates such files.

Attached is a sample project demonstrating how to customize the Open command descriptor to remove .emf images just after importing the document.

Available in R3 2018 Official Release Version.
Last Updated: 27 Oct 2015 12:06 by ADMIN
Created by: Nikolay Demirev
Comments: 3
Category: Spreadsheet
Type: Bug Report
The fix is available in our latest LIB release (v.2015.3.1026). 
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.
Last Updated: 30 Jul 2015 10:54 by ADMIN
The fix will be available in our latest LIB release (v. 2015.02.0803).
Last Updated: 07 Oct 2015 15:47 by ADMIN
Using SetValueAsText method to set empty string and the exporting the document generates invalid XLSX, which can not be imported by Excel.
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.
Last Updated: 17 Aug 2018 06:09 by ADMIN
When the formula bar is empty and alt + enter is pressed in order to insert a new line, NullReferenceException is thrown. The exception might be reproduced with text in the formula bar, but the caret has to be placed in the end of a run/end of the text.

Fix available in LIB Version 2018.2.820.
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:
Last Updated: 29 Oct 2018 14:41 by ADMIN
Filter command should be disabled when a single row or cell is selected. 

Fix available in LIB Version 2018.3.1105.
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
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.
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.
Last Updated: 01 Nov 2019 08:11 by ADMIN
Release LIB 2019.3.1104 (10/07/2019)

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. The behavior is related to SpreadProcessing as well.

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);


Last Updated: 11 Feb 2020 12:52 by ADMIN
Release LIB 2020.1.217 (02/17/2020)
An ArgumentOutOfRangeException is thrown when importing a spreadsheet with the first sheet hidden: VisibleSheetCount should be greater or equal to 1.
Last Updated: 21 Mar 2015 12:27 by ADMIN
The fix is available in our latest LIB release (v. 2015.1.0316).
Last Updated: 02 Jun 2016 10:22 by ADMIN
When a workbook with a number of worksheets larger than a certain count is saved an out of memory exception is thrown. The necessary number of worksheets depends on the file and the machine, but it ranges between 70-90.
Last Updated: 08 Aug 2016 11:50 by ADMIN
1 2