This is the list of changelogs of Spire.XLS for Java New release and hotfix. You can get the detail information of each version's new features and bug solutions.
Download Spire.XLS for Java to start a free trial:
Version: 13.11.6
Category | ID | Description |
Bug | SPIREXLS-4966 | Fixes the issue that the application threw the "java.lang.NullPointerException" exception when converting worksheets to HTML documents. |
Bug | SPIREXLS-4967 | Fixes the issue that excessive "0" characters occurred in the text content when converting Excel documents to HTML documents. |
Bug | SPIREXLS-4968 | Fixes the issue that the cell content was partially lost when converting Excel to PDF after setting the cell to auto-fit row height. |
Bug | SPIREXLS-4970 | Fixes the issue that incorrect content was obtained from merged cells. |
Bug | SPIREXLS-4975 | Fixes the issue that incorrect results were returned by string searches. |
Bug | SPIREXLS-4977 | Fixes the issue that the chart references were updated incorrectly when copying worksheets. |
Bug | SPIREXLS-4990 | Fixes the issue that incorrect DisplayedText values were obtained. |
Version: 13.11.0
Category | ID | Description |
New feature | SPIREXLS-4919 | Supports retrieving comments from the Name Manager.
Workbook workbook = new Workbook(); workbook.loadFromFile(inputFile); INameRanges nameManager = workbook.getNameRanges(); StringBuilder stringBuilder = new StringBuilder(); for (int i = 0; i < nameManager.getCount(); i++) { XlsName name = (XlsName) nameManager.get(i); stringBuilder.append("Name: " + name.getName() + ", Comment: " + name.getCommentValue() + "\r "); } workbook.dispose(); |
Bug | SPIREXLS-4911 | Improves the speed of converting Excel to PDF on Linux. |
Bug | SPIREXLS-4860 | Fixes the issue that the page size setting failed after setting the setSheetFitToPage method when converting Excel to PDF. |
Bug | SPIREXLS-4894 | Fixes the issue that removing pivot table borders failed. |
Bug | SPIREXLS-4906 | Fixes the issue that text was reversed and cropped after converting Excel to PDF. |
Bug | SPIREXLS-4923 | Fixes the issue that the program threw "Invalid ValidationAlertType" when reading an Excel file. |
Bug | SPIREXLS-4924 | Fixes the issue that the program threw "Input string was not in the correct format" when reading an Excel file. |
Version: 13.10.0
Category | ID | Description |
New feature | SPIREXLS-4896 | Supports verifying whether the password for restricted editing is correct.
worksheet.checkProtectionPassword(String password) |
Bug | SPIREXLS-4879 | Fixes the issue that the content of the document was incorrect when converting Excel to PDF. |
Bug | SPIREXLS-4890 SPIREXLS-4908 |
Fixes the issue that the content in charts was incorrect when converting Excel to images. |
Bug | SPIREXLS-4893 | Fixes the issue that table borders were lost when converting Excel to OFD. |
Bug | SPIREXLS-4900 | Fixes the issue that the program threw "Invalid ValidationAlertType string val" when loading an Excel file. |
Bug | SPIREXLS-4901 | Fixes the issue that pivot table calculated fields couldn’t be added as column fields. |
Bug | SPIREXLS-4902 | Fixes the issue that the names of pivot table calculated fields were automatically prefixed with "Sum of". |
Bug | SPIREXLS-4910 | Fixes the issue that the program threw "java.lang.ClassException" when loading an Excel file. |
Version: 13.9.2
Category | ID | Description |
New feature | SPIREXLS-4731 | Optimizes the conversion time from Excel to PDF. |
New feature | SPIREXLS-4852 | Adds the function of finding cells based on regular expressions. |
Bug | SPIREXLS-3760 | Fixes the issue that the program threw "sun.security.x509.X509CertImpl" exception when using spire.xls.jar under IBM websphere. |
Bug | SPIREXLS-4873 | Fixes the issue that the program threw "Input string was not in the correct format" exception when loading documents. |
Version: 13.8.1
Category | ID | Description |
New feature | SPIREXLS-4797 | Supports setting images for the first page header and footer.
//Set image for first page header worksheet.getPageSetup().setFirstLeftHeaderImage(img_LFH); worksheet.getPageSetup().setCenterHeaderImage(img_LCH); worksheet.getPageSetup().setRightHeaderImage(img_LRH); //Set image for first page footer worksheet.getPageSetup().setLeftFooterImage(img_LFF); worksheet.getPageSetup().setCenterFooterImage(img_LCF); worksheet.getPageSetup().setRightHeaderImage(img_LRF); //Set image size worksheet.getPageSetup().setFirstLeftHeaderPictureHeight(50); worksheet.getPageSetup().setFirstLeftHeaderPictureWidth(50); worksheet.getPageSetup().setFirstCenterHeaderPictureHeight(50); worksheet.getPageSetup().setFirstCenterHeaderPictureWidth(50); worksheet.getPageSetup().setFirstRightHeaderPictureHeight(50); worksheet.getPageSetup().setFirstRightHeaderPictureWidth(50); |
New feature | SPIREXLS-4831 | Supports getting the hyperlinks of pictures.
ExcelPicture picture = sheet.getPictures().get(0); HyperLink link = picture.getHyperLink(); String address = link.getAddress(); |
Bug | SPIREXLS-4078 | Fixes the issue that Excel files saved in Tomcat had garbled formulas. |
Bug | SPIREXLS-4737 | Fixes the issue that opening files converted from Excel to PDF in Adobe resulted in an error. |
Bug | SPIREXLS-4770 | Fixes the issue that the content formatting of files converted from Excel to images was incorrect. |
Bug | SPIREXLS-4800 | Fixes the issue that setting the maximum row was not taking effect. |
Bug | SPIREXLS-4821 SPIREXLS-4840 |
Fixes the issue that the program threw "NullPointerException" when converting Excel to PDF. |
Bug | SPIREXLS-4822 | Fixes the issue that Excel files saved in WinServer2012 had garbled content in dropdown menus. |
Bug | SPIREXLS-4829 | Fixes the issue that the program threw "NullPointerException" when loading Excel files created with the new version of WPS. |
Bug | SPIREXLS-4837 SPIREXLS-4839 |
Fixes the issue that the program threw "NullPointerException" when loading Excel files. |
Version: 13.7.3
Category | ID | Description |
Bug | SPIREXLS-4745 | Optimizes the time consumption of getting the number of pages. |
Bug | SPIREXLS-4758 | Fixes the issue that the converted PDF failed to open with adobe under the regional setting of Portugal and Brazil. |
Bug | SPIREXLS-4759 | Fixes the issue that the program threw an exception NullPointerException when using calculateAllValue. |
Bug | SPIREXLS-4760 | Fixes the issue that the contents overlapped when converting Excel to pictures. |
Bug | SPIREXLS-4761 | Fixes the issue that the number of pages obtained was incorrect. |
Bug | SPIREXLS-4779 | Fixes the issue that extra content appeared when converting Excel to PDF. |
Bug | SPIREXLS-4780 | Fixes the issue that the content was lost when converting Excel to PDF. |
Version: 13.6.5
Category | ID | Description |
Bug | SPIREXLS-4691 | Fixes the issue that the horizontal axis of charts changed after adding watermarks. |
Bug | SPIREXLS-4692 SPIREXLS-4735 |
Fixes the issue that content changed after saving "et" format document as a new document. |
Bug | SPIREXLS-4713 | Fixes the issue that the content changed after converting Excel to PDF. |
Bug | SPIREXLS-4730 | Fixes the issue that the application threw exception "Culture ID: 14345 is not a supported culture" when converting Excel to PDF. |
Bug | SPIREXLS-4732 | Fixes the issue that the document displayed differently in WPS and Microsoft Excel after adding watermark. |
Bug | SPIREXLS-4739 | Fixes the issue that the image was lost after loading a document and saving it as a new document. |
Version: 13.6.0
Category | ID | Description |
Bug | SPIREXLS-4611 | Fixes the issue that the font effects were inconsistent when converting Excel to images. |
Bug | SPIREXLS-4639 | Fixes the issue that the superscript and subscript format was lost when converting Excel to images. |
Bug | SPIREXLS-4642 | Fixes the issue that the horizontal coordinate of the chart changed after adding an image watermark. |
Bug | SPIREXLS-4650 | Fixes the issue that the program hangs when loading Excel documents. |
Bug | SPIREXLS-4669 | Fixes the issue that setting the background color of the pivot table column name field failed. |
Bug | SPIREXLS-4671 | Fixes the issue that the document data lost after adding an image watermark. |
Bug | SPIREXLS-4679 | Fixes the issue that the memory overflow exception was thrown when converting Excel to PDF. |
Bug | SPIREXLS-4680 | Fixes the issue that the decimal place retention in numeric charts was inconsistent when converting them to images. |
Bug | SPIREXLS-4682 | Fixes the issue that the program threw java.lang.ClassCastException exception when loading an Excel document. |
Bug | SPIREXLS-4685 | Fixes the issue that the result file failed to open after adding the LOG function. |
Bug | SPIREXLS-4687 | Fixes the issue that the style changed when loading and saving an et format file. |
Bug | SPIREXLS-4688 | Fixes the issue that the chart coordinate axis format changed when loading and saving an et format file. |
Bug | SPIREXLS-4736 | Fixes the issue that the program threw java.lang.ClassFormatError exception when converting Excel to PDF. |
Version: 13.5.2
Category | ID | Description |
Bug | SPIREXLS-4586 | Fixes the issue that the positions of text and line were incorrect when converting Excel to PDF. |
Bug | SPIREXLS-4606 | Fixes the issue that using the sheet.insertArray method to insert data did not get the correct result. |
Bug | SPIREXLS-4612 | Fixes the issue that the application threw "java.lang.NullPointerException" when loading Excel files. |
Bug | SPIREXLS-4615 | Fixes the issue that the trend line was lost when converting charts to images. |
Bug | SPIREXLS-4634 | Fixes the issue that the application threw "java.lang.ArrayIndexOfBoundsException" when converting Excel to PDF. |
Bug | SPIREXLS-4635 | Fixes the issue that the application threw "java.lang.StringIndexOfBoundsException" when converting Excel to PDF. |
Bug | SPIREXLS-4637 | Fixes the issue that the date format was incorrect when converting Excel to PDF. |
Version: 13.4.1
Category | ID | Description |
Bug | SPIREXLS-4512 | Fixed the issue that the image height changing after inserting images. |
Bug | SPIREXLS-4562 | Fixed the issue that the filters were not working when specifying a single row data range. |
Bug | SPIREXLS-4563 | Fixed the issue that java.lang.NullPointerException error being thrown during Excel to HTML conversion. |
Bug | SPIREXLS-4574 | Fixed the issue that "Invalid formula" error being thrown during Excel to PDF conversion. |
Bug | SPIREXLS-4576 | Fixed the issue that "String index out of range" error being thrown during Excel to PDF conversion. |
Bug | SPIREXLS-4577 | Fixed the issue that java.lang.NullPointerException error being thrown during Excel to PDF conversion. |