When the PrintPreview has to show many UIElements at once, the performance is slow.
This behavior happens at a specific width of the cell's Column. Using different VerticalAlignment (not Bottom) would workaround this issue.
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.
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.
The background should be stretched along with the item itself. It is currently with specified width. Workaround: Modify the style and change the width of the tab item. A sample is attached.
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" />
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.
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.
Cell borders below the cells filled with data are not exported to XLSX.
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.
The exception is thrown when the color for the borders has been previously set using the colors from the predefined palette. The next attempt to set a border color using the ShowMoreColorsDialog leads to error. A message appears to the user saying "Specified cast is not valid".
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.