When the formula bar is empty and alt + enter is pressed in order to insert a new line, NullReferenceException is thrown. The exception might be reproduced with text in the formula bar, but the caret has to be placed in the end of a run/end of the text.

Fix available in LIB Version 2018.2.820.

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

In MS Excel, the users can choose between showing the original size of the page and fit it in the window. Expose a similar option in RadSpreadsheet as well.

The COUNTIF function is already available in RadSpreadsheet.

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.

The SUMIFS function adds all of its arguments that meet multiple criteria.

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/WPF/CustomFunctions

Currently, to change the title of the ribbon, the users need to replace RadSpreadsheetRibbon with its XAML code. Expose a property allowing to do this change directly from RadSpreadsheetRibbon.

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.

Allow loading of dialogs (SpellCheckAllAtOnce and SpellCheckWordByWord) different than the default ones through MEF. 

Use-cases: set different Width and Height, hide buttons (e.g. AddToDictionary), etc. 

- Async parse of single xml file to speed-up the import
- Allow to import only part of the file
- Respect the widths of the columns and row heights and do not measure them first time in the WorksheetLayout or measure them for the current Viewport only
- Inserting rows/columns also need improvements in terms of performance.

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.

In MS Excel, the users have the option to specify that the data contains a header row. When this option is enabled, the first row of the column is not included in the sorted range. Implement this option in RadSpreadsheet as well.

When filtering a big range of values, the performance is low. The whole UI is re-created.

Currently, changing the sheets performs heavy calculations on the UI thread. This does not allow to perform any other UI task and the busy indicator cannot be shown before all layers are rendered.

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.

At the moment the theme of the RadSpreadsheetRibbon can be set only by setting the theme of the entire application. The individual setting (using telerik:StyleManager.Theme="Windows8") should also be supported.

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.