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]'

According to the Open XML documentation, the possible max value for this attribute is an unsignedInt or 4294967295.

Hi,

Range name becomes incorrect after removing row in a spreadsheet.

Use case:

- Set range name to 'test' on cell A5

- Remove row 4 (option entire row)

Observed:

- Range name is still located on cell A5

Expected:

- Range name 'test' on cell A4. Similar behavior as in MS Excel

 

Can be reproduced using the Telerik WPF demo app.

 

The named ranges are not updated after rows columns are inserted.

This item is migrated to the Telerik Document Processing portal: https://feedback.telerik.com/document-processing/1549293. Please, use the new item for commenting, voting, and subscribing instead of this one.