We’re glad to announce the release of Spire.XLS for Java 15.7.7. The latest version supports Array data binding in MarkerDesigner. Moreover, some known bugs are fixed successfully in the new version, such as the issue that font rendering was incorrect when converting Excel to PDF in Linux environments. More details are listed below.
Here is a list of changes made in this release:
| Category | ID | Description |
| New feature | SPIREXLS-5874 | Supports Array data binding in MarkerDesigner.
Workbook workbook = new Workbook();
// Get the first worksheet from the workbook
Worksheet sheet = workbook.getWorksheets().get(0);
// Set the value of cell range A1 to "&=Array"
sheet.getCellRange("A1").setValue("&=Array");
// Add a parameter named "Array" with an array of strings as its value
workbook.getMarkerDesigner().addArray("Array", new String[] { "Spire.Xls", "Spire.Doc", "Spire.PDF", "Spire.Presentation", "Spire.Email" });
// Apply the marker design to the workbook
workbook.getMarkerDesigner().apply();
// Calculate all the values in the workbook
workbook.calculateAllValue();
// Auto-fit the rows and columns in the allocated range of the worksheet
sheet.getAllocatedRange().autoFitRows();
sheet.getAllocatedRange().autoFitColumns();
// Save the workbook to the specified file path using Excel 2013 format
workbook.saveToFile(outputFile, ExcelVersion.Version2013);
// Clean up and release resources used by the workbook
workbook.dispose();
|
| Bug | SPIREXLS-5861 SPIREXLS-5873 |
Fixes the issue that font rendering was incorrect when converting Excel to PDF in Linux environments. |
| Bug | SPIREXLS-5869 | Fixes the issue that the behavior of isWriteUnMergedColSpan(false) was incorrect when converting Excel to HTML. |
| Bug | SPIREXLS-5870 | Fixes the issue that "Invalid formula: =#REF!" error happened when loading Excel documents. |
| Bug | SPIREXLS-5875 | Fixes the issue that the layout rendering was incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5876 | Fixes the issue that the program threw a java.lang.NullPointerException error when loading Excel files. |
| Bug | SPIREXLS-5877 | Removed dependencies on sun.misc.BASE64Decoder. |
Click the link to download Spire.XLS for Java 15.7.7: