Borders can overhang 1 px from the corresponding cells. The issue is reproducible only on some zoom levels, and is most probably related to WPF layout rounding. The issue is mostly visible when borders are missing. On different zoom levels, different borders are hanging.
It would be useful to allow the printer to be chosen directly from the Print Preview control (in the File menu in the ribbon UI). Currently the user should first press Print, and then can choose the printer in the Printer dialog, which is inconvenient.
ArgumentException is thrown ("Error: Argument1" message box in case of importing through RadSpreadsheet) when importing document containing cell with applied custom data validation rule restricting the value of the cell to empty values only - '""' (two double quotes).
Add API for notification when the value in a cell determined by formula is changed. This way the user can find whether by changing a cell value the result of a formula that refers to that cell value is changed. For example: A1: 100 A2: 5 A3: =A1+A2 When A2 is changed, the notification should be rise for A3 (as its value is also changed).
When the user clicks in the gray area of the scrollbars, the view could scroll one page at this direction, similar to what MS Excel do.
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 + ~".
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.
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).
At this point, the formatting can be applied only to the whole cell content.
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.
Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. If we want to be consistent with MS Excel we should implement this property. It is useful for many operations of a region such as filtering(selecting one cell and executing the Filter command should apply it to the current region), sorting, selecting all and etc. This document will be useful: https://docs.microsoft.com/en-us/office/vba/api/excel.range.currentregion.