News & Releases
|
|

Spire.XLS for Java 4.2.0 supports adding digital signature
We are happy to announce the release of Spire.XLS for Java 4.2.0. This version supports adding digital signature and adds Group/Ungroup feature or Pivot Table. In addition, it also enhances the conversions from Excel to PDF/Image. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | - | Supports adding digital signature.
GetCertAndPrivateKeyFromPFX certAndPrivateKeyFromPFX=new GetCertAndPrivateKeyFromPFX(); HashMap<X509Certificate,PrivateKey> hashMap=certAndPrivateKeyFromPFX.getCertAndPrivateKeyFromPFX(inputFile_pfx); IDigitalSignatures dsc = workbook.addDigitalSignature(hashMap.keySet().iterator().next(), hashMap.get(hashMap.keySet().iterator().next()), "e-iceblue", calendar.getTime()); workbook.isDigitallySigned(); workbook.removeAllDigitalSignatures(); |
| New Feature | SPIREXLS-2921 | Supports Group/Ungroup function for Pivot Table.
//Group
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setManualGroupField(r1,7,15, EnumSet.of(PivotGroupByType.RangeOfValues),5);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
//Ungroup
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setUngroup(r1);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
|
| Bug | SPIREXLS-2981 | Fixes the issue that an error prompted when opening the result file after inserting special symbols into Excel. |
| Bug | SPIREXLS-3035 | Fixes the issue that the inserted OLE object in the result file could not be opened normally. |
| Bug | SPIREXLS-3039 | Fixes the issue that the chart data was missing after converting Excel to images. |
| Bug | SPIREXLS-3043 | Fixes the issue that the application threw the error “Specified argument was out of the range of valid values” when converting Excel to PDF on Linux. |
| Bug | SPIREXLS-3081 | Fixes the issue that the application threw the error “NumberFormatException” when converting Excel to PDF. |
Click the link to download Spire.XLS for Java 4.2.0: