Spire.XLS for Java 13.1.3 supports FILTER function
2023-01-18 08:53:36
We are excited to announce the release of Spire.XLS for Java 13.1.3. This version supports FILTER function. Moreover, it also enhances the conversion from Excel to PDF. Additionally, some known issues are fixed, such as the issue that the generated file was failed to open after copying content using sheet1.copyFrom(sheet2). More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-4318 Supports FILTER function. Bug SPIREXLS-4321 Fixes the issue that the data was incorrect when converting Excel to PDF on centos7. Bug SPIREXLS-4324 Fixes the issue that the paging was…
Spire.XLS for Java 12.12.4 enhances the conversion from Excel to PDF and images
2022-12-30 07:23:51
We are happy to announce the release of Spire.XLS for Java 12.12.4. This version enhances the conversion from Excel to PDF and images as well as XLSM to PDF. Besides, some known issues are successfully fixed in this version, such as the issue that the date format of the created pivot table was incorrect and the issue that the Worksheet.MaxDisplayRange area could not include pictures. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-4147 Fixes the issue that the content was incorrect after converting Excel to PDF and images.…
Spire.XLS for Java 12.11.8 enhances the conversion from Excel to PDF
2022-11-28 09:22:12
We are glad to announce the release of Spire.XLS for Java 12.11.8. This version enhances the conversion from Excel to PDF. Additionally, some known issues are fixed, such as the issue that the program threw java.lang.OutOfMemoryError when loading an Excel file. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-4154 SPIREXLS-4190 Fixes the issue that the content was incorrect when converting Excel to PDF. Bug SPIREXLS-4166 Fixes the issue that the program threw java.lang.ClassCastException when converting Excel to PDF. Bug SPIREXLS-4181 Fixes the issue that the font changed when…
Spire.XLS for Java 12.10.3 enhances the conversion from Excel to PDF
2022-10-25 04:30:24
We are excited to announce the release of Spire.XLS for Java 12.10.3. This version enhances the conversion from Excel to PDF. Additionally, some known issues are fixed, such as the issue that the last modified date obtained was incorrect. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-4107 Fixes the issue that the last modified date obtained was incorrect. Bug SPIREXLS-4129 Fixes the issue that the result file failed to open when converting Excel to XPS. Bug SPIREXLS-4139 Fixes the issue that the row height changed when converting Excel…
Spire.XLS for Java 12.9.1 enhances the conversion from Excel to PDF
2022-09-21 02:46:56
We are pleased to announce the release of Spire.XLS for Java 12.9.1. This version enhances the conversion from Excel to PDF. Additionally, some known issues are fixed, such as the issue that the application threw "java.lang.NullPointerException" when modifying the selected value of the filter in the PivotTable. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-2862 Fixes the issue that the line feed was incorrect when converting Excel document to PDF. Bug SPIREXLS-2986 SPIREXLS-3019 Fixes the issue that the page margin was incorrect when converting Excel document to PDF.…
Spire.XLS for Java 12.8.4 supports using Worksheet.getMaxDispalyRange() method to get all cell ranges
2022-08-26 09:29:00
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…
Spire.XLS for Java 12.7.4 supports custom sorting
2022-07-21 03:25:29
We are pleased to announce the release of Spire.XLS for Java 12.7.4. This version supports custom sorting and supports converting Excel containing chart types defined by Excel 2016 to PDF and images. Moreover, it also enhances the conversion from Excel to HTML and Excel to PDF. Additionally, some known issues are fixed, such as the issue that the line format was changed after adding TrendLines to chart. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3704 Supports custom sorting. wb.getDataSorter().getSortColumns().add(0, new String[] {"12345","Argentina", "Area", "Chile", "Capital","USA","Ecuador","Guyana"} ); wb.getDataSorter().sort(wb.getWorksheets().get(0).getRange().get("A1:A8"));…
Spire.XLS for Java 12.7.0 supports filling the chart series markers with custom images
2022-07-13 09:02:42
We are excited to announce the release of Spire.XLS for Java 12.7.0. This version supports filling the chart series markers with custom images and supports loading and saving files in UOS format. In addition, it fixes some known issues such as the data was incorrect after updating pivot tables. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3948 Supports filling the chart series markers with custom images. IShapeFill markerFill = chart.getSeries().get(0).getDataFormat().getMarkerFill(); markerFill.customPicture("pic.png"); markerFill.setTexture(...); markerFill.SetPattern(...); //If use pattern filling, foreground color and backgroud color are needed. markerFill.setForeColor(...); markerFill.setBackColor(...); New…
