The alignment of cells with custom formatting is not respected after PDF export.

Introduce support for Implicit Intersection Operator '@'.

In some cases when cells are merged the cell borders are not correctly imported.

The chart size is not correctly set when the TwoCellAnchor contains similar elements

Value is treated as a number when the ampersand operator is used.

The MATCH function does not work as expected. Should work exactly like in Excel. 

When a cell contains a lot of empty lines the last line is not rendered correctly.

Filter Selection dialog appears on the screen. 

Workaround: Open the file with Excel and save it as a new document.

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

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

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

Implement a GoalSeek functionality.

 

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.

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

Introduce support for PDF export of charts.

The import process takes much time when the formatting of the cells needs to be resolved. 

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