Spire.Office for Java 4.2.0

Spire.Office for Java 4.2.0 is released

We are happy to announce the release of Spire.Office for Java 4.2.0. This version brings some new features, for example, Spire.Doc for Java supports locking; Spire.XLS for Java supports adding digital signature content controls and adds Group/Ungroup feature or Pivot Table. Meanwhile, a lot of bugs have been fixed. More details are given below.

Click the link to download Spire.Office for Java 4.2.0:

Here is a list of changes made in this release

Spire.Barcode for Java

Category ID Description
Bug SPIREBARCODE-123 Fixes the issue that the scanned result of the QR code was incorrect.
Bug SPIREBARCODE-136
SPIREBARCODE-175
Fixes the issue that the generated Code128 barcode displayed incompletely under Linux OS.

Spire.PDF for Java

Category ID Description
Bug SPIREPDF-2941 Fixes the issue that the text was fuzzy when converting PDF to HTML.
Bug SPIREPDF-3247
SPIREPDF-3760
Fixes the issue that the Chinese characters turned garbled characters when converting PDF to Images.
Bug SPIREPDF-3876 Fixes the issue that the images inserted in the PDF Grid cell were not centered correctly.
Bug SPIREPDF-3915 Fixes the issue that the images were blank when converting PDF to Images.

Spire.Doc for Java

Category ID Description
New Feature SPIREDOC-5340 Supports the function of locking content controls.
sd.getSDTProperties().setLockSettings(LockSettingsType.SDT_Locked);
sd.getSDTProperties().setLockSettings(LockSettingsType.SDT_Content_Locked);
Bug SPIREDOC-4031 Fixes the issue that the content was overlapped when converting Word to PDF.
Bug SPIREDOC-4601 Fixes the issue that the alignment style of paragraph was changed when converting Word to PDF.
Bug SPIREDOC-4709 Fixes the issue that image path was wrong when converting Word to Html on Linux/Mac OS.
Bug SPIREDOC-4911
SPIREDOC-5186
Fixes the issue that page number style was incorrect when converting Word to PDF.
Bug SPIREDOC-5041 Fixes the issue that the header content's position was incorrect when converting Word to PDF.
Bug SPIREDOC-5120 Fixes the issue that finding text failed.
Bug SPIREDOC-5235 Fixes the issue that the content was garbled when loading and saving a doc file.
Bug SPIREDOC-5208
SPIREDOC-5209
Fixes the issue that the color of the small lock with the red seal was changed from yellow to black and the seal covered the text when converting Word to PDF.
Bug SPIREDOC-5211 Fixes the issue that the value of tab in footer was changed after adding new page.
Bug SPIREDOC-5228 Fixes the issue that the application threw "Specified argument was out of the range of valid values" when converting Word to PDF.
Bug SPIREDOC-5235 Fixes the issue that there was extra content when converting Word to PDF.
Bug SPIREDOC-5279 Fixes the issue that the blank paragraph lost when converting Word to PDF.
Bug SPIREDOC-5305 Fixes the issue that the seal obscured the text when converting Word to PDF.
Bug SPIREDOC-5337 Fixes the issue that the output SVG file path was wrong when converting Word to SVG on Linux OS.
Bug SPIREDOC-5351 Fixes the issue that the table borders lost and list number was incorrect converting Word to PDF.

Spire.Presentation for Java

Category ID Description
Bug SPIREPPT-1076 Fixes the issue that the content was messy after converting PPT to image using OpenJDK.
Bug SPIREPPT-1092
SPIREPPT-1095
SPIREPPT-1344
Fixes the issue that the content was incorrect when converting PPT to image
Bug SPIREPPT-1173 Fixes the issue that the text location was incorrect when scaling the DPI setting of system to 125%.
Bug SPIREPPT-1186 Fixes the issue that the text location was incorrect when the DPI setting of system is 100%.
Bug SPIREPPT-1309 Fixes the issue that the content format was incorrect after converting PPT to PDF/HTML
Bug SPIREPPT-1358 Fixes the issue that the application threw the exception "java.lang.NullPointerException:null" when extracting name of animations.
Bug SPIREPPT-1399
SPIREPPT-1441
Fixes the issue that the application threw the exception "java.lang.ArrayIndexOutOfBoundsException" when loading PPT document.
Bug SPIREPPT-1229 Fixes the issue that the application threw the exception "java.lang.ClassCastException" when loading PPT document.
Bug SPIREPPT-1420 Fixes the issue that the application hung when loading PPT document.
Bug SPIREPPT-1425 Fixes the issue that the content was cropped after converting shape to image.

Spire.XLS for Java

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.