Implement Show Formulas command, which display the formulas in the cells instead of the result value. In MS Excel, this is available in Formulas -> Formula Auditing -> Evaluate Formula. The keyboard shortcut is "Ctrl + ~".
Implement UI for hiding sheet. The sheets can be visible, hidden, or very hidden (could be made visible only from the API). Note: This is already supported on model level (in RadSpreadProcessing).
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.
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.
XLSB is binary format that should theoretically allow fast reading and writing to the file.
Steps to reproduce: - Open RadSpreadsheet -Put 1 in B2 and B6 -Put 0 in B3, B4, B5 -Add filtering on columns A and B -Filter on column B to have only rows with 1. The rows 3 to 5 will be hidden. -Paste "1234" as cell selection in the Range A2:A6 Note: It is important to enter 1234 in another cell, make a cell selection and then paste it -Remove the filter Expected: "1234" in pasted in cells A2 and A6 only. Actual: "1234" in pasted in cells A2, A3, A4, A5, A6.
This is similar to Visual Studio's IntelliSense, but appears while typing formulas in cells on in the FormulaBar. https://support.office.com/en-us/article/Use-Formula-AutoComplete-6d13daa5-e003-4431-abab-9edef51fae6b
Grouping is a mechanism to organize data in sections, in order to be able to show and hide the relevant chunks. Each row or column which is part of a group is assigned an outline level, which determines the level of grouping and from there which rows or columns it is grouped with.
In MS Excel, there is splitter that can be used to manually resize the formula bar. Also there is an arrow button which expands/collapses the formula bar to the last manually resized size.
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.
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.
Add support for creating Tables and applying tables styles (predefined ones or custom).
Implement functionality to rotate the text in a cell.
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
The sheet selector should hide sheets when their visibility is set to hidden or very hidden. The context menu of the sheet selector should contain Hide and Unhide options that allow to hide a sheet or unhide one of the hidden sheets.
Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.
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.