Aspose.Grid

Aspose.Grid for .Net 2.0.0 New Release

laurence — Tue, 13 May 2008 07:26:18 GMT

Dear Customers,
We have just released Aspose.Grid 2.0.0!

What's New?
Aspose.Grid.Web
1. GridWeb is now compiled under both 1.0 and 2.0 frameworks.
2. Fully supports .NET 2.0 framework.
3. Supports .NET 2.0 MEDIUM TRUST LEVEL.
4. Supports .NET 2.0 DataSourceControl Binding.
5. New Client Api Method resizeColumnToFit.
6. Supports Windows Vista.

Aspose.Grid.Desktop
1. New property GridCell.Protected, indicates if the cell is protected. If the value is "true", user can not modify the cell through the user interface.
2. New property ComboBox.IsInputable, indicates if the user can input text to the combobox. The inputted text will be saved as the cell's value.
3. New event Desktop.CommentDataChanged, occurs when the comment data has changed..
4. New property Validation.CustomMsgForStopEdit, enables the user gets or sets the custom message to show when user enters invalid value.
5. New method Worksheet.SetFirstVisibleColumn()/SetFirstVisibleRow() enables the user to set the first visible column/row index of sheet view.
6. New method Worksheet.GetFirstVisiableColumn()/GetFirstVisiableRow() enables the user to get the first visible column/row index of sheet view.
7. New method Worksheet. AddSelectedRange() enables the user to add new selected range to the worksheet..
8. New property Worksheet.ShowGridlines, enables the user to show/hide the gridlines.

What's Improved?
Aspose.Grid.Web
1. Improved XHTML Support.
2. Improved Sorting. Null Cells will always stay at the rear.
3. Improved Copy/Paste.

What's Fixed?
Aspose.Grid.Web
1. Fixed the bug of AutoFilter buttons will not be repositioned after AutoFit a column.
2. Fixed a bug of Excel Exporting.
3. Fixed a bug of Can't get the Cell object of a Commmand Type Hyperlink when in XhtmlMode.
4. Fixed the bug of AJAX auto updating doesn't work in a form using Master Page.

Aspose.Grid.Desktop
1. Fixed a bug of comment display.
2. Fixed an input issue: In the previous version, in some special condition, press enter key in an editing cell will clean the cell's content.

Aspose.Grid for .Net 1.9.4 Hot Fix

laurence — Fri, 21 Dec 2007 04:41:01 GMT

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 "$" 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 for .Net 1.9.3 Hot Fix

laurence — Fri, 12 Oct 2007 07:01:44 GMT

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 for .Net 1.9.2.0 Hot Fix

henry — Fri, 13 Jul 2007 14:22:06 GMT

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.
2. Greatly improved the performance when there are a large number of validations of List/FreeList/DropdownList.
3. 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 for .Net 1.9.1.0 Hot Fix

henry — Mon, 28 May 2007 01:04:00 GMT

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 for .Net 1.9.0.0 New Release

henry — Mon, 12 Feb 2007 06:22:00 GMT

Dear Customers,
We have just released Aspose.Grid 1.9!
Aspose.Grid.Web 1.9
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 for .Net 1.8.0.0 New Release

henry — Tue, 14 Nov 2006 08:24:00 GMT

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.

Aspose.Grid for .Net 1.7.4.0 Hot Fix

henry — Tue, 19 Sep 2006 03:07:00 GMT

Dear Customers,

We have just released Aspose.Grid version 1.7.4!

This release fixed some bugs and brings some great new features.

Aspose.Grid.Web
1.New control: GridWebForm, works with a GridWeb control, enables you to display/edit data in a record based form view window.
2.New method Validation.LoadValueList, loads value/text items to the dropdownlist or listmenu.
3.Enhanced List/DropDownList/FreeList features, supports Value/Text pair in a list item.
4.Supports DataSourceControl DataBinding in Vs.Net 2005.
5.Supports DropDown Calendar control in a Date/DateTime validation cell.
6.New Property GridWeb.EnableSmartNavigation(bool), Enabled by default. Supports Background Post Back and smooth visual effect without page refreshing.
7.New event: GridWeb.BindingChildView, enables you to modify the default child view's bindcolumns before binding the child view sheet.

Aspose.Grid.Desktop
1.Fixed the bug of text direction when rotating 90 or -90 degrees.
2.Extend no wrap text supported.
3.Stdev, averagea functions supported.

Aspose.Grid for .Net 1.7.3.0 Hot Fix

