News Category

Spire.XLS for Java 4.12.2 supports converting excel file to OFD

2021-12-21 09:46:47

We are happy to announce the release of Spire.XLS for Java 4.12.2. This version supports converting excel file to OFD and supports "Subtotal" function. Also, it enhances the conversion from Excel to PDF, Excel to image. In addition, it fixes some known issues such as the "Wrap text" didn't take effect after merging cells. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-3568 Supports converting excel file to OFD.
Workbook workbook = new Workbook();
workbook.loadFromFile("input.xlsx");
workbook.saveToFile("output.ofd", FileFormat.OFD); 
New feature SPIREXLS-3571 Supports "Subtotal" function.
Workbook workbook = new Workbook();
workbook.loadFromFile(inputFile);
Worksheet sheet = workbook.getWorksheets().get(0);
//Select data range
CellRange range = sheet.getRange().get("A1:B18");
//Subtotal selected data
sheet.subtotal(range, 0, new int[] { 1 }, SubtotalTypes.Sum, true, false, true);
//Save to file.
workbook.saveToFile(outputFile, ExcelVersion.Version2010);
workbook.dispose(); 
Bug SPIREXLS-3413 Fixes the issue that the "Wrap text" didn't take effect after merging cells.
Bug SPIREXLS-3486
SPIREXLS-3545
Fixes the issue that the content format was incorrect when converting excel file to PDF.
Bug SPIREXLS-3564
SPIREXLS-3565
Fixes the issue that the application threw "Unknown char:" error when saving a chart as an image.
Bug SPIREXLS-3566 Fixes the issue that the effect of converting pdf was incorrect after setting "blackAndWhite" as "true".
Bug SPIREXLS-3567 Fixes the issue that the trend line was lost when saving chart as image.
Bug SPIREXLS-3569 Fixes the issue that the chart content format was incorrect when converting excel file to image.
Click the link to download Spire.XLS for Java 4.12.2