Spire.XLS for Java 5.3.3 supports setting text direction for the chart category axis
2022-03-22 01:30:24
We are happy to announce the release of Spire.XLS for Java 5.3.3. This version supports setting text direction for the chart category axis as well as sorting for a Table, and enhances the conversion from Excel to image, Excel to PDF. In addition, it fixes some known issues such as the application threw "NullPointerException" when appending a rich text. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3641 Supports setting text direction for the chart category axis. chart.getPrimaryCategoryAxis().setTextDirection(TextVerticalValue.EastAsianVertical); New feature SPIREXLS-3706 Supports sorting for a Table. Workbook workbook…
Spire.XLS for Java 5.3.1 supports creating Excel 2016 Charts
2022-03-11 01:13:28
We are happy to announce the release of Spire.XLS for Java 5.3.1. This version supports creating Waterfall Chart, Pareto Chart, Histogram Chart, BoxAndWhisker Chart, TreeMap Chart, SunBurst Chart, and Funnel Chart. Also, it enhances the conversions from Excel to PDF and Excel to Image. In addition, it fixes some known issues such as the obtained signature information is not correct. More details are listed below. Here is a list of changes made in this release Category ID Description New feature - Supports creating the Waterfall Chart. Workbookworkbook=newWorkbook(); workbook.loadFromFile("input.xlsx"); Worksheetsheet=workbook.getWorksheets().get(0); ChartofficeChart=sheet.getCharts().add(); //Setcharttypeaswaterfall officeChart.setChartType(ExcelChartType.WaterFall); //Setdatarangetothechartfromtheworksheet officeChart.setDataRange(sheet.getRange().get("A2:B8")); //Datapointsettingsastotalinchart officeChart.getSeries().get(0).getDataPoints().get(3).setAsTotal(true); officeChart.getSeries().get(0).getDataPoints().get(6).setAsTotal(true); //Showingtheconnectorlinesbetweendatapoints officeChart.getSeries().get(0).getFormat().showConnectorLines(true); //Setthecharttitle…
Spire.XLS for Java 5.1.5 enhances the conversion from Excel to PDF/HTML/images
2022-01-18 06:08:35
We are happy to announce the release of Spire.XLS for Java 5.1.5. This version enhances the conversion from Excel to PDF/HTML/images, as well as HTML to Excel. In addition, it fixes some known issues such as the application threw an exception when loading excel file. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-3540 Fixes the issue that the application threw an exception when loading excel file. Bug SPIREXLS-3561 Fixes the issue that the page number position was incorrect after converting excel file to PDF. Bug SPIREXLS-3574 Fixes the…
Spire.XLS for Java 4.12.2 supports converting excel file to OFD
2021-12-21 09:46:47
We are happy to announce the release of Spire.XLS for Java 4.12.2. This version supports converting excel file to OFD and supports "Subtotal" function. Also, it enhances the conversion from Excel to PDF, Excel to image. In addition, it fixes some known issues such as the "Wrap text" didn't take effect after merging cells. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3568 Supports converting excel file to OFD. Workbook workbook = new Workbook(); workbook.loadFromFile("input.xlsx"); workbook.saveToFile("output.ofd", FileFormat.OFD); New feature SPIREXLS-3571 Supports "Subtotal" function. Workbook workbook = new Workbook();…
Spire.XLS for Java 4.11.3 enhances the conversion from Excel to PDF
2021-11-25 09:11:01
We are happy to announce the release of Spire.XLS for Java 4.11.3. This version enhances the conversion from Excel to PDF, it also fixes some known issues like the checked "Align with page margins" item was missing. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-2736 Fixes the issue that the format was not correct when converting an excel to PDF Bug SPIREXLS-3158 Fixes the issue that the obtained cell value of the date format was wrong Bug SPIREXLS-3485 Fixes the issue that the checked "Align with page margins"…
Spire.XLS for Java 4.11.0 supports to get the created time and the last saved time of Excel file
2021-11-05 08:54:28
We are glad to announce the release of Spire.XLS for Java 4.11.0. This version supports to get the created time and the last saved time of Excel file. Meanwhile, it enhances the conversion from Excel to PDF and fixes some known issues. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3488 Supports to get the created time and the last saved time of Excel file. BuiltInDocumentProperties properties1 = workbook.getDocumentProperties(); properties1.getCreatedTime(); properties1.getLastSaveTime(); Bug SPIREXLS-3427 Fixes the issue that the conditional formats did not take effect when converting an Excel file to PDF Bug SPIREXLS-3444…
Spire.XLS for Java 4.10.1 supports setting the marker color for the SparkLine
2021-10-26 06:43:48
We are happy to announce the release of Spire.XLS for Java 4.10.1. This version supports setting the marker color for the SparkLine as well as supports printing comments when converting Excel to images. In addition, it enhances the conversions from Excel to PDF/HTML and also fixes the issue occurred in the process of adding hyperlinks to files. More details are given as follows. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3391 Supports setting the marker color for the SparkLine. Workbook book = new Workbook(); book.loadFromFile("D:/SparkLine.xlsx"); Worksheet worksheet = book.getWorksheets().get(0); SparklineGroupCollection sparklineGroup =…
