Approved
Last Updated: 16 Apr 2019 06:05 by ADMIN
When entering values in the cells fast some of the values are skipped.
Approved
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.
Approved
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.
Approved
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.
Approved
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. 

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

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

        }
    }
    
}

Approved
Last Updated: 09 Jun 2017 08:42 by ADMIN
Approved
Last Updated: 21 Jul 2017 10:35 by ADMIN
Setting the visible size property to a small number, like 10,10, will result in missing the last column right border and last row bottom border.
Approved
Last Updated: 08 Sep 2017 08:32 by ADMIN
Selecting a column with two or more merged cells, selects not only the selected column but the rest of columns that the merged cells are from. The behavior when working with rows is analogical.
Approved
Last Updated: 31 Oct 2018 08:11 by ADMIN
Steps to reproduce: 

1. Enter in a cell =Today()
2. Show Format Cells dialog and set Custom format "d"

Expected: The value is the day of the month.
Actual: The date is formatted as short date but has to be day of the month.
Approved
Last Updated: 20 Sep 2017 16:08 by ADMIN
When trying to set the VisibleSize property of RadSpreadsheet on the ActiveSheetChanged event a null exception is thrown in the UpdateSheet method of RadSheetEditorBase. 

Possible workaround is to record the visible size at the SheetChanged event and set it at a later time, e.g. using a timer.
Approved
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.
Approved
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.
Approved
Last Updated: 28 Nov 2017 14:07 by ADMIN
When a sheet that has a new line in a text value is exported and the resulting file is opened in Excel, the value is displayed without a new line. If you enter edit mode and then exit (without confirming the value by pressing enter) the new line will appear. The reason for this behavior is that when there is a new line in a text value Excel automatically applies wrap text on the cell while RadSpreadsheet does not do that. A possible workaround is to apply wrap text on new values with new line in them.
Approved
Last Updated: 27 Mar 2018 11:48 by ADMIN
Cell borders below the cells filled with data are not exported to XLSX.
Approved
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.
Approved
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.
Approved
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" />



Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
We should provide an easier API allowing the customers to remove the key bindings or change the commands that they trigger.

Workaround: There is attached a sample showing how all the commands triggered by the key bindings can be disabled.