Hello, 
we have an Excel export in our software that we solved via Telerik Spreadsheet. 
An exported Excel Table can also contain images. 
These pictures are inserted as shape objects. 
The Placement Property is set to xlMove (xlPlacement Enum) in Excel. 
If you now filter the data in Excel, the images remain and are not hidden. 
We therefore need a way of being able to change this Placement Property to the Value xlMoveAndSize
It would be very desirable if this option were made available in Telerik Spreadsheet as our customers urgently need it.

 Implement the Page Break Preview functionality like in Excel

Implement support for ChartSheet 

Currently, caching formula results is not supported.

A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data that is currently not supported.

Currently, there is an option to export the spreadsheet to PDF file and using RadPdfViewer`s WPF control ThumbnailFactory class to export the PDF document pages to images. Sample code may be seen at this public item: PdfProcessing: Export document pages to images.

Currently, the CellPropertyChanged event gives information only about which property is changed and in which cell range. But you can not get information about the exact change if it is set value, or clear. Also, the CommandExecuted event does not give you information about the executed command. Is if Set command? Clear command or something else.

Hi,

I think it would be really cool to include a search bar in the filter window, as implemented in Excel (Please find attached a screenshot for demonstration). This is a very useful functionality, as there may be too many options to choose from is the filter is added to subject ID, which could result in thousands IDs.

Currently, this can be achieved partially by using the FlowDirection property but the result could be unexpected for right-to-left. 

Right now this functionality is missing and the user is not able to scroll the viewer when the row header is selected and not the cell.

SUBSTITUTE  - replaces text in a given string by matching.
REPLACE - replaces characters specified by location in a given text string with another text string.

The PickCellRange dialog should allow using the formula selection to select cell ranges and convert them into text.

This feature allows automatically to group ordered data in the table and calculate the subtotals of the values column in each group of similar items. The subtotals are included just after each grouped items.

When Esc key is pressed charts dialog should close.

RadSpreadsheet should respect negative time values as MS Excel does it.

Add an event that indicates when a hyperlink is clicked.

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.

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.

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;

In MS Excel, the users can choose between showing the original size of the page and fit it in the window. Expose a similar option in RadSpreadsheet as well.