Category Archive: Aspose.Cells Product Family

Now we start to use Product Blogs to announce news and release for Aspose products. This is new Aspose.Cells product blog.

To get earlier post about Aspose.Cells for .Net, please check old Aspose.Cells for .NET blog. 

To get earlier post about Aspose.Cells for Java, please check old Aspose.Cells for Java blog .… Continue Reading

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

Dear Customers,

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

• Supports to insert/delete a range.
• Supports to open and save encrypted Excel file.
• Enhances Cell.getStringValue() method to support more date/number formats.
• Updated the web demos.
• Supports to calculate formulas with JDK1.4.
• Fixes a bug of License.setLicense() method.
• Fixes a bug of setting custom number format.
• Fixes a bug of removing a worksheet from the workbook.

Dear Customers,

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

• Supports to add picture to the header/footer of the page setup
• Supports to import Page setup,Name,Protection,Data Validation and DocumentProperties from SpreadsheetML file
• Supports to export Page setup,Name,Protection,Data Validation and DocumentProperties  to SpreadsheetML file
• Supports to calculate more built-in functions
• Fixes the bug of setting automatic color of the font in the chart.

Dear Customers,

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

• Supports to import content and styles of the cells from SpreadsheetML file
• Supports to export content and styles of the cells to SpreadsheetML file
• Supports formula’s calculation engine
• Supports to set R1C1 formula
• Supports another two data source types of PivotTable
• Fixes some bugs of adding PivotTable .

Note: We remove the const CellValueType.FORMULA and add Cell.isFormula() method to decide whether the cell contains formula.… Continue Reading

Dear Customers,

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

• Supports to open/save csv format file
• Supports to add PivotTable
• Improves the performance of processing smart marker
• Fixes the bug of coping the worksheet
• Fixes the bug of the chart’s DataLabels
• Other enhancement and fixes since v1.6

Dear Customers,

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

• Supports Smart Marker Designer
• Supports to insert EMF/WMF format image
• Supports to set smooth line in the chart
• Adds Area.setVisible() method to hide/unhide the area
• Updates the demos
• Fixes the bug of Cells.clearContent() method
• Other enhancement and fixes since v1.5

For some outer reasons, some Class name have bean renamed:

Previous Class Name              Current Class Name
        Excel                                     Workbook
        ExcelHelper                           CellsHelper
        ExcelException                      CellsException

 … Continue Reading

Dear Customers,

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

• Supports to create custom chart
• Supports to set chart page setup and option
• Supports to add chart X/Y Errorbars
• Supports to copy row/column
• Other enhancement and fixes since v1.4

Dear Customers,

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

• Supports to add text boxes, comments at run time
• Supports for document properties
• Supports to set chart point
• Supports to set outline on a worksheet
• Supports to set position and size of chart area and chart plot area
• Supports to set position, fill, color and size of the shape
• Importing data from array and collection
• Fixed bugs in auto-filter settings 
• Fixed a bug of custom number format
• Fixed a bug of inserting/deleting rows and columns

Dear Customers, 

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

Following enhancements and fixes are included:

• Supported Named range 
• Added Worksheets.addCopy(),Worksheet.copy(Worksheet) method
• Supported adding pictures
• Supported setting auto filtering
• Added Worksheets.addSheet(int),Worksheets.addSheet(int,String) method to add chart sheettype.