Aspose.Cells for Java v2.1.0 Release Notes

We are pleased to announce Aspose.Cells for Java v2.1.0!

What’s changed:

l Add new features for Open Document Spreadsheet file(ODS): Hyperlink, Page Setup options, Group outline, Conditional formatting, Data validation, AutoFilter, Page Break, PrintTitleRows/Columns, Shapes related objects(Comment, Arc, Button, CheckBox, ComboBox, GroupBox, GroupShape, Label, Line, ListBox, OleObject, Oval, Picture, RadioButton, Rectangle, ScrollBar, Spinner, TextBox), Chart.

l Provide new features for MS Excel 2007 file format: Inserting Pictures, Adding Charts.

l Support to update controls via the linked cell(s), and vice versa: CheckBox, ComboBox, ListBox, RadioButton, ScrollBar, Spinner.

l Access Shape’s properties: Name, ZOrderPosition.

l Apply Subtotals to worksheet tables.

l Calculate Hyperlink function.

l Delete user defined Names.

l Include AutoFilter attributes when copying Workbook/Worksheet.

l Support for hyperlinks in xls2pdf conversion.

l Extract Ole Objects in the template file.

l Fixed some bugs for R/W ODS.

l 48 fixes and other enhancements.

Issues Resolved in Aspose.Cells for Java v2.1.0

Issue IDComponentSummary
9771xlsHyperlink’s address
9770xlstemplate files that contains large MSODrawing data
9769xlsupdate controls via the linked cell, and vice versa
9768xlsShape’s name and ZOrderPosition
9686xlsStrong Workbook Encryption
9674xlsCell.getStringValue() for rounding decimal values
9498xlsreading template files that contain both BIFF7 and BIFF8 records
9499xlsmerge cells
9500chartAxis of Chart
7919XlsSUBTOTAL function
7953Xls2pdfhyperlinks for xls2pdf
9344xlsdynamic formulas in SmartMarker
9363xlsSmartMarker with horizontal flag:
9364xlsxcloses user’s output stream
9404xlsreading template file that created by Microsoft Jet Engine
9264CSVimporting/exporting CSV file format
9265Xls2Pdfmerged cells in xls2pdf
9173xlsxStyle.isCellLocked() property for Excel2007 file format
9174xlsset picture’s size in Header/Footer of PageSetup
9190xlsxRow height for Excel2007 file format
9204xlsDeleting user defined Name
8759xlsColumn width
7965xlsformula HYPERLINK
8760xlsDate value for SmartMarker
8701xlsSetting linked cell for controls
8603xlssetting FitToPagesWide/FitToPagesTall property of PageSetup
8389xlsROUND formula
8417xlsStyle of non-standard xls template file created by Jsperreport
8111xlsShape properties
8284xlsCopy AutoFilter when copying Worksheet/Workbook
8251Xlsxnonstandard xlsx file generated by some other tools than MSExcel