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