Exception "Format string is not in the correct format" is thrown when importing a file with the following format string: "US$"#,##0.0"m";($#,##0.0)

The exception is thrown in the ValidateDateTimeFormatDescriptor method. 

InvalidOperationException is thrown in files where the Comments part is imported after the ThreadedComments part.

When a sheet is protected in an asynchronous scenario an exception is thrown: System.ArgumentException: 'An item with the same key has already been added. Key: RIPEMD-160'.

Implement a GoalSeek functionality.

 

Introduce support for Implicit Intersection Operator '@'.

FormulaParseException when importing XLS document containing #REF error in formula.

Sometimes leading minus sign in a cell with text is treated as a formula.

A possible workaround is to remove the minus sign or to replace it with some other symbol.

When there are unclosed quotes (") several cells/rows are imported as one.

A possible workaround is to replace all the quote (") symbols with single quote (') symbols.

An exception is thrown if a conditional formatting rule is resolved for a cell with a row index greater than the max column index.

Introduce support for evaluating macros.

Introduce support for PDF export of charts.

Icon sets 'ThreeTriangles', 'ThreeStars', 'FiveBoxes', and 'Custom' are set as a 'ThreeTrafficLightsUnrimmed' when setting a rule.

Add support for NOW function. NOW returns the serial number of the current date and time. If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings.

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

Add support for TEXT function. TEXT lets you change the way a number appears by applying formatting to it with format codes.

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

Column AutoFitWidth is not calculated when the text inside a cell is on more than one line.

Handle import of documents with invalid elements in 'x:fonts'.

In some cases, horizontal bar chart cannot be loaded correctly. This leads to issue when opening the document with the RadSpreadsheet for WPF control.

KeyNotFoundException: when iterating cells having a disabled 'Normal font' formatting option.

Introduce support for TMP images. Currently, the import throws a KeyNotFoundException.

When an xlsm file is imported and then exported, a new ThisWorkbook object is created in the VBA browser. This creates issues when making VBA functions that have to be executed upon opening of the file.