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

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

The full data for the images is not copied and they are missing in the target worksheet.

The XlsFormatProvider currently doesn't support charts and skips them while importing or exporting a document.

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

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.

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

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

When importing a document with encrypted records a NotImplementedException is thrown: System.NotImplementedException: "Implement it based on poi 4.2 in the future".

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.

Add support for Excel 5.0/95 Workbooks.