Hi Aspose Team,
We have come across an issue that a font with trailing whitespace(s) in the full-name attribute within the embedded metadata is not mapped during Excel spreadsheet processing. The trailing whitespaces should be trimmed if it is present in the font. This issue is currently present in the latest Aspose-cells Java library.
Could you please check and confirm if this is a defect and any workaround to avoid this?
Best Regards,
Jose
Could you please share sample files and sample code to reproduce the issue on our end. We will check your issue soon.
I’ve requested sample data from our Engineering team. Please give us some time to compile the data as we cannot provide the customer’s data at this time. Thanks
Sure, please take your time to compile sample and provide us. Once we receive your test case/sample, we will start investigation and analyze your issue.
Hi @Amjad_Sahi,
Apologies for the delay. Please find the font file attached below along with an MS Excel file using the font.
This font file has whitespaces at the end of the Full name:
fullname.png (14.8 KB)
F0134341.zip (8.9 KB)
Thanks,
Jose
Generally, Family name is used in Excel instead of Full name . After installing your shared font file, the font name(family name) bad-font is listed in font drop down box in Excel. So you should use font name bad-font in Excel.
If you don’t want to change the font name in source Excel file. Please try to the following code:
FontConfigs.setFontSubstitutes("bad-font Regular ", new String[] { "bad-font" });
Workbook wb = new Workbook("abcd.xlsx");
wb.save("output.pdf");
Thanks for the update.
Hi @Peyton.Xu,
Our Engineering team would like to know if it is possible to support this as a custom work for IDBS?
So Full name is used instead of the Family name. So, it is consistent with Word and PowerPoint. Because this issue is only present in Excel and not in PowerPoint and Word.
Thanks,
Jose
@IDBSSupport
We have logged a investigation ticket with id CELLSJAVA-45005 for it.
If we have any progress, we will update you.
This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v23.1) which is scheduled in the first half of January 2023. You will be notified once the next release is published.
The issues you have found earlier (filed as CELLSJAVA-45005) have been fixed in Aspose.Cells for Java 23.1.