Font color of "notes" changed to white when copying selective data from excel workbook to other workbook using Aspose

Aspose.Cells Product Family
1

We have xlsb file from which we are copying data to other excel file using Aspose.Cells where we observed the final output is having “Notes” font color changed from black(original) to white.

Please find below the console application for the same
NotesLosingColor.zip (302.6 KB)

Please find the original excel file attached below
xlsb.zip (217.9 KB)

With the help of above console application I am saving all the sheet by sheet output to see the difference.
Please find below the observation

Sheet having notes Output sheetname where color is retained Output sheet where color changed
Summary dldSummary_1.xlsb till dldNASDR_9.xlsb dldInstallationAndEngineering_10.xlsb
2

@nraj,

I did test your scenario/case using your sample app with your template Excel file. I could not notice significant difference in the copied data in your mentioned output file. Could you please share more details and some screenshots to highlight the difference/issue by comparing source sheet(s) in the template Excel file Vs copied sheet(s). This way, we will understand the issue to reproduce it first and then we can log an appropriate ticket for it.

3

Please find attached the screenshot with issue description
NotesFont.zip (332.3 KB)

4

@nraj,

Thanks for the screenshots and details.

I am able to reproduce the issue as you mentioned (via screenshots) by using your sample file and application. I found that the font color of “notes” or “comments” in the “Summary” sheet of “dldInstallationAndEngineering_10.xlsb” (output) file changed to white when copying selective data from Excel workbook to other workbook.

We require thorough evaluation of the issue. 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-55756

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.

5

@nraj,

We are pleased to inform you that your issue (logged as “CELLSNET-55756”) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.6) that we plan to release in the first half of June 2024. You will be notified when the next version is released.

6

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