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

Cell Values disappearing when RadWindow is dragged to a second Monitor.

Workaround:

private void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
    this.viewModel.OpenSampleCommand.Execute(null);
    radDocking1.ToolWindowCreated += RadDocking1_ToolWindowCreated;
}

private void RadDocking1_ToolWindowCreated(object sender, Telerik.Windows.Controls.Docking.ElementCreatedEventArgs e)
{
    var window = e.CreatedElement as ToolWindow;
    if (window != null)
    {
        window.WindowStateChanged += Window_WindowStateChanged;

    }
}

private void Window_WindowStateChanged(object sender, EventArgs e)
{
    var window = sender as ToolWindow;

    var spreadsheet = window.ChildrenOfType<RadSpreadsheet>().FirstOrDefault();
    if (spreadsheet != null)
    {
        spreadsheet.InvalidateVisual();
    }
}

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

Workaround: 

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. 

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.