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.

Creating a chart with a title in excel, importing it in RadSpredsheet, and then exporting it to XLSX changes the size of the chart's title and labels.

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.

Changing the active sheet in code removes the frozen panes.

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

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

There is a discrepancy between RadSpreadProcessing and MS Excel (check the attached record.gif).

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

 

Setting a tab color from API:doesn't fire a UI update.

The chart is blinking when the SetValue method is used

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

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. 

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

        }
    }
    
}

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

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.

Print Preview's "Fit All Columns on One page" does not fit columns on one page.

Applying a Number number format in a cell and then entering fractional number values like 1.2/2 results in cell value equal to 37258 if it is formatted as a date it will be 1/2/2002.

When entering values in the cells fast some of the values are skipped.

The SheetSelectorTabItem background is not properly applied and the text is not readable. This is easily noticeable in themes with a dark color palette.