Aspose.Cells

Aspose.Cells 4.5.0.0 New Release

laurence — Fri, 27 Jun 2008 06:32:53 GMT

What's New?

Convert Worksheet to image.
Support to convert Excel file to HTML file format.
Support to sort the data from left to right.

What's Improved?

Supported more functions in formula calculation engine
Supported more custom filters in autofilter.
Enhanced Excel2007 Xlsx support
Enhanced SpreadsheetML support
Enhanced xls2Pdf conversion
Enhanced Charts2Image conversion.
Enhanced smart marker
Supported getting linked cell of radio button from template file.

What's Fixed?

Bug in Reading and Writing charts.
Bug in calculating formulas
Bug in opening and saving some special xls files.
Bug in Cells.ImportDataTable method
Bug in updating chart references when inserting rows/columns.

Aspose.Cells for Java v1.9.5 Hotfix

laurence — Fri, 20 Jun 2008 02:26:12 GMT

Dear Customers,

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

*What's New?

* Supports to recognize Excel file format automatically for Workbook.open(String) and Workbook.open(InputStream)
* Supports to process cells in spreadsheet file in Event-Driven mode by introducing new API(LightCells)
* Supports to remove shape related Object, including Comment, Picture, and so on
* Supports to copy shapes when copy workbook or worksheet
* Supports to check whether a cell or style is Percent or Date

*What's Improved?

* Conversion of Excel to Pdf has been enhanced
* When save workbook as Excel2003 file format, Aspose.Cells will cut out those cells automatically whose column or row exceeds 65536 rows and 256 columns limit.
* When without encoding specified, reading CSV file will try to get and use the system default encoding

*What's Fixed?

* Fixed some bugs of calculating formula
* Fixed some bugs of reading template file
* Fixed a bug of getting picture's scale
* Fixed a bug of saving NamedStyle
* Fixed a bug of setting Comment's border line visible
* Fixed a bug of setting cell's Border
* Fixed a bug of HYPERLINK formula
* Fixed a bug of saving Names
* Fixed a bug of saving Workbook with protected structure
* Fixed a bug of set Name object's text
* Fixed a bug of getting string value of merged cells
* Fixed a bug of processing SmartMarker for WorkbookDesigner

Partners.WorldMap.org Case Study

Merit — Tue, 15 Apr 2008 17:02:41 GMT

Case Study that shows how they used Aspose.Cells to create spreadsheets from data fields collected and summarized from data collected with Partners.WorldMap.org. 2 Screenshots included.

Aspose.Cells for .Net V4.4.3 Hotfix

laurence — Fri, 11 Apr 2008 14:52:40 GMT

Dear Customers,

We have released Aspose.Cells for .Net V4.4.3!

What's New?

Supported DAYS360 function in formula calculation engine

What's Fixed?

Bug in print area setting
Bug in ImportDataTable method

Aspose.Cells for .Net v4.4.2 Hotfix

laurence — Tue, 08 Apr 2008 08:52:10 GMT

Dear Customers,

We have released Aspose.Cells for .Net V4.4.2!

What's New?

Added Cell.GetStyle/Cell.SetStyle method to optimize memory usage
Supported 2007 Xlsm format

What's Improved?

Enhanced formula calculation engine
Enhanced xls2pdf conversion
Enhanced chart2Image conversion

What's Fixed?

Fixed bugs in CopyRow/CopyColumn method
Fixed a bug in Cell.StringValue property
Fixed a bug in FreezePanes method

Ohal uses Aspose.Cells in Report Canvas Component

merit — Tue, 18 Mar 2008 20:46:00 GMT

A case study provided by Ohal that shows how they used Aspose.Cells in Report Canvas Component. screenshot.

Aspose.Cells for Java V1.9.4 Hot Fix

laurence — Tue, 04 Mar 2008 15:19:51 GMT

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 Fixed?

Fixed some bugs of calculating formula
Fixed a bug of exporting Excel2007 XLSX format
Fixed a bug of copying style
Fixed a bug of copying formula
Fixed a bug of saving image size

Comments

For charts imported from template files, manipulating their data is not supported, currently only support to operate on shape properties, such as position, placement and size

Blue Inkt Case Study

Merit — Thu, 28 Feb 2008 17:26:03 GMT

Blue Inkt tells in this case study how they used Aspose.Cells. Screenshot included.

Right90 - Sales Forecasting

salman.sarfraz — Thu, 14 Feb 2008 13:15:51 GMT

Using Aspose.Cells, Right90 Sales Forecasting helps manufacturing companies see and manage changes to their sales forecasts.

Aspose.Cells for .Net 4.4.1 Hot Fix

laurence — Sat, 02 Feb 2008 07:21:23 GMT

Dear Customers,

We have released Aspose.Cells for .Net V4.4.1!

What's New?

Auto-detect file type when opening an Excel file

What's Improved?

Enhanced Excel2007 Xlsx support
Enhanced xls2pdf conversion
Enhanced pivot table support
Supported more functions in formula calculation engine

What's Fixed?

Bug in opening a few special far-east Excel files
Bug in formula parsing and calculation
Bug in page setup settings
Bug in import/export some text files
Bug in processing smart markers
Problem in installation on vista

Aspose.Cells for Java 1.9.3 Hot Fix

laurence — Fri, 25 Jan 2008 06:04:41 GMT

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 formulas
Fixed a bug of getting minimum column of row
Fixed a bug of importing a collection into cells
Fixed a bug of reading file
Fixed a bug of copying formulas
Fixed a bug of copying cell range
Fixed a bug of formatting number with E-exponent

Comments

For adding textBox, in new version, add(...) methods is only valid in the worksheet.
addInChart() method is only valid in the Chart Sheet.

Aspose.Cells For Java 1.9.2 Hot Fix

laurence — Mon, 24 Dec 2007 08:04:14 GMT

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 copy row and column
Fixed a bug of saving workbook on AIX
Fixed a bug of getting string value of the cell
Fixed a bug of reading the file

Aspose.Cells - Performance Metrics and Benchmarks

amjad sahi — Wed, 12 Dec 2007 09:56:49 GMT

Benchmarks provide guidelines and help to set basic operational expectations. The topic shows benchmark tests that have been performed with different potential components. The Performance Measures allow even novice users to benchmark the performance the component they are using. The article presents performance measurements for different products including Aspose.Cells. Performance estimates presented here are intended to help you understand what to expect from different components in some commonly used scenarios under similar configurations on commodity hardware running widely used operating systems.

Aspose.Cells for Java 1.9.1 Hot Fix

laurence — Fri, 16 Nov 2007 14:36:08 GMT

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.

Aspose.Cells for .Net 4.4.0.0 New Release

laurence — Mon, 03 Sep 2007 09:18:42 GMT

What's New?

3208 - Allows to delete defined names from template files

3637 - Support to create an encrypted Excel file from scratch

What's Improved?

3631 - Writes the formula calculation result back to file

3632 - Chart2image conversion enhancement

3639 - Xls2pdf feature enhancement

3640 - Support to set vertical text in text box

What's Fixed?

3179 - Chart PlotArea setting bug

3199 - AutoFitRow bug for some bold font

3641 - Bug in calculating Indirect and Address function in some cases

3642 - Bug in send xlsx file to client browser