Aspose.Grid Functionality

enriquep · April 20, 2009, 12:04pm

Hello there,

I have a customer looking for a ASP.NET AJAX Grid with the below functionality:

---------------------------------------------------------------------------

Can I customize the quantity of records that can I see through the grid?

How is the navigation of the grid?

Can I include a grid inside another grid?

Can I include horizontal and vertical scrolls to navigate the grid?

Can I customize the design using external CSS files?

Can I export information to XLS and CSV files?

The ASP.NET components can work in IE 6.0, Firefox 1.0 and Netscape 7.0?

Can I edit information directly in the grid?

Can I format the cells of the grid (numeric, date, etc)?

Fixed Columns: The columns of the grid should allow the anchor (Set one or more columns simultaneously).

Inserting and removing rows: The grid must support the call for events ( "actions") to perform insertion and removal of records.

Formula: We must have the option to generate column summation values, Quantity, Minimum, Maximum, Average.

Dynamic Clustering: Allow grouping of data dynamically. (By Drag column).

Dynamical sorting: The grid must allow for one or more sort columns (simultaneously) in ascending or descending.

Combining Controls: Use controls with in the cells of the grid (Menu Combo, Edit text, Checks, Radio Buttons, Buttons and Links).

Filters: Allow filter data in a simple manner by means of property (without generating additional code).

Wizards: Must permit the use of wizards to add great complexity in the design grid.

Additional Components: Controls that can further improve application performance.

The grid controls, must be smaller than 150Kb in bytes per page.

Any help you can provide would be very much appreciated.

Kind regards,

Enrique Perez

This message was posted using Email2Forum by sheliah.

amjad.sahi · April 20, 2009, 1:14pm

Hi Enrique Perez,

Thanks for your inquiry.

Well, you may use Aspose.Grid.Web control that does support MS Ajax extensions. Aspose.Grid.Web (original package is Aspose.Grid which includes two controls i.e. Aspose.Grid.Web and Aspose.Grid.Desktop) is a GUI control that provides MS Excel like environment in WYSIWYG manner, you may easily place it on the webpage (.aspx webform). It has its own grid matrix and has its own formula calculation engine to calculate all types of formulas at runtime. It can load existing excel files to the grid matrix (cells in rows/columns) and can also save output files to disk. It allows user can design its spreadsheet of his need too dynamically and through APIs. For ref, please check the source code of Aspose.Grid.Web demos: the demos get automatically installed on your machine when you use control's MSI installer. Please check the docs for further ref:

Now, for your queries:

Can I customize the quantity of records that can I see through the grid?
Yes, you can do it, please see how you can create a simple matrix.

// Creates a 4x4 “display window”.

GridWeb1.MinRow = 2;

GridWeb1.MaxRow = 5;

GridWeb1.MinColumn = 3;

GridWeb1.MaxColumn = 6;

How is the navigation of the grid?
Yes, it does support all types of navigation b/w its cells/worksheet similar to MS Excel. You may use arrow keys, mouse key or enter key, tab key etc. for navigation.

Can I include a grid inside another grid?
I think you are talking about Heirarchical view of the gridweb, check the feature demo: http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/data-bind/expand-child-view.aspx

Can I include horizontal and vertical scrolls to navigate the grid?
Yes, you can do it. Aspose.Grid.Web (by default) provides this feasibility (will show the scrollbars if the contents are more than the grid’s height / width.

Can I customize the design using external CSS files?
Well, you may change/apply preset styles and also you can create your own custom style to apply to the gridweb. Check the demo: http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/common/change-style.aspx

Can I export information to XLS and CSV files?
Yes, you may do it, check the docs: Aspose.Total Product Family

The ASP.NET components can work in IE 6.0, Firefox 1.0 and Netscape 7.0?
Yes, the control does work on your listed browsers.

Can I edit information directly in the grid?
Yes, as I said you may edit data, styles , formula other tasks directly in WYSIWYG (visual) manner.

Can I format the cells of the grid (numeric, date, etc)?
Yes, you may do it with ease.

Fixed Columns: The columns of the grid should allow the anchor (Set one or more columns simultaneously).
Well, you may freeze panes for your need and the control support this feature. Check the docs: Aspose.Total Product Family

Inserting and removing rows: The grid must support the call for events ( “actions”) to perform insertion and removal of records.
Yes, sure, you may do it. Check the docs: Aspose.Total Product Family

http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/common/events.aspx

Also, The GridWeb supports RowDeleted and RowInserted events that you can make use of them.

Formula: We must have the option to generate column summation values, Quantity, Minimum, Maximum, Average.
Yes, Aspose.Grid.Web supports setting and calculating the results of formulas same like MS Excel. Please check some demos in the section: http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/formula/default.aspx

Dynamic Clustering: Allow grouping of data dynamically. (By Drag column).
Yes, the control allows this feature, please check the docs: Aspose.Total Product Family and a demo: http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/grouping/grouping.aspx

Dynamical sorting: The grid must allow for one or more sort columns (simultaneously) in ascending or descending.
Yes, kindly check the demo: http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/common/sort.aspx

Combining Controls: Use controls with in the cells of the grid (Menu Combo, Edit text, Checks, Radio Buttons, Buttons and Links).
Well, you may use Validation to insert some controls, please check the demo: http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/common/data-validation.aspx

Filters: Allow filter data in a simple manner by means of property (without generating additional code).

Yes, kindly check the demos in the section: http://www.aspose.com/demos/visual-components/aspose.grid/csharp/demos/filter/default.aspx

Wizards: Must permit the use of wizards to add great complexity in the design grid.
Which wizard types you are talking about, could you give us more information about it.

Additional Components: Controls that can further improve application performance.
Which controls you have mentioned, could you elaborate it more.

The grid controls, must be smaller than 150Kb in bytes per page.

Could you elaborate it more which size you are refering. The gridweb is rich .NET control based on a library file and other dependencies (Aspose.Grid.Web.dll file and other files).

Thank you.