We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

XLS to XLSX - font boldness and positioning is changed

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)

@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.

@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.

@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.

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

@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.

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

Great, thank you for letting me know.

@simon.wiseman,
You are welcome.