Black cell boarder appeared after saving xlsb file format

Aspose.Cells Product Family
1

The original file was created in Excel desktop. The cells of the table were formatted with gray cell boarder or no boarder. After saving the file in Aspose.Cells .Net, black cell boarder appeared.

The issue only appears in Xlsb file format. Xlsx format doesn’t have such issue.

Before saving:
before.png (9.1 KB)

After saving:
after.png (9.3 KB)

Sample files:
New folder (2).zip (43.7 KB)

Sample code:
static void Save()
{
Workbook wbk = new Workbook(“C:\Book2.xlsb”, new LoadOptions(LoadFormat.Xlsb));
wbk.Save(“.\test.xlsb”, SaveFormat.Xlsb);
wbk.Dispose();
}

2

@hchc
By using sample files for testing, we can reproduce the issue. After resaving the xlsb file, it was discovered that there were extra borders and the border color had also been changed.

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-54998

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

Thank you for confirming.

4

@hchc
You are welcome. If you have any questions, please feel free to contact us.

5

@hchc,

We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v24.2) that we plan to release in the first half of February 2024. You will be notified when the next version is released.

6

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

7

Thank you for your update.

8

@hchc
You are welcome. If you have any questions, please feel free to contact us.