We are pleased to announce the release of Spire.XLS for Java 12.8.4. This version supports using Worksheet.getMaxDispalyRange() method to get all cell ranges, including objects such as pictures and shapes and supports the =Days() function. Moreover, it also enhances the conversion from Excel to PDF. Additionally, some known issues are fixed, such as the issue that the application threw "NullPointerException" when getting the chart DataRange. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-4002 | Supports using Worksheet.getMaxDispalyRange() method to get all cell ranges, including objects such as pictures and shapes.
Workbook workbook = new Workbook();
workbook.loadFromFile("TEST.xlsx");
Worksheet sheet1 = workbook.getWorksheets().get(0);
//copy all objects(such as text, shape, image...) from sheet2 to sheet1
for(int i=1;i<workbook.getWorksheets().getCount(); i++){
Worksheet sheet2 = workbook.getWorksheets().get(i);
sheet2.copy((CellRange) sheet2.getMaxDisplayRange(),sheet1,sheet1.getLastRow()+1,sheet2.getFirstColumn(),true);
}
workbook.saveToFile("output.xlsx", ExcelVersion.Version2013);
|
| New feature | SPIREXLS-4026 | Supports the =Days() function.
Workbook workbook = new Workbook();
workbook.loadFromFile("Test.xlsx");
Worksheet sheet = workbook.getWorksheets().get(0);
sheet.getCellRange("C4").setFormula("=DAYS(A8,A1)");
workbook.saveToFile(""RES.xlsx"");
|
| Bug | SPIREXLS-3980 | Fixes the issue that the content format was incorrect after converting xml file to Excel. |
| Bug | SPIREXLS-3995 | Fixes the issue that the chart title was incorrect after converting Excel to SVG. |
| Bug | SPIREXLS-4014 | Fixes the issue that the content format was incorrect after converting Excel file to PDF. |
| Bug | SPIREXLS-4020 | Fixes the issue that the application threw "StringIndexOutOfBoundsException" when converting Excel file to PDF. |
| Bug | SPIREXLS-4054 | Fixes the issue that the application threw "NullPointerException" when getting the chart DataRange. |
| Bug | SPIREXLS-4070 | Fixes the issue that the application threw "FileSystemException" when calling Files.deleteIfExists() to delete the file that was detected by the isPasswordProtected() method. |
Click the link to download Spire.XLS for Java 12.8.4:
