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
Combo chart with datetime axis and line/bar/area as a first series and scatter series as a second one throws InvalidCastException.
This can happen both with opening an xlsx file with such a chart or creating it in code. Such a chart cannot be created with the Insert Chart dialog (combo type is not yet supported via UI).
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;
}
RadSpreadsheet exposes API enabling the users to control the visibility of the sheet selector:
RadSpreadsheetSheetSelector.SetIsSheetSelectorVisible(radSpreadsheet, isVisible);
When the SetIsSheetSelectorVisible method is invoked with false value for the isVisible parameter, its parent container is still visible in the UI.
When attaching to the CellPropertyChanged event and trying to modify the cell an exception is thrown:
if firstly detached from the event and then modify the cell the exception is:
System.InvalidOperationException: 'Collection was modified; enumeration operation may not execute.'
else:
System.StackOverflowException: 'Exception of type 'System.StackOverflowException' was thrown.'
If a workbook contains a worksheet with RowHeight bigger than 600px (SpreadsheetDefaultValues.MaxRowHeight), an exception is thrown while trying to import such a document.
Please add support for cell content rotation.
I know that this is listed in the known unsupported features article, but just to be extra clear about what I am requesting, here's an example from Microsoft Excel
When the column width is decreasing below the size of the filter button the size of the button remains the same and overlaps the previous button.
Reproducible in NoXaml scenario and for all dark themes except Fluent Dark.
The scroll exceeds the visible area when using the auto-fill.
Steps to reproduce:
- Set the VisibleSize to (10 ,10)
- Drag the autofill icon down
this.radSpreadsheet.ActiveWorksheet.ViewState.TabColor = new ThemableColor(Colors.Red);