Problem by expanding a table with placed empty merged cells under the table

Aspose.Cells Product Family
1

Hallo dear Support,

In attachment a simple demo program with the problem.
MergedCells.zip (78.5 KB)

Workflow implemented in demo to reproduce the problem:

  1. Crete 2 Tables (ListObjectCollection)
  2. Under both tables placed merged cells
  3. The merged cells under first table has been filled with some text
  4. The merged cells under second table left empty
  5. Both tables has been filled with some values, so that tables has been expanded (by using listObjects.PutCellValue(…))
  6. Open result xlsx file and check content

Result: by try to open file a message, that file content has been broken, by recovery a file the second table is broken, but first table has been handled correctly

Could you fix please the behavior in future releases? So that behavior of second table is the same as by first table

BR, Ilia

2

@ILVO
By using the sample code to test on the latest version v24.6, we can reproduce the issue. Discovered that the result file is corrupted when expanding a table with placed empty merged cells under the table.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-56048

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@ILVO,

We are pleased to inform you that your issue (logged as “CELLSNET-56048”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v24.7) which we plan to release in the second week of July (next month). You will be notified when the next version is released.

4

Good, thank you very much!

5

@ILVO,

You are welcome.

6

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