Spire.XLS for Java 12.7.4 supports custom sorting

2022-07-21 03:25:29

We are pleased to announce the release of Spire.XLS for Java 12.7.4. This version supports custom sorting and supports converting Excel containing chart types defined by Excel 2016 to PDF and images. Moreover, it also enhances the conversion from Excel to HTML and Excel to PDF. Additionally, some known issues are fixed, such as the issue that the line format was changed after adding TrendLines to chart. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-3704 Supports custom sorting.
wb.getDataSorter().getSortColumns().add(0, new String[]
{"12345","Argentina", "Area", "Chile", "Capital","USA","Ecuador","Guyana"}
); wb.getDataSorter().sort(wb.getWorksheets().get(0).getRange().get("A1:A8"));
New feature - Supports converting Excel containing chart types defined by Excel 2016 to PDF and images.
Bug SPIREXLS-3524 Fixes the issue that caused incorrect chart content after converting Excel to PDF.
Bug SPIREXLS-3862 Fixes the issue that caused incorrect line color after converting Excel to Html.
Bug SPIREXLS-3863 Fixes the issue that the chart became blurry after converting Excel to Html.
Bug SPIREXLS-3975 Fixes the issue that caused incorrect data after importing data from datatable in sheet
Bug SPIREXLS-3976 Fixes the issue that the line format was changed after adding TrendLines to chart.
Bug SPIREXLS-3979 Fixes the issue that the content in X axis was incorrect after converting chart to image.
Click the link to download Spire.XLS for Java 12.7.4: