One of the options grouped under alignment is Shrink to Fit. Shrink to fit will automatically reduce the font size until text fits in a cell.

Currently, the text orientation for cell content is not exported when exporting to PDF format.

Introduce support for PDF export of charts.

Introduce thread-safe processing.

When a workbook (xlsx) contains a worksheet where some of the columns have width, bigger than the value written in the SpreadsheetDefaultValues (2000) an exception during the import is thrown.

ArgumentException with clarification similar to  "'\u001f', hexadecimal value 0x1F, is an invalid character." is thrown when trying to export document containing characters which are not supported in XML document - such as some control characters like 0x00, 0x1F, 0x1B, etc. Such characters are described in the XML specification here: https://www.w3.org/TR/xml/#charsets.

Although the escaped strings are not supported (see  https://feedback.telerik.com/Project/184/Feedback/Details/190228 ), the library could prevent the exception and export the document successfully by skipping such characters.

Workaround: remove such characters before the export. Check the following StackOverflow answer for some ideas on code for replacing the characters: http://stackoverflow.com/a/14323524/259206

Fix available in R3 2018 SP1 release.

Such objects are defined as oleObject elements in the XML. Currently, they are skipped on import.

Currently, the chart lines support only solid fill for their outlines.

RadSpreadsheetProcessing does not support chart color customization apart from selecting the color of the outline (set by Series.Outline.Fill). You cannot set the color of the fill of column charts etc.

Add support for the Data Labels in the chart (see attached).

Microsoft Excel supports 2 types of date. Date is the number of days starting from 1/1/1900 or 1/1/1904. The first one is the default the second one has been added cause Macintosh supports it. The Microsoft library supports both of them and you can choose programmatically which one you prefer (https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel._workbook.date1904?view=excel-pia). Expose such an option in SpreadProcessing as well.

When importing a document containing a formula with an invalid reference an exception is thrown: FormulaParseException: 'Unused input [A1] after attempting to parse the formula [#REF!A1]'

Provide a stock method for users to easily set the background color over a specific cell selection.

This happens only on import, that is, if the values are created through UI or through the model, it does not happen. A sheet has a formula A which depends on a cell B and this cell also has a reference to another cell C and the formula A is so placed in the sheet so that it will be imported before cell B. When cell C is updated, the value in A will not be recalculated.

Provide an option to change the display mode of the Worksheet to right-to-left.

Implement SMALL function (https://support.office.com/en-us/article/SMALL-function-17da8222-7c82-42b2-961b-14c45384df07 ), which returns k-th smallest value from a range:

SMALL(array, k)

Workaround: This could be implemented as a custom function: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions.html

Generating document which consists of merged cells in a row and some values then inserting a row on the top and then exporting the document or setting it to the RadSpreadsheet causes wrong merged cells.

If the generation is done on a workbook which is already set to the RadSpreadsheet everything is OK.

Workaround: The document can be exported and then imported again before the row is inserted.

Add support for the SUBTOTAL function: https://support.office.com/en-us/article/SUBTOTAL-function-7b027003-f060-4ade-9040-e478765b9939

It computes the subtotal for some ranges, given the code for the subtotal function:

SUBTOTAL(function_num,ref1,[ref2],...)

where function_num is code referring to some of the functions: AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR, VARP.

Note that we should implement the support for all of the above functions. As of now, COUNTA, VAR, VARP are not supported.

Workaround: This could be implemented as a custom function: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions.html , but multiple functions (4 as of now) has to be additionally implemented.

The MATCH function searches for a specified item in a range of cells and returns the relative position of the item found in this range.

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/CustomFunctions

Available in R3 2017 Official Release Version

Comparison operators (equal '=', not equal '<>') doesn't work as expected with references to empty cells. For example, expressions of type '=IF(A1="", TRUE, FALSE)' are evaluated to false when A1 cell is empty. 

In MS Excel, such expression is evaluated to TRUE if the cell is empty - i.e. empty cell value is considered equal to an empty string "".

Workaround: Use ISBLANK function if possible. Its results are consistent with MS Excel.