Aspose.Grid

Aspose.Grid for .Net V2.0.0.0 Released!

2008-05-15T08:29:00Z

Many web applications are running on web hosting environments with more strict security limitations. So we periodically get the requests to run Aspose.Grid.Web on medium trust security level.

Now we make it. Please download the new release at http://www.aspose.com/community/files/53/visual-components/aspose.grid/default.aspx .

And we also make many enhancement on .Net 2.0.

Aspose.Grid v1.9.4 Released!

2007-12-21T02:20:00Z

Dear Customers,
We have just released Aspose.Grid v1.9.4.

What's New?
Aspose.Grid.Web
1. Added Native AJAX Support. Set the new property GridWeb.EnableAJAX to true to activate this new feature. When a cell is changed by a user at the client side, the grid will automatically recalculate the related formulas by using AJAX calls. Note: This feature doesn't require any other AJAX frameworks.

2. Support Custom Context Menu Items. We just extended the CustomCommandButton class, added a property CommandType. Set this property to ContextMenuItem to let it display as a Menu Item.
3. Support "$" reference style. For examples: $A$1, SUM($A:$B)

Aspose.Grid.Desktop
1. Added Autofit Feature. If a column header split line is double clicked, the column will auto resize. Worksheet class also provides Autofit methods from columns to rows.
2. Added Comment feature. Comments data can be read and save from file.
3. New property Button.AlwaysVisible, indicates if the button should be visible when cell is not in focus. This property only takes effect when the button is in a cell.

What's Improved?
Aspose.Grid.Web
1. Improved Formula Engine. Lift the performance up to 90%. Uses new algorithm to avoid stack overflow in deep nested call.
2. Improved the sorting performance.
3. Optimized the client side cell selecting event.

What's Fixed?
Aspose.Grid.Web
1. Fixed a minor display issue in IE7.

Aspose.Grid.Desktop
1. Fixed the FreezeCols and Cell Merge issue.
2. Fixed an cell input issue.

Aspose.Grid 1.9.3 Released!

2007-10-12T02:46:00Z

Dear Customers,
We have just released Aspose.Grid v1.9.3!

Introduction
This new version includes all the new features and fixes since v1.9.2

What’s New?
Aspose.Grid.Web
1. Supports Microsoft AJAX extention for .Net 2.0. You may use the GridWeb with the AJAX extention web control "UpdatePanel".
2. Supports TAB, SHIFT-TAB navigating.
3. New class CellImage. Use WebWorksheet.CellImages object to create a CellImage.
4. New method: WebCells.DeleteRows and WebCells.InsertRows, improved performance of deleting or inserting multiple lines of the sheet.
5. New property GridWeb.SessionMode, the old GridWeb.EnableSession is obsoleted.
6. New client side grid initializing event: OnGridInitClientFunction.
7. New client side method: getSelectedCells
8. Modified behavior: Totally hides the column when the column's width is set to zero.
9. Modified behavior: When GridWeb.ForceValidation is set to false, the grid does not validate input before postback.

What’s Improved?
Aspose.Grid.Web
1. Greatly improved databinding performance.
2. Enhanced the space and newline characters processing in the cells.

What’s Fixed?
Aspose.Grid.Web
1. Fixed the problem that when using AutoFilter feature, the filter buttons do not move to the correct position after a column resizing.
2. Fixed the parameter order issue of the "ATAN2" function.
3. Fixed the Firefox/Mozilla displaying problem when in XHTML rendering mode.
4. Fixed the Hyperlink color problem. Now the hyperlink's color will be the same as the cell's.
5. Fixed the problem that the hierachical view wrong displays in XhtmlMode.
6. Fixed the problem of pasting data cells from MS-Excel.
7. Fixed a formula null pointer problem in multi-user envrionment.
8. Fixed a problem with FreezePane feature.

Aspose.Grid.Desktop
1. Fixed the problem of Cell Merging and Freezing.

Aspose.Grid v1.9.2 Released!

2007-07-13T06:16:00Z

Dear Customers,
We have just released Aspose.Grid v1.9.2!

Introduction
This new version includes all the new features and fixes since v1.9.0

What’s New?
Aspose.Grid.Web
1. Supports XHTML 1.0 specification Rendering.
2. Supports Worksheets Serialization. Now users can use StateServer or SQLServer as session store.
3. Supports both Auto Filtering and Custom Filtering.
4. Supports CLS Compliant.
5. Supports dragging and scrolling.
6. Supports displaying command bar at the top of the control.
7. Supports displaying a "Loading..." box when PostBack.

