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.
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
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
Number formats like "[$-1010409]General" containing locale code and General keyword are not parsed correctly which results in interpreting them as number formats which have to replace the positive numbers with "General". Available in R1 2017 SP
Wrong exception messages are constructed sometimes, due to problem in the internal Guard.ThrowExceptionIfTrue and Guard.ThrowExceptionIfFalse methods: - Guard.ThrowExceptionIfTrue throws InvalidOperationException with text "<paramName> should be true.", instead the text should be "<paramName> should be false." - Guard.ThrowExceptionIfFalse throws InvalidOperationException with text "<paramName> should be false.", instead the text should be "<paramName> should be true." Available in LIB Version 2017.2.828.
Expose WorksheetUIUpdateContextBase.GetDataValidationRuleResult(CellIndex). This method is useful for creating optimized custom Data Validation Circles layers. 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.
This will enable printing with the following printing options: - Fit Sheet on One Page - Fit All Columns on One Page - Fit All Rows on One Page - Custom automatic scaling
VLOOKUP function is similar to LOOKUP function, which is currently supported. A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions This function can be implemented as a custom function. Check the following resources for more details on how to achieve that: - http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions - https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/CustomFunctions Available in R3 2017 Official Release Version.
Filter command should be disabled when a single row or cell is selected. Fix available in LIB Version 2018.3.1105.
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.