Unplanned
Last Updated: 04 Feb 2020 12:38 by ADMIN

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

Unplanned
Last Updated: 11 Dec 2019 15:26 by ADMIN

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

        }
    }
    
}

Unplanned
Last Updated: 05 Dec 2019 11:20 by ADMIN

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

Unplanned
Last Updated: 20 Jan 2020 05:47 by ADMIN

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. 

Unplanned
Last Updated: 21 Nov 2019 12:29 by ADMIN
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.
Unplanned
Last Updated: 04 Sep 2019 12:19 by ADMIN
Print Preview's "Fit All Columns on One page" does not fit columns on one page.
Unplanned
Last Updated: 18 Apr 2019 08:13 by ADMIN
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.
Unplanned
Last Updated: 16 Apr 2019 06:05 by ADMIN
When entering values in the cells fast some of the values are skipped.
Unplanned
Last Updated: 01 Apr 2019 11:39 by ADMIN
The SheetSelectorTabItem background is not properly applied and the text is not readable. This is easily noticeable in themes with a dark color palette. 
Unplanned
Last Updated: 19 Mar 2019 14:29 by ADMIN
Currently, when the user is editing a cell and saves the document without leaving the edit mode first, the current value is not preserved in the saved document.
When pressing the File -> Save button in the ribbon, the Save dialog doesn't appear at all.
 
Workaround: Manually commit the change before saving. This workaround will also respect data validation:
var layer = ((NormalWorksheetEditorPresenter)radSpreadsheet.ActiveWorksheetEditor.ActivePresenter).UILayers.GetByName(WorksheetPredefinedUILayers.CellInput);
CellInputUILayer cellInputUILayer = (CellInputUILayer)layer;
cellInputUILayer.ApplyChange();
Unplanned
Last Updated: 08 Mar 2019 11:15 by ADMIN
When a user setups a page and chooses to customize the Header's Odd and Even pages, the tab headers become clipped.
Unplanned
Last Updated: 08 Jan 2019 19:24 by ADMIN
Some of the RadSpreadsheet child controls do not apply the new theme, but stay with office black applied when theme is set on control level.
Unplanned
Last Updated: 28 Sep 2018 11:30 by ADMIN
When the PrintPreview has to show many UIElements at once, the performance is slow.
Unplanned
Last Updated: 21 Aug 2018 14:23 by ADMIN
This behavior happens at a specific width of the cell's Column. Using different VerticalAlignment (not Bottom) would workaround this issue.
Unplanned
Last Updated: 06 Jun 2018 15:40 by wu
When the users click on the More Borders option provided in the ribbon UI, the Format Cells dialog opens but the popup of the dropdown is still kept open.
Unplanned
Last Updated: 23 Apr 2018 13:47 by ADMIN
When the InsertFunctionDialog is opened and the "Go" button is pressed with many words entered in the search terms field, the performance is so slow that the application appears hanged.
Unplanned
Last Updated: 20 Feb 2018 08:56 by ADMIN
An ArgumentNullException is thrown when you try to open a document containing relationship namespace declared in the tag.

<sheet name="Management Position View" sheetId="1" d3p1:id="rId1" xmlns:d3p1="http://schemas.openxmlformats.org/officeDocument/2006/relationships" />



Unplanned
Last Updated: 07 Feb 2018 08:13 by ADMIN
The exception is thrown in the QuarterAutoFillGenerator TryParse method due to the unexpected length of the value.

Workaround: Do not use SetValueAsText method by passing an empty string to it. Use SetValue or ClearValue instead.
Unplanned
Last Updated: 27 Mar 2018 12:05 by ADMIN
When the size of the columns is changed using the ColumnSelection.SetWidth(*) method does not update the layout, so subsequent uses of the layout are not calculated correctly. For example BringIntoView method works incorrectly. 

Workaround: call RadSpreadsheet.UpdateLayout() after setting the width.
Unplanned
Last Updated: 27 Mar 2018 11:48 by ADMIN
Cell borders below the cells filled with data are not exported to XLSX.
1 2 3