One cannot reference another sheet in a formula by using the UI 

Vertical and horizontal scroll bar moves too fast once outside of the Viewport and one is dragging the selection.

 RadSpreadsheetSheetSelector add options for disabling the reordering and the editing of the sheets 

When filtering a big range of values, the performance is low. The whole UI is re-created.

The MouseWheel event currently is handled in RadWorksheetEditorPresenterBase without a check if the Handled property is set to true.

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. 

At the moment when any of the properties are changed, e.g. the frozen panes, the UI is not notified and you have to export and import the file in order for the UI to pick them up. 


Workaround: There are several workarounds:

1. Change the active worksheet and return to the old one

2. Export and import the document

3. Change the workbook of the RadSpreadsheet to a new one, and return the old one after that
4. Freeze the active worksheet using the ActiveWorksheetEditor.FreezePanes() method and freeze all others using the ViewState:
RadWorksheetEditor editor = this.radSpreadsheet.ActiveWorksheetEditor;
editor.FreezePanes(new CellIndex(3,3));
foreach (var worksheet in this.radSpreadsheet.Workbook.Worksheets)
{
    worksheet.ViewState.FreezePanes(5, 5);
}

Currently, the chart's appearance can be customized through the model API. Let the user be able to customize it using the UI.

Hi,

Excel files containing charts, created in Excel are displayed incorrectly in Telerik spreadsheet control.

Excel view:

 

Telerik:

 

Line colors and dots are incorrect.

Excel file loaded in Telerik WPF demo app. Test file is attached.

Regards Robby

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:

Add formula error checking like in Excel

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.

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.

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.

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

Right borders are not rendered correctly when there is no value. 

Selectionchanged is firing two times when changing the active worksheet.

Selecting a column with two or more merged cells, selects not only the selected column but the rest of columns that the merged cells are from. The behavior when working with rows is analogical.

The SUMIFS function adds all of its arguments that meet multiple criteria.

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/WPF/CustomFunctions

The exception is thrown when the color for the borders has been previously set using the colors from the predefined palette. The next attempt to set a border color using the ShowMoreColorsDialog leads to error. A message appears to the user saying "Specified cast is not valid".