The pie chart is not rendered correctly and is not converted to pdf as expected.

Applying conditional formatting to different worksheets and exporting the file to XLSX results in a file with conditional formatting on the active sheet only. The conditional formatting on the rest of the worksheets is lost. 

DataTableFormatProvider: One should be able to set the AllowDBNull property of each column.

The error is with a message "Index and count must refer to a location within the string (Parameter 'count')" and is thrown inside the FormatHelper.FindAllOccurrences method.

The Spilled range operator (#) is responsible for selecting the whole range of values used after a cell reference.

A feature in Excel allows adding ActiveX controls in the Worksheets. You can insert the ActiveX controls from the Developer ribbon tab from the insert button. As it is a missing feature it is not imported and thus removed from the document on export.

Enable the users to execute the macros that are inside their files.

Indirect function cannot get named range by name as string or cell value.

Currently, the notes can contain plain text only. Allow inserting and preserving formatted text inside the notes.

If some notes exist below the inserted/removed cells, the notes need to be moved as well along with the rest of the cells. Currently, after insert/remove, the notes are still associated with the original cell index thus are in the wrong cells.

NullReferenceException when importing a document that contains vml shapes with no row and column

Provide API for converting cell range name to CellRange.

The named ranges are not updated after rows or columns are inserted.

Currently, Formats such as Office 2003 XML are not supported. Introduce support for Excel 2003 XML Format.

The AutoFitWidth functionality does not take into account the filtering button.

Formula evaluation causes an endless loop when importing a specific file

The vertical grid lines are not visible in a scatter chart. The grid lines are visible when opened in Excel.

 

The formula when adding a number to date is not calculated correctly. 

The content of some rows which contain new lines can be clipped when a fixed-width column is wrapped.

This can be observed in the following images.

Before the export:

After the export:

Exception when rounding a decimal value in a formula with a lot of precision numbers