Add support for Excel 5.0/95 Workbooks.

When exporting to PDF, the hidden sheets should not be included in the layout. Or, at least, there should be an option whether to skip them or not.

Importing a document containing [hh]:mm number format causes an ArgumentException.

Formulas referring to cells containing cell references are not recalculated if the imported document containing cached formula values.

If there are cells in the column with wrapped content, containing text with more than one word, and other cells with smaller content, the auto-fitting does not respect the width of the wrapped cell and sets the column width to the width of the other smaller cells.

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

An exception is thrown when importing a document containing custom number formats with date or time part and empty sections.

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

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:

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

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

 

Formula evaluation causes an endless loop when importing a specific file

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.

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

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.

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

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.

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

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. 

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