Author Archives: Warren

Dear Customers,

We have released Aspose.Cells for Java V1.9.4!

What’s New?

• Supports to add rich text for shapes such as Arc, Oval, Rectangle, Comment, TextBox
• Supports all type of placement for shape
• Supports to read all shapes from template
• Supports to set array in SmartMarker

What’s Improved?

• Add new methods to manipulate shape’s position and size, and deprecated some old methods
• Add some demo codes and templates for new API
• Replace deprecated API invocation with new API in demos

What’s … Continue Reading

Dear Customers, We have released Aspose.Cells for Java V1.9.3!

What’s New?

• Supports to add Arc, Oval, Rectangle
• Supports to add Word and Excel file as OLE object
• Supports to only load data and formatting in the template file
• Supports to copy style when insert rows and columns
• Supports to get number format type of cell
• Supports to filter non-blank/blank cells in AutoFilter

What’s Improved?

• Provides methods for Shapes object to add any shape

What’s Fixed?

• Fixed a bug of calculating

Dear Customers,

We have released Aspose.Cells for Java V1.9.2!

What’s New?

• Supports to iterate all cells of one worksheet by one Iterator
• Supports to copy cells range
• Supports to get all defined Name objects, including NamedRange object and those objects which are not conventional NamedRange but Name object
• Supports to unmerge cells
• Supports to add the line shape

What’s Improved?

• Remove the 64K rows and 256 columns limitation for Excel2007

What’s Fixed?

• Fixed a bug of losing merged style when

Dear Customers,

We have released Aspose.Cells for Java V1.9.1!

What’s New?

• Supports to export to and import from Excel2007xlsx file.
• Supports to sort datas of the range.
• Supports to be used with PHP.

What’s improved?

• Supports to set the scale and unit of Time Scale Category axis.

What’s fixed?

• Fixed a bug of calculating formulas
• Fixed a bug of formating number.
• Fixed a bug of adding picture.
• Fixed a bug of saving file.

Download URL:

http://www.aspose.com/Community/Files/51/aspose.cells/entry102877.aspx… Continue Reading

Dear Customers,

We have released Aspose.Cells for Java V1.9.0!

What’s New?

• Supports to export to Aspose.Pdf xml file
• Supports to copy comments and named ranges when coping worksheet
• Supports ICustomFunction interface of calculating formulas
• Supports to trace precedents and dependents of a cell

What’s improved?

• Supports to only calculate all formulas in a worksheet
• Supports POJO and POJOs with smart markers

What’s fixed?

• Fixed a bug of getting named ranges of the worksheet
• Fixed a bug of creating the PivotTable

Dear Customers,

We have released Aspose.Cells for Java V1.8.2!

Following enhancements and fixes are included:

• Supports the text box in the chart to link to the cell
• Supports to set scatter X value Axis of the chart
• Supports to get/set the font of comments loaded from a template file
• Optimizes autofitting feature
• Fixed a bug of opening a file
• Fixed a bug of calculating formula
• Fixed a bug of saving CSV file
• Fixed a bug of setting validation
• Fixed a bug of

Dear Customers,

We have released Aspose.Cells for Java V1.8.1!

Following enhancements and fixes are included:

Fixed a bug of coping row.
Fixed a bug of coping workbook.
Fixed a bug of adding picture.
Fixed a bug of setting printArea.
Fixed a bug of AutoFit.
Fixed a bug of creating PivotTable.
Fixed a bug of auto filter.
Fixed a bug of setting formula.
Fixed a bug of calculating formula.
Fixed a bug of NSeries.add() method.… Continue Reading

Dear Customers,

We have released Aspose.Cells for Java V1.8.0!

Following enhancements and fixes are included:

Supports to set active sheet and cell.
Fixes some bugs of setting formulas.
Fixes some bugs of calculating formulas.
Fixes a bug of opening file.
Fixes a bug of coping worksheet.
Fixes a bug of pivot table.
Fixes a bug of validtion.
Fixes a bug of autofilters.
Fixes a bug of freezePanes.

Note: For Aspose.Cells for Java 1.4, we have embedded all classes of retrotranslator-runtime … Continue Reading

Dear Customers,

We have released Aspose.Cells for Java V1.7.5!
Following enhancements and fixes are included:

• Supports to export to HTML file. 
• Supports to autofit rows/columns.
• Supports to find string/formula in the worksheet.
• Fixes a bug of inserting rows/columns.
• Fixes a bug of calculating formulas.
• Fixes a bug of opening file.

Dear Customers,

We have released Aspose.Cells for Java V1.7.4!
Following enhancements and fixes are included:

• Adds Column.applyStyle and Row.applyStyle methods.
• Fixes som bugs of setting and calculating formulas. 
• Fixes a bug of coping row.
• Fixes a bug of freezing panes.
• Fixes a bug of saving charts. 
• Fixes a bug of saving pivot tables.
• Fixes a bug of the cells.importResultSet() method.

Note: The method getNumerOfSheets of Workbook/Worksheets has bean renamed as getNumberOfSheets.And It is better to call Worksheets.size() to get number of sheets.… Continue Reading