Provide API to set the position of the second axis (left or right).

Exporting sheet properties corrupts the file and it cannot be opened in Excel.

In the latest version we export: 

<sheetPr>
<pageSetUpPr fitToPage="true" />
<tabColor rgb="FF92D050" />
</sheetPr>

Excel cannot read this and tries to recover the file unsuccessfully. This works in R3 2020.

When importing a document containing a destination that does not refer to a formula an exception is thrown: System.NullReferenceException: 'Object reference not set to an instance of an object.'

When a NonTopLeftCellInMergedRange has a value set the column width is wrongly calculated.

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

At this point, only the styling is preserved without the hyperlink itself. Implement logic to add the hyperlink to the generated PDF document.

Workaround: check the attached project.

Importing XLS document containing defined name with spaces in the sheet name causes exception

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

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

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

Introduce support for the XLOOKUP function.

Exception when importing a file with missing print settings

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

Provide API for converting cell range name to CellRange.

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

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

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

The filter icon is shown in merged cells after import export

Exception when the sheet name contains a single letter 

Currently, if there is an unsupported feature in the imported document it is stripped and not preserved in the document model (the Workbook). When exporting the Workbook the resulting document contains only the supported features.