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

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

Adding a formula with the SetValueAsFormula method is slow

Text is cut off when exporting to pdf with a specific font.

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

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

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.

Hello,

we would like to have the capability to create a chart in excel export using Telerik.Documents.Spreadsheet 

Marcos

If a workbook with data validation makes use of a formula which has a string in it, on import and export, the data validation will become invalid.

If the column has a text format set and has a mixture of text and numbers, the numbers should be exported as text as well.