Inserting a column into a table causes the total rows to the right of the column insert to get corrupted

Aspose.Cells Product Family
,
1

This worked in version 20.1 of Aspose Cells and is not working in the latest version

1.Open the attached solution
2. View TableWithTotalsRow.xlsx
3. Run the code that calls workbook.Worksheets[0].Cells.InsertColumns(3, 3);
4. Try opening TableWithTotalsRowAfterColumnInsert.xlsx. Notice the file is now corrupt
InsertColumnIntoTableCorruptsTotalsRow.zip (5.3 MB)

2

@philipstone,
We have observed this issue and logged in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNET-47903 - Inserting column into a table causes the workbook to corrupt

3

@philipstone,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@philipstone
Please try the latest fix 21.2.9.
Aspose.Cells21.2.9 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.2.9 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.2.9 For .NetStandard20.Zip (5.5 MB)

5

The issues you have found earlier (filed as CELLSNET-47903) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao