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 = worksheet.getSparklineGroups();
sparklineGroup.get(1).setMarkersColor(Color.YELLOW);
book.saveToFile("D:/result.xlsx", FileFormat.Version2016);
|
| New feature | SPIREXLS-3424 | Supports printing comments when converting Excel to images.
worksheet.getPageSetup().setPrintComments(PrintCommentType.InPlace); |
| New feature | SPIREXLS-3451 | Supports loading and saving .et/.ett files.
Workbook workbook = new Workbook(); workbook.loadFromFile(inputFile); workbook.saveToFile(etFile, FileFormat.ET); workbook.saveToFile(ettFile, FileFormat.ETT); |
| Bug | SPIREXLS-3334 | Fixes the issue that the application threw the error "NullPointerException" when converting Excel to PDF. |
| Bug | SPIREXLS-3388 | Fixes the issue that the application threw the error "Invalid MsoLineDashStyle string val" when converting Excel to PDF. |
| Bug | SPIREXLS-3394 | Fixes the issue that part of the cell borders was not displayed after adding a hyperlink. |
| Bug | SPIREXLS-3439 | Fixes the issue that the content was incorrect after converting Excel to HTML. |
| Bug | SPIREXLS-3446 | Fixes the issue that it returned the wrong count when getting the cell count of the named ranges. |
| Bug | SPIREXLS-3447 | Fixes the issue that it returned the wrong value when checking if a named range was visible. |
| Bug | SPIREXLS-3448 | Fixes the issue that link address was incorrect after converting Excel to HTML. |
| Bug | SPIREXLS-3454 | Fixes the issue that the application threw the error "Exception in thread" when creating Workbook objects using multiple threads. |
| Bug | SPIREXLS-3462 | Fixes the issue that the application threw the error "NullPointerException" when getting the chart title. |
| Bug | SPIREXLS-3479 | Fixes the issue that the content was incorrect after converting Excel to PDF. |
| Bug | SPIREXLS-3490 | Fixes the issue that the date format was incorrect after converting Excel to PDF. |
Click the link to download Spire.XLS for Java 4.10.1:
