News Category

Spire.XLS for Java 5.3.3 supports setting text direction for the chart category axis

2022-03-22 01:30:24

We are happy to announce the release of Spire.XLS for Java 5.3.3. This version supports setting text direction for the chart category axis as well as sorting for a Table, and enhances the conversion from Excel to image, Excel to PDF. In addition, it fixes some known issues such as the application threw "NullPointerException" when appending a rich text. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-3641 Supports setting text direction for the chart category axis.
chart.getPrimaryCategoryAxis().setTextDirection(TextVerticalValue.EastAsianVertical);
New feature SPIREXLS-3706 Supports sorting for a Table.
Workbook workbook = new Workbook();
workbook.loadFromFile(inputFile);
Worksheet sheet = workbook.getWorksheets().get(0);
// Add a new List Object to the worksheet
IListObject listObject = sheet.getListObjects().create("table", sheet.getCellRange(1, 1, 19, 5));
// Add Default Style to the table
listObject.setBuiltInTableStyle(TableBuiltInStyles.TableStyleLight9);
listObject.getAutoFilters().getSorter().getSortColumns().add(2, OrderBy.Ascending);
listObject.getAutoFilters().getSorter().sort(sheet.getCellRange(1, 1, 19, 5));
Bug SPIREXLS-3650 Fixes the issue that the text position was incorrect after converting excel to image.
Bug SPIREXLS-3691 Fixes the issue that the application threw "NullPointerException" when appending a rich text.
Bug SPIREXLS-3692 Fixes the issue that the pagination was inconsistent after converting excel to PDF.
Bug SPIREXLS-3713 Fixes the issue that the application threw "NullPointerException" when copying a worksheet.
Bug SPIREXLS-3714 Fixes the issue that the application threw "NullPointerException" when calculating the PivotTable data.
Bug SPIREXLS-3725 Fixes the issue that it didn't take effect when setting "false" for chart.hasChartTitle().
Click the link to download Spire.XLS for Java 5.3.3: