Aspose.Cells for Java 2.1.2 Release Notes
We are happy to announce Aspose.Cells for Jav!
What’s changed:
- Provides Chart-to-Image feature. Imports RichText from SpreadSheetML template file. Supports to export Name object with external references for SpreadSheetML file. Exports Pictures in PageSetup for Excel 2007 files. Imports TextBox controls from Excel 2007 files. Provides support to set record limit when importing data from ResultSet for Smart Markers. Sets the position of a Shape to the center of given range. Supports to add calculated field for a PivotTable. Supports to get/set VeryHidden property for a Worksheet. Adds new formula to the supported formulas list: FREQUENCY Recognizes the file format automatically for LightCells API. Enhances style’s model for performance consideration. Improves the API regarding Comment for performance consideration. Enhances the performance of reading large Excel 2007 files. Boosts the performance of LightCells API for large Excel 2007 files. Reading operation for a document’s properties is enhanced. Importing CSV files operation is enhanced. 67 fixes and enhancements.
Issues Resolved in Aspose.Cells for Java 2.1.2
| Issue ID | Component | Summary |
|---|---|---|
| 6245 | xls | Gather styles |
| 6362 | xls | Copy style when inserting rows/columns |
| 11871 | xls | Copy cell range |
| 11890 | html | Read Conditional formatting |
| 11891 | chart | LogarithmicBase property of ValueAxis |
| 11911 | SpreadSheetML | Save style |
| 11928 | xls | Read template file |
| 11943 | SpreadSheetML | Read special file generated by OWC |
| 11973 | SpreadSheetML | Read special file generated by OWC |
| 12006 | CSV | Read csv file |
| 12032 | FormulaEngine | COUNTIF formula |
| 12034 | xls | Auto fit columns |
| 12056 | FormulaEngine | IF formula |
| 12080 | chart | Formatted value of ChartFrame |
| 12105 | xls | Read row height |
| 12128 | chart | Get marker |
| 12138 | chart | Read marker |
| 12184 | xls | Copy formulas |
| 12229 | SpreadSheetML | Read rich text |
| 12238 | xlsx | Performance of reading template file |
| 12238 | xlsx | Performance of reading template file |
| 12243 | chart | ASeries’s type |
| 12253 | xls | Hyperlink’s link type |
| 12271 | chart | DataLabels |
| 12275 | xls | LightCells |
| 12317 | chart | Title’s text |
| 12324 | Chart2Image | ImageOption |
| 12347 | SpreadSheetML | Hyperlink |
| 12434 | chart | GradientFill |
| 12477 | xlsx | LightCells |
| 12493 | xlsx | Read Conditional formatting |
| 12498 | chart | ChartPoints and LegendEntries collection |
| 12575 | chart | PlotArea’s size |
| 12576 | chart | ErrorBar |
| 12622 | xlsx | Read shared formula |
| 12625 | xlsx | Read chart |
| 12667 | xls | Datetime value |
| 12684 | CSV | Read number |
| 12717 | xls | Picture with Mac OS |
| 12727 | xls | Read document properties |
| 12750 | xls | Get hyperlink of shape |
| 12870 | xlsx | Read drawing object |
| 12880 | Chart2Image | Draw chart |
| 12894 | PivotTable | addCalculateField() method |
| 12915 | xlsx | Save String value |
| 12957 | SpreadSheetML | Save document properties |
| 12971 | xls | VeryHidden property of worksheet |
| 13012 | Chart2Image | Unsupported Font in special environment |
| 13101 | xlsx | Read PageSetup and style |
| 13270 | xls | Position shape |
| 13385 | xls | Copy AutoFilter |
| 13386 | xlsx | Save xlsx file |
| 13403 | xls | Save style |
| 13418 | xls | Read AutoFilter |
| 13448 | Smart Marker | Record limit for ResultSet datasource |
| 13614 | xlsx | Picture in PageSetup |
| 13639 | xls | Create TextBox |
| 13679 | xlsx | Read xlsx file with Apache zip tool |
| 13725 | chart | Copy Axis |
| 13735 | xls | Formulas of FormatConditions/Validations |
| 13736 | xls | Date format |
| 13821 | xls | Performance of creating Comment |
| 14056 | chart | Gradient fill |
| 14108 | xls | Copy PageBreaks |
| 14116 | xls | Delete data |
| 14146 | Chart2Image | Chart2Image |
| 14246 | xls | Copy PageSetup |
Notable changes for users:
In old versions, Cell.getStyle()/Row.getStyle()/Column.getStyle() methods might cause Cell/Row/Column maintain their own Style object. Modification of the returned Style object for getStyle() later will change the Cell/Row/Column’s style directly.
From this version, all Style objects that set to Cell/Row/Column will be gathered for performance considerations and Cell/Row/Column will only maintain a style reference. Modification of the returned Style object for getStyle() later will not change the Cell/Row/Column’s style. To make the modification take effect, users need to call setStyle() for Cell/Row/Column after the style is modified.
This rule is required for Style.getFont()/getColor()/getPatternColor()/getBorderColor() methods too. In old versions, modification of the returned Font/Color object might cause the style change directly. In the new version, after making changes for the Font/Color object, users need to call Style.setFont()/setColor()/setPatternColor()/setBorderColor() to make the modification take effect.