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.

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.

When the PrintPreview has to show many UIElements at once, the performance is slow.

This item is moved, because it is related to the RadSpreadsheet's model. You can find the corresponding item here: https://feedback.telerik.com/Project/184/Feedback/Details/255960-spreadprocessing-incompatibility-with-microsoft-excel-of-in-document-hyperlinks

The functionality would allow to zoom the print preview and scroll the resulting viewport.

A partial implementation of the zooming functionality can be found in the attached file to provide a starting point for a custom implementation.

This behavior happens at a specific width of the cell's Column. Using different VerticalAlignment (not Bottom) would workaround this issue.

The PrintPreviewControl refreshes its preview content on change in the SheetPageSetup object. This method would allow on-demand update.

At the moment this can be achieved by changing something in the page setup and restoring it. 

bool printGridlines = this.spreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup.PrintOptions.PrintGridlines;
this.spreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup.PrintOptions.PrintGridlines = !printGridlines;
this.spreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup.PrintOptions.PrintGridlines = printGridlines;