In newer versions of EXCEL (2019 and later) the CONCAT function is introduced as a replacement of the old CONCATENATE function. It adds the ability to specify a range of cells when generating the resulting string in addition to its previously supported input arguments.
NOTE: In EXCEL starting from version 2019, CONCATENATE can no longer be inserted in the worksheet through the UI, it can only be used if you type it directly in the cell's contents.

When importing a document with an unclosed <br> element in the vmlDrawing part an exception is thrown: System.Xml.XmlException: 'The 'br' start tag on line 183 position 14 does not match the end tag of 'font'. Line 184, position 7.'

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 formula when adding a number to date is not calculated correctly. 

Provide API for converting cell range name to CellRange.

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.

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.

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

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

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

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

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

From the OOXML Specification: A comment is a rich-text note that is attached to and associated with a cell, separate from other cell content.

In Office 365 there are two types of comments:

• Comments/Notes
• Threaded Comments

This item applies to Comments/Notes only.

For Threaded Comments, please follow: SpreadProcessing: Comments (Threaded Comments)

Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.

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 full data for the images is not copied and they are missing in the target worksheet.

When importing a document containing a formula with an invalid reference an exception is thrown: FormulaParseException: 'Unused input [A1] after attempting to parse the formula [#REF!A1]'

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

 

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