Aspose.Cells

Aspose.Cells V4.5.1 Released!

Laurence — Sun, 28 Sep 2008 18:18:00 GMT

In this new version, we greatly enhanced conversion features, including Pdf conversion, Chart2Image conversion and Sheet2Image conversion. And many other features and enhancements are included: http://www.aspose.com/community/files/51/file-format-components/aspose.cells/default.aspx .

Comparing VSTO with Aspose.Cells for .NET

Amjad Sahi — Mon, 07 Jul 2008 22:38:00 GMT

In this article, we describe some comparison measurements of VSTO (Visual Studio Tools for Office) and Aspose.Cells for .NET on different aspects related to Spreadsheet tasks. We also list a few concerns and issues that you should know before making a final decision on adopting any solution.

Please check the complete article: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/comparing-vsto-with-aspose-cells-for-net.html

Aspose.Cells for Java Vs Open Source Competitors

Amjad Sahi — Sat, 05 Jul 2008 07:43:00 GMT

In this article, we try to examine feature comparison between Aspose.Cells for Java, JExcelAPI and POI-HSSF. Today we find different spreadsheet components that really promise to have feature-rich API for spreadsheet management. The article observes the feature analysis of Aspose.Cells for Java with its open source competitors. We provide summary of valuable features of all three components. Moreover, we state some known limitations and deficiencies of the components if they have. We also present a comparison table for an overview after putting Aspose.Cells for Java, JExcelAPI and POI-HSSF side by side.

Please check the complete article:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/aspose-cells-for-java-vs-open-source-competitors.html

Aspose.Cells 4.5.0.0 Released

Laurence — Mon, 30 Jun 2008 16:54:00 GMT

We have just released Aspose.Cells v4.5.0.0: http://www.aspose.com/community/files/51/file-format-components/aspose.cells/default.aspx .

In these new release, we not only add new features as usual, but also shape it's performance. Aspose.Cells aims to provide richest feature set and highest compatibility for different Excel files. In the mean time, performance is a very critical issue for our product. We make many performance testing and enhancement in v4.5.

Cell.Style property vs Cell.GetStyle/SetStyle method

Laurence — Thu, 10 Apr 2008 06:04:00 GMT

Since v4.4.2, we add two new methods to format a cell: Cell.GetStyle method and Cell.SetStyle method.

So now you can use following two ways to format a cell:

1. use Cell.Style property

[C#]

cell.Style.Font.IsBold = true;

[VB.Net]

cell.Style.Font.IsBold = True

2. use Cell.GetStyle and Cell.SetStyle method

[C#]

Style style = cell.GetStyle();

style.Font.IsBold = true;

cell.SetStyle(style);

[VB.Net]

Dim style as Style = cell.GetStyle()

style.Font.IsBold = True

cell.SetStyle(style)

You can see that the first approach is easy and straight-forward. So why we add the second approach?

When you use the first piece of code, a Style object will be initiated for each cell when formatting it. So if there are a lot of cells to be formatted, a large amount of memory will be consumed becasue Style object is a large object. These Style objects won't be freed until calling Workbook.Save method.

So we add the second approach to optimize memory usage. After you use Cell.GetStyle method to retrieve a Style object, modify it and use Cell.SetStyle method to set back to this cell, this Style object won't be preserved and .Net GC will collect it when it's not referenced.

Actually when calling Cell.SetStyle method, Style object won't be saved for each cell. Instead, we compare this Style object to an interal Style object pool to see if it can be reused. Only different Style objects will be kept for each Workbook object. So there are only several hundred Style objects for each Excel file. For each cell, only an index to this Style object pool will be preserved.

We have tested it and find it will save a large amount of memory when processing very large Excel files.

Changes in Aspose.Cells for Reporting Services V1.1.1

Laurence — Fri, 28 Mar 2008 04:34:00 GMT

In Aspose.Cells for Reporting Service v1.1, we provide a client tool to enable users to design reports in MS Excel. This tool is an Excel addin and we developed it totally with C#.

Because we develop the tool in C#, we have to use Excel interop to manipulate files. Some users found problems when using the client tool in their MS Excel. After investigating their problems, we found most of problem are caused by MS Office, Office PIA, .Net Framework or others. When they installed corresponding MS' patches, problems are solved.

However, this does bring troubles for installation and deployment. So in v1.1.1, we use VBA to make UI of client tool and use C# to develop other features. That removes dependency on Excel PIA. We think that can make installation and deployment more easy.

Some users may ask: why don't you make a .Net tool totally independent of Excel? We think MS Excel is an excellent desktop application for daily use. Using it as a design tool can save user's efforts for learning.

Aspose.Cells for Java V1.9.4 Released

Warren — Tue, 04 Mar 2008 00:55:00 GMT

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

Aspose.Cells for .Net V4.4.1 Released!

Laurence — Sat, 02 Feb 2008 23:09:00 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 V1.9.3 Released

Warren — Fri, 25 Jan 2008 21:50:00 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 V1.9.2 Released

Warren — Mon, 24 Dec 2007 22:46:00 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