When setting the following strings as cell value, they are recognized as dates. In industry standard applications like MS Excel and OpenOffice, they are recognized as strings: - "12 3456" in bg-BG, fr-FR, ru-RU, sv-FI, en-US - "12.3456" in de-DE - "1 23" in en-US - "2013/5" in en-US - "3000-03" in en-US
When using the Fill feature through the dialog, the series are currently filled only for the cells, which are included in the selection. Introduce functionality to fill them without requiring a selection. A custom implementation can be plugged through a custom dialog. A sample showing how to replace the default dialog with a custom one is available in the attachments of the item.
When RadSpreadsheet is placed inside a data template and the Workbook property is bound, the binding fails. In the Convert() method of the debug converter, the proper value is set. However, an empty workbook is displayed in the view.
When a workbook protection is applied, changing the color of a tab in the sheet selector shouldn't be allowed. Workaround: Remove the Tab Color item from the Items collection of the SheetSelectorContextMenu.
Provide the ability to work with images in headers/footers of a worksheet. Note that large images put in headers are visualized as watermarks on printing/exporting to PDF.
At this point, the ribbon and the context menu are not localized out of the box and the users need to change the strings manually.
Currently the following text filters are not supported in the model, filtering popup and Custom Filter dialog: - begins with - does not begin with - ends with - does not end with - contains - does not contain. All of these are supported in MS Excel.
Check how the performance can be improved in this scenario. The StyleGallery is taking much time to load, the GetUsedCellRange method is called multiple times.
If the RadSpreadsheet is declared as a child content in the RadBusyIndicator, there isn't any tab selected as active in the SheetSelector. Workaround: Declare the busy indicator after the RadSpreadsheet not as its child. For example, instead of: <telerik:RadBusyIndicator> <telerik:RadSpreadsheet x:Name="radSpreadsheet" /> </telerik:RadBusyIndicator> Do: <Grid> <telerik:RadSpreadsheet x:Name="radSpreadsheet" /> <telerik:RadBusyIndicator /> </Grid>
Add support for import and export of Excel Template files (XLTS) file format.
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.
The overlapping of SelectionFill and SelectionStroke geometries may be seen in the attached screenshot. This scenario may be reproduced with the following RadSpreadsheet instance: <telerik:RadSpreadsheet SelectionStroke="Red" SelectionStrokeThickness="10" FillHandleSelectionStroke="Green" SelectionFill="#550000FF" />
The default set of WPF UI controls measured in infinity results in the minimal size of the control. RadSpreadsheet should behave the same. This will help users to find out what is happening while debugging.
If a workbook contains a worksheet with RowHeight bigger than 600px (SpreadsheetDefaultValues.MaxRowHeight), an exception is thrown while trying to import such a document.
Enable copy-paste of content from and to Excel, preserving all of the applied formatting, styles and images. Currently, RadSpreadsheet supports only CSV for exchanging clipboard data with Excel, and all formatting (including number formats and data validation) is lost.
If you set "[h]:mm" as a custom format to a cell which has time set to it the calculated value in the cell is wrong for the minutes. The minutes part is interpreted as months.
The number format [hh]:mm causes ArgumentException on import.
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
The visualization and scrolling of documents containing many merged cells (e.g. 1000) is very slow. The control becomes almost unusable when the number increases.