The WorkbookContentChanged event is invoked right after importing a document.
The outline properties of the chart series are not respected by most charts.
The scale factor is not imported from documents with no information about the selection state.
Value of a cell is visualized outside of the cell boundaries, or the value is clipped and partially visible, when the cell is updated (from code-behind), while being in an inactive worksheet, and is referenced by another cell from the active sheet. Workaround: get a value of some cell in the active sheet and set it again to the same cell. The issue is reproducible after the official release of Q1 2015.
Setting up a paper size to A1 and exporting it actually sets the paperSize to 1. Using the same scenario in Excel sets the paperSize to 305.
This leads to inappropriate values when entering the Page Setup options later in Excel.
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.'