When changing only number separators and leave the default currency separators values entered in the cells are displayed with wrong separators.

When setting Wrap Text to an already merged CellSelection the row height is recalculated according to the cell height instead of keeping the initial height of the row.

At this point, the ribbon and the context menu are not localized out of the box and the users need to change the strings manually.

The chart is blinking when the SetValue method is used

Currently, caching formula results is not supported.

At the moment the print settings set to the WorksheetPageSetup class are not passed to the Print dialog which leads to bad user experience. If you set the print settings of the RadSpreadsheet like so:

WorksheetPageSetup pageSetup = this.radSpreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup;
pageSetup.PageOrientation = PageOrientation.Landscape;

and then select Print, the Spreadsheet print menu will show the print preview as landscape. However, when after that you click on Print for the default print dialog to appear and then click Preferences, you will notice that the preference is set to Portrait. The print job will be Landscape, but the incorrect information in the default dialog creates confusion.

This is an example of how to set the preference of the default dialog:

PrintDialog printDialog = new PrintDialog();
var printTicket = printDialog.PrintTicket;
printTicket.PageOrientation = System.Printing.PageOrientation.Landscape;

The Outline and Marker properties of the Scatter series are not rendered correctly

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

An ArgumentOutOfRangeException is thrown when importing a spreadsheet with the first sheet hidden: VisibleSheetCount should be greater or equal to 1.

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.

The used cell range is expanded when styles to all columns are applied and one copies an entire row.

Workaround:

private void RadSpreadsheet_WorkbookChanged(object sender, EventArgs e)
{
    var range = this.radSpreadsheet.Workbook.ActiveWorksheet.UsedCellRange;
    this.radSpreadsheet.ActiveWorksheet.Columns[range.ColumnCount + 1, SpreadsheetDefaultValues.ColumnCount - 1].Clear(ClearType.All);
}

To reproduce: 

- Select some cells within the same column using Ctrl+Click

- Use the context menu to copy the cells

This works in Excel when the cells are within the same column. 

The background should be stretched along with the item itself. It is currently with specified width.
Workaround: Modify the style and change the width of the tab item. A sample is attached.

Implement UI for hiding sheet. The sheets can be visible, hidden, or very hidden (could be made visible only from the API).

Note: This is already supported on model level (in RadSpreadProcessing).

 Exception when exporting document that contains links with an empty address.

Workaround:

private void Button_Click_1(object sender, RoutedEventArgs e)
{
    foreach (SpreadsheetHyperlink item in this.radSpreadsheet.Workbook.ActiveWorksheet.Hyperlinks.ToList())
    {
        if (string.IsNullOrEmpty(item.HyperlinkInfo.Address))
        {
            this.radSpreadsheet.Workbook.ActiveWorksheet.Hyperlinks.Remove(item);

        }
    }
    
}

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.

To reproduce; 

- Set the language to Korean

- Type "r" in one of the cells

- Use the AutoFill functionality

At this point, FatalExecutionEngineError occurs (see attached).  

Currently it's not possible to disable the fill handle feature. Provide API for disabling it.

Workaround: in the attached project.

The style name "+-" is a valid one, but the StyleGallery crashes because it tries to set the name as a value of a cell and it is not a valid cell value.