henry — Wed, 23 Aug 2006 01:17:00 GMT

Dear Customers,
We have just released Aspose.Grid version 1.7.3!
New features and enhancements in this release:
Aspose.Grid.Web
1.CheckBox Validation type supported.
2.Added WebCells.Unmerge method.
3.Support double-click to auto fit the width of a column.
4.Updated C# and VB.NET Demos.
5.Full tested under Netscape Browser Version 8.1.

Aspose.Grid.Desktop
1.Optimized performance of inserting and deleting row and column.
2.Fixed the formular bug referencing to other sheet.
3.Fixed the formular bug referencing to absolute address array.
4.The "VLOOKUP" function is supported.
5.Fixed the Combobox Control bug that the listbox can't be shown when clicked.

Aspose.Grid for .Net 1.7.2.0 Hot Fix

henry — Sat, 12 Aug 2006 08:20:00 GMT

Dear Customers,
We have released Aspose.Grid 1.7.2!
Fixes and Enhancements in this release:
Aspose.Grid.Web
1. Added "Hierarchical View" feature in Data Binding mode.
2. Fixed some formatting problems when running with none English locale settings.
3. Added GridWeb.DisplayCellTip property to let you enable/disable the default tooltips of cells.
4. Added GridWeb.NoScroll property.
5. Improved performance of adding/deleting rows/columns.
6. Creating hyperlinks in column headers supported.
7. Creating cell-command in binding columns supported.
8. Supports column headers clicking and sorting.

Aspose.Grid.Desktop
1. "Click start cell then shift and/or ctrl click end cell" supported.
2. SelectedCellRangeChanged event supported.
3. Fixed the not supported the regular style font.
4. SetStyle with bitmask supported.
5. "$A$1" formula style supported.
6. Fixed the formula styles not supported in ImportExcelFile.
7. Fixed the font and font color bug.
8. Mouse drag scroll supported.
9. "Vertical text" supported.
10. Fixed the bug of grouping same ranges more than twice.

Aspose.Grid for .Net 1.7.1.0 Hot Fix

henry — Wed, 12 Jul 2006 03:57:00 GMT

Dear Customers,

We have just released Aspose.Grid 1.7.1!

Aspose.Grid.Web 1.7.1

Aspose.Grid.Web Designer now supports .net 2.0 and vs.net 2005.

Aspose.Grid.Desktop

Fixed an internal bug

Aspose.Grid for .Net 1.7.0.0 New Release

henry — Tue, 04 Jul 2006 04:03:00 GMT

Dear Customers,
We have just released Aspose.Grid 1.7!
This version inclucdes many new exciting features:
Aspose.Grid.Web 1.7
1.New METAL-LIGHT Look & Feel.
2.Added Fully DataBinding Support. Now it supports binding sheets to DataSet, DataTable, DataView or any Collection Objects. The control loads data from the DataSource, and updates the DataSource automatically.
3.Added new "Worksheets Designer" in the vs.net IDE. You may use it to create powerful database binding applications with few mouse clicks and few lines of code.
4.Added new Validation types: FreeList, Number, Integer, Date, DateTime and CustomFunction.
5.Improved visual effect and usability in None-IE browsers.
6.Added 6 new color properties to enable you adjust the ActiveCell/SelectCell/SelectHeader's Color/BackgroundColor.
7.Added new property "Visible" to WebWorksheet. You may use it to hide a worksheet from the TabBar.
8.Added Custom Command Buttons Support. You may create your own buttons at the control's TabBar.
9.Now you can use the RegularExpression Validation with one of other Validations at the same time.
10.Added WebWorksheet.Copy(WebWorksheet) method, enabling you copy a worksheet's content to another worksheet even if they are in two different GridWeb control.
11.Added Client-Side Submit/Validation event Support. You may write your own client script to handle the client-side submit or validation error event.
12.Added formula functions "MIN", "MAX".
13.Fixed the bug of losting data types when importing from a DataView object.
14.Fixed some problems in VS.NET 2005.
15.Optimized performance when there are large number of Validations in a sheet.

Aspose.Grid.Desktop 1.7
1.Grouping rows or columns supported.
2.Hiding row column header supported.
3.Fixed the Button or ComboBox of a focused cell will hide a part of text of the cell.
4.Fixed the bug of AddRow method.
5.Fixed the bug that the control can't be created instance in VS.NET 2002.
6.Demo projects support VS.NET 2002.
7.Fixed the bug of Dock.Fill property of the control.
8.Optimized performance of ImportExcelFile and ExportExcelFile method.
9.Added CreateRange method to Worksheet class.
10.Added Copy method to CellRange class.

