We're pleased to announce the release of Spire.XLS for Java 16.2.6. This version supports using Workbook.isPasswordProtected(InputStream stream) to determine password protection by passing a file stream. Meanwhile, some issues that occurred when copying cells, calculating formulas, and converting Excel to PDF have also been successfully fixed. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | SPIREXLS-6079 | Supports Workbook.isPasswordProtected(stream) to determine password protection via file stream.
XlsConditionalFormats format1 = sheet.getConditionalFormats().add();
format1.addRange(sheet.getCellRange("A2:A11"));
|
| Bug Fix | SPIREXLS-6070 | Fixes the issue where the chart count was incorrect after copying cells. |
| Bug Fix | SPIREXLS-6072 | Deprecated the old conditional format adding method and replaced it with XlsConditionalFormats. |
| Bug Fix | SPIREXLS-6080 | Fixes the issue where the slicer effect was incorrect after modifying a table. |
| Bug Fix | SPIREXLS-6081 | Fixes the issue where formula calculations were incorrect. |
| Bug Fix | SPIREXLS-6083 | Fixes a NullPointerException that occurred when loading and saving Excel files. |
| Bug Fix | SPIREXLS-6096 | Fixes the issue where images are displayed incorrectly when converting Excel to PDF. |
Click the link to download Spire.XLS for Java 16.2.6:
