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 there is a document with wrapped cells in it, often the content of the cell is not properly displayed in RadSpreadsheet. This results in the content also being shown over the cell below.

Applying a Number number format in a cell and then entering fractional number values like 1.2/2 results in cell value equal to 37258 if it is formatted as a date it will be 1/2/2002.

When entering values in the cells fast some of the values are skipped.

The exception is thrown when pasting in a protected sheet and canceling the warning message box using the MessageShowing event.

The SheetSelectorTabItem background is not properly applied and the text is not readable. This is easily noticeable in themes with a dark color palette. 

Currently, when the user is editing a cell and saves the document without leaving the edit mode first, the current value is not preserved in the saved document.
When pressing the File -> Save button in the ribbon, the Save dialog doesn't appear at all.
Workaround: Manually commit the change before saving. This workaround will also respect data validation:

When a user setups a page and chooses to customize the Header's Odd and Even pages, the tab headers become clipped.

When Esc key is pressed charts dialog should close.

The RadSpreadsheet component Protection feature uses hashing algorithms. When the FipsAlgorithmPolicy is enabled in Windows using the Protection feature causes an InvalidOperationException.

Resizing images always position the image at the cell where the image has been inserted. Flipping image also results in a wrong behavior.

When you chose the Expand XAML option of the RadSpreadsheetRibbon control, the Charts group which should be in the Insert tab, is missing.

Some of the RadSpreadsheet child controls do not apply the new theme, but stay with office black applied when theme is set on control level.

ArgumentException is thrown when protecting a worksheet having missing algorithmName information

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

Add an event that indicates when a hyperlink is clicked.

Xlsx documents with a global filter defined cannot be imported. Message box "The name that you entered is not valid." is shown and internally SpreadsheetNameException is thrown. MS Excel can import such document and even preserve the filter, but do not respect it and doesn't have UI to clear it.

Workaround 1 (includes processing the document with MS Excel):
- Open the document in MS Excel
- Choose Formulas -> Defined names -> Named Manager
- Choose Filter -> Names with errors
- Find all Filter defined names and delete them
- Save the document

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.