Aspose.Grid for .Net 1.6.0.0 New Release

henry — Tue, 25 Apr 2006 14:51:00 GMT

Dear Customers,
We have just released Aspose.Grid 1.6!
Enhancement and Bugfix in this release:
Aspose.Grid.Web
1. Add Full Support for none IE browsers, including Mozilla, FireFox and Opera.
2. Add GridWeb. EnableClientResizeColumnRow property.
3. Support relative path when use CustomStyleFileName.
Aspose.Grid.Desktop
1. Support Exporting to DataTable.
2. Rename DataBind() method to ImportDataTable().
3. Fixed the ColumnControl bug that Combox or CheckBox control does not work well.
4. Add Values collection to Combox control.
5. Support Data Binding.

Changes Since Aspose.Grid release 1.5.0

Aspose.Grid 1.5.3
Aspose.Grid 1.5.2
Aspose.Grid 1.5.1

Aspose.Grid for .Net 1.5.3.0 Hot Fix

henry — Tue, 28 Mar 2006 14:16:00 GMT

We have just released Aspose.Grid 1.5.3!

Enhancement and bugfix in this release:

Aspose.Grid.Desktop

Enhanced:
1.Column validation supported.
2.Column control supported.
3.R1C1 reference style supported.
4.Sorting supported.

Aspose.Grid.Web

Fixed bugs:
1.When the number of rows is greater than about 100, FreezePanes(Fixed Rows/Columns) sometimes disappeared.
2.When multi-select a range of cells and paste data, readonly cells are modified.
3.DropDownList type cells can be deleted.
4.Column's width are not proper at some region settings.

Enhanced:
1.Support setting custom column/row header captions(WebCells.SetRowCaption, WebCells.SetColumnCaption).
2.Support sorting a range of cells, both top to bottom and left to right orientation(WebCells.Sort).
3.Support export cells data to a DataTable object(WebCells.Export).
4.Aspose.Grid.Web UI Designer. Runs from System Start Menu or Visual Studio Environment(Only Support .net 1.0/1.1 by far).

Aspose.Grid for .Net 1.5.2.0 Hot Fix

henry — Wed, 08 Mar 2006 13:57:00 GMT

We have released Aspose.Grid 1.5.2!

Release Notes

Aspose.Grid.Web

Fixed: client-side setting color bug
Fixed: TableStyle/TableItemStyle CssClass property doesn't take effect bug
Support Creating Pivot Table Reports
Support client-side multi-cells select/copy/cut/paste/set style
Support client-side right-click menu operations: freeze/unfreeze; insert/delete row/column; merge/unmerge cells;
Support Hyperlinks(Text or Image Display, UrlLink or CellCommand Action)
Added properties: ActiveCell, EnableClientColumnOperations, EnableClientFreeze, EnableClientMergeOperations, EnableClientRowOperations, SelectCells
Added Methods: WebCells.GetColumnReadonly, WebCells.SetColumnReadonly, WebCells.GetRowReadonly, WebCells.SetRowReadonly
Added events: SheetDataUpdated, LoadCustomData(for Sessionless mode data recovering), CellCommand, ColumnDeleted, ColumnInserted, RowDeleted, RowInserted, PageIndexChanged
Changed: Now the client file web-path(/agw_client) and the client files(htc, gif, etc.) are not needed in deploying environment. These files are now embedded in the control. This simplifies the deploying and upgrading operations.

Aspose.Grid.Desktop

Enhanced:

Column header text Supported.
Context menu Supported.
Hyperlinks, comments, pictures exporting supported.
Cell button, checkbox, combox supported.
CellClick, CellDoubleClick, CellKeyPressed events supported.
Applying style to range of cells supported.
Data validation supported.

Fixed:

Minimizing the form that contained the GridDesktop control which set the Dock property Fill, an exception is thrown.
Pressing "delete" key, the GridDesktop control does not raise CellDataChanged event.
When row number is greater than 4 digitals, row header's width is not enough.
When load from excel file, the font of char that input in a cell is different from the font of cell.
Can't input Enter in a cell, now use Control + Enter keys.
If there are not focused cells, textbox control will be placed at error position when input char.
There is a comment in a cell, and then focused the right cell; when point to the cell that contains a comment, the focused cell will glint always.
Hiding row column does not work.