News & Releases
|
|
Spire.XLS for Java 3.4.8 supports copying cells with styles and deleting DataVlidation
We're pleased to announce the release of Spire.XLS for Java 3.4.8. The version has some fantastic new features. For example, it supports copying cell formats, not showing zero, setting the PrintError as NA and so on. Meanwhile, some issues that occurred when converting Excel to HTML/PDF and manipulating files are successfully fixed. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | SPIREXLS-2082 | Supports copying cells with styles.
srcRange.copy(destRange,true,true); |
| New Feature | SPIREXLS-2083 | Make the enumeration GroupByTape and ExpandCollapseFlags public.
worksheet.getRange().get("A1:C1").expandGroup(GroupByType.ByRows,ExpandCollapseFlags.ExpandParent);
|
| New Feature | SPIREXLS-2106 | Supports not showing zero.
worksheet.isDisplayZeros(false); |
| New Feature | SPIREXLS-2104 | Supports deleting DataValidation.
workbook.getWorksheets().get(0).getDVTable().remove(rectangles); |
| New Feature | SPIREXLS-2108 | Supports setting the PrintErrors as NA.
pageSetup.setPrintErrors(PrintErrorsType.NA); |
| New Feature | SPIREXLS-2154 | Supports adding radiobutton and copying combobox, line and radiobutton.
//Add radio button worksheet.getRadioButtons().add(5,5,20,20); //Copy line worksheet.getTypedLines().addCopy(line); //Copy radio button worksheet.getTypedRadioButtons().addCopy(button); //Copy combo box worksheet.getTypedComboBoxes().addCopy(combobox); |
| New Feature | SPIREXLS-2155 | Suppprts converting sheet to CSV and only retain filtered data.
worksheet.saveToFile("CsvFilePath", ";", false);
|
| Bug | SPIREXLS-2088 | Fixes the issue that it failed to find number. |
| Bug | SPIREXLS-2089 | Fixes the issue that the array list was unmatched in insertArrayList method. |
| Bug | SPIREXLS-2091 | Fixes the issue that it failed to get the hyperlink type. |
| Bug | SPIREXLS-2091 | Fixes the issue that the font could not be embedded successfully. |
| Bug | SPIREXLS-2093 | Fixes the issue that the format of added arrow was incorrect. |
| Bug | SPIREXLS-2103 | Fixes the issue that protecting sheet didn't take effect. |
| Bug | SPIREXLS-2105 | Fixes the issue that setting the inner margins of textbox didn't take effect. |
| Bug | SPIREXLS-2100 SPIREXLS-2111 |
Fixes the issue that the application threw an exception when applying markerdesigner. |
| Bug | SPIREXLS-2101 | Fixes the issue that the named range was not added successfully. |
| Bug | SPIREXLS-2107 | Fixes the issue that the application threw an exception when getting the custom document properties. |
| Bug | SPIREXLS-2110 SPIREXLS-2117 |
Fixes the issue that border color of ConditionalFormat didn't display correctly. |
| Bug | SPIREXLS-2158 | Fixes the issue that the application threw an exception when adding DataTable in MarkerDesigner. |
| Bug | SPIREXLS-2166 | Fixes the issue that after adding background image in Pivot table in Excel, the generated Excel prompted an error when opening it. |
| Bug | SPIREXLS-2174 | Fixes the issue that the application threw the exception "ArrayIndexOutOfBoundsException" when converting Excel to HTML. |
| Bug | SPIREXLS-2195 | Fixed the issue that first setting the horizontal center alignment of the cell and then setting the vertical center didn't take effect. |
| Bug | SPIREXLS-2174 | Fixes the issue that the application threw the exception "NullPointerException" when converting Excel to PDF on MAC. |
Click the link to download Spire.XLS for Java 3.4.8:
