XLS to XLSX - font boldness and positioning is changed

Aspose.Cells Product Family
1

When converting XLS to XLSX the font boldness and text margins/positioning is not preserved.

Using aspose-cells-20.4.jar

Using this XLS2XLSX code:
com.aspose.cells.LoadOptions loadOptions = new com.aspose.cells.LoadOptions(com.aspose.cells.FileFormatType.EXCEL_97_TO_2003);
com.aspose.cells.Workbook workbook = new com.aspose.cells.Workbook(inputPath, loadOptions);
workbook.save(outputPath, com.aspose.cells.FileFormatType.XLSX);

The XLS and XLSX files:
xls2xlsx.zip (423.0 KB)

Difference between the two files:
image.png (45.8 KB)

2

@simon.wiseman,

After an initial test, I am able to reproduce the issue as you mentioned by using your template file. I found font boldness and positioning is changed for the shape in XLS to XLSX conversion. I have logged a ticket with an id “CELLSJAVA-43216” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@simon.wiseman,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@simon.wiseman,

Please try our latest version/fix: Aspose.Cells for Java v20.6.4：
aspose-cells-20.6.4-java.zip (7.1 MB)

Your issue should be fixed in it.

Let us know your feedback.

5

Thank you, this issue has been fixed using the latest version.

6

@simon.wiseman,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

7

The issues you have found earlier (filed as CELLSJAVA-43216) have been fixed in Aspose.Cells for Java 20.7. This message was posted using Bugs notification tool by Amjad_Sahi

8

Great, thank you for letting me know.

9

@simon.wiseman,
You are welcome.