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
Filter command should be disabled when a single row or cell is selected. Fix available in LIB Version 2018.3.1105.
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
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.
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.
The background should be stretched along with the item itself. It is currently with specified width. Workaround: Modify the style and change the width of the tab item. A sample is attached.
Expose WorksheetUIUpdateContextBase.GetDataValidationRuleResult(CellIndex). This method is useful for creating optimized custom Data Validation Circles layers. Available in LIB Version 2017.2.828.
If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.
Duplicate of SpreadProcessing: Repeat specific rows or columns on every printed page (telerik.com)
If you begin entering e.g. "=" in FormulaBar, the characters are not visible in dark themes. If the focus is in the cell it works as expected, if the focus is in FormulaBar, the Foreground is dark and cannot be seen on dark background. Workaround: - set the following style (add BaseOn if using implicit styles) <Style TargetType="spreadsheetControls:RadSpreadsheetFormulaBar" BasedOn="{StaticResource RadSpreadsheetFormulaBarStyle}"> <Setter Property="Foreground" Value="White"/> </Style> Available in LIB Version 2017.2.828.
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.
If a workbook contains a worksheet with RowHeight bigger than 600px (SpreadsheetDefaultValues.MaxRowHeight), an exception is thrown while trying to import such a document.