What’s Improved?
Aspose.Grid.Web
1. Improved sheet tab scrolling.
3. Greatly improved the performance when there are a large number of validations of List/FreeList/DropdownList.
4. Greatly improved XHTML rendering performance(compared with 1.9.1.0).

Aspose.Grid.Desktop
1. New formula engine, greatly improved the formula executing performance.

What’s Fixed?
Aspose.Grid.Web
1. Fixed a problem of incorrect cell style after a sorting operation.
2. Fixed a problem of incorrect DropdownList display in XHTML rendering mode.

Aspose.Grid.Desktop
1. Fixed the bug of pasting a cell from another application.

Download URL: http://www.aspose.com/Downloads/Aspose.Grid/Default.aspx

Aspose.Grid 1.9.1 Released!

2007-05-28T01:04:00Z

Dear Customers,
We have just release Aspose.Grid 1.9.1.
New features and enhancements in this release (Since version 1.9.0):
Aspose.Grid.Web
1. Supports XHTML 1.0 specification.
2. Supports Worksheets Serialization. So you can use StateServer or SQLServer as session store.
3. Supports both Auto Filtering and Custom Filtering.
4. CLS Compliant.
5. Supports dragging and scrolling.
6. Supports displaying command bar at top side.
7. Optimized sheet tab scrolling.

Aspose.Grid 1.9 Released!

2007-02-12T06:22:00Z

Dear Customers,
We have just released Aspose.Grid 1.9!
Aspose.Grid.Web 1.9

0.Added Multi-Language Support. You may create a simple language file for the control to let it display in your own language.
1.New formula engine, lifts the performance of calculation for more than 20x than the old one.
2.Provides a new interface that enables users define their own formula functions. Please see the API document about WebWorksheets.RegisterCustomFunctionHandler for details.
3.Two new server event:RowDeleting, ColumnDeleting
4.New client-side functions: getCellValue, setCellValue, getActiveRow, getActiveColumn, setActiveCell, getActiveCell, setActiveCellByCell, getCell, getCellRow, getCellColumn, getCellValueByCell and setCellValueByCell
5.New client-side events:onSubmit,onError,onSelectCell,onUnselectCell,onDoubleClickCell,onCellError,onCellUpdated
6.Includes Full Featured Demo that shows the usage of the client-side functions and events.
7.Supports multiple rows selecting.
8.Supports keyboard selecting by holding the shift-key and pressing the arrow keys.
9.Supports create hints in the row and column headers.
10.Supports paste a string to multiple cells.
11.Supports datetime calculation. You may add days in a number to a date type value, or subtract a date value from another date value to get the duration in days between the two date value.
12.Fixed a problem. When you set a cell's NumberType to Text, the input string will not be parsed to any other value type and remains to be string type.

Aspose.Grid 1.8 released!

2006-11-14T08:24:00Z

Dear Customers,
We have released Aspose.Grid 1.8!
This new version contains many new exciting features and fixes some bugs:
Aspose.Grid.Web
1.Supports Grouping Rows feature(WebWorksheet.GroupRows).
2.Supports Creating Subtotal feature(WebWorksheet.CreateSubtotal).
3.Supports Formula Reference Automatic Updating: When inserting/deleting Rows/Columns, all formula reference in the sheet updated automatically.
4.Supports Importing/Exporting CSV and SpreadSheetML format files.
5.Improved muti-cells pasting.
6.New client-side Find/Replace feature.
7.New Formula Functions: COUNT, COUNTA, SUBTOTAL.
8.Obsolute Event: WebWorksheet.InitializeNewBindRow. Please use GridWeb.InitializeNewBindRow event instead.
9.Supports Application Parameters: aspose.grid.web.agw_client_path, aspose.grid.web.force_script_path
10.Fixed a bug of inheriting from the GridWeb class.
11.Fixed a bug of SmartNavigationg feature.
12.Fixed a bug of Re-DataBinding in a sheet.

Aspose.Grid.Desktop
1.Fixed the bug of when the formula value is "", the following cells text position shown error.
2.Supported index function syntax 1.
3.Supported cell function that information type is "CONTENTS".
4.Fixed the bug of pasting from excel spreadsheet.
5.Fixed the bug of when a cell's font and its column font not exist, its row font is not applied to the cell.
6.Supported the fonts not in FontFamily.
7.Enhanced all demos.