- 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.
- Set the language to Korean
- Type "r" in one of the cells
- Use the AutoFill functionality
At this point, FatalExecutionEngineError occurs (see attached).
Exception when exporting document that contains links with an empty address.
Workaround:private void Button_Click_1(object sender, RoutedEventArgs e)
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.
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.
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.
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.
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.
This behavior happens at a specific width of the cell's Column. Using different VerticalAlignment (not Bottom) would workaround this issue.
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.
Cell borders below the cells filled with data are not exported to XLSX.
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.
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.
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" />
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.