Author Archives: Warren

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.

Dear Customers, 

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

Following enhancements and fixes are included:

• All standard types of Chart are supported
• Added Worksheets.addCopy() method
• Added Protection.getPasswordHash() method
• Updated Object model to make it similar to .NET version

Note: Class Workbook has bean renamed Excel.… Continue Reading