Shape text font size issue while saving and loading XLS file

Aspose.Cells Product Family
1

@ahsaniqbalsidiqui,

After applying your update, it was noticed that the source and target documents for the value of the text font size within the TextBox object have 14, while by calling the getFont().GetSize() method over the mentioned object, the value 10 is obtained.

shape = shapes.get(3);
assertEquals("TextBox", shape.getClass().getSimpleName());
assertEquals(4, shape.getId());
assertEquals("Sélectionnez \nl'unité", shape.getText());
assertEquals("Arial", shape.getFont().getName());
assertEquals(10, shape.getFont().getSize());    // it should be 14, not 10
2

@zpredojevic,
This issue is reproduced 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:
CELLSJAVA-43935 - Shape text font size issue while saving and loading XLS file

3

@zpredojevic
We are working on this issue.
Since the issue is a bit complicated, we will try to fix it in a week or two.

4

@zpredojevic,

We are pleased to share that your issue has been resolved now. You may expect the fix within the next few days after we have performed QA and included other enhancements and fixes.

5

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

6

@amjad.sahi

Problem still exists on this file.

In the attached screenshot, you can see that the size of the letters in the left shape is not the same, as well as that the shadow from the right shape is lost.

There are test file and code (simple open - save operation) to reproduce stated.

Best regards,
Nenad

report 2.zip (38.4 KB)

7

@zpredojevic,

Thanks for template XLS file and screenshot.

After an initial test, I am able to reproduce the issue as you mentioned by opening the XLS (Excel 5.0/95 Workbook) and saving it to XLS (Excel 97-2003) file format via Aspose.Cells for Java. I found text size and shadow issues for the shapes when re-saving the XLS file format.

W need to evaluate your issue in details. 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): CELLSJAVA-45905

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.

8

@zpredojevic
Please check the attached file
24.3.6.zip (7.2 KB)

generated by inner hot fix 24.3.6.

BTW, Excel95/5 .xls is a very old file format, but this file is saved by advance MS Excel version since office 2007. It would be best if it could be saved as Excel 97-2003 xls or xlsx files which we can support better.

9

The issues you have found earlier (filed as CELLSJAVA-45905) have been fixed in Aspose.Cells for Java 24.4.