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.

Formula evaluation causes an endless loop when importing a specific file

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

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:

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

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

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.

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.

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.

RadSpreadsheetProcessing does not support chart color customization apart from selecting the color of the outline (set by Series.Outline.Fill). You cannot set the color of the fill of column charts etc.