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

The chart is blinking when the SetValue method is used

The selected text is not readable when the Worksheet tab is in Edit mode and the applied theme is dark.

Reproducible in NoXaml scenario and for all dark themes except Fluent Dark.

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.

The exception is thrown and the document cannot be imported.

Currently, caching formula results is not supported.

The current worksheet is not updated if the workbook is set while the control is disabled.

Workaround: 

private void RadButton_Click( object sender, RoutedEventArgs e )
{
    radSpreadsheet.IsEnabled = false;
  
    Workbook spreadsheetWorkbook =
        new XlsxFormatProvider( ).Import( File.ReadAllBytes( @"..\..\Book2.xlsx" ) );
  
    radSpreadsheet.Workbook = new Workbook( );
  
    Dispatcher.InvokeAsync( ( ) => radSpreadsheet.Workbook = spreadsheetWorkbook );
  
    radSpreadsheet.IsEnabled = true;
}

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.

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);
}

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

 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).  

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 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.

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.