Sigma Grid -- Ajax editable data grid - DHTML grid control with flexibility and user API.

Features

Aggregate and aggregate by group
Build-in functions(min, max, avg, sum, count) helps developer calculate aggregate on client side. What is more, Sigma grid can calculate aggregate group by group without any request to server side. See aggregate demo and aggregate by group demo.

Alignment
Developer can specify different aligments on different columns.

CSS Based Themes
Sigma grid appearance is controled via a stand-alone CSS(style sheet). Developer can change grid skin by defining themes in different CSS files. See demo.

Event handlers & user API
Plentiful attibutes and event handlers give you more flexibility without coding too much.

Inline cell editing
Inline cell editing just as you would in MS Excel. Navigate with the tab or enter key to move between cells . End user also can remove / add / append rows. See demo.

Linkable grids
Allow you to create multiple grid instances on one web page. With events and JavaScript API, Developers can implement one-to-many or many-to-many relationships (master-detail) at ease . See demo.

Lockable header and column
This feature enable you to keep some columns and/or header always visible in spite of user scrolling grid. Similar to the window freeze panes option in MS Excel. See demo.

Math formulas for cells
Developer can specify some cells to be a formula instead of a value. What is more, whether a cell is editable could depend on a boolean formula.

MVC architecture
Sigma Grid architecture adopts typical MVC (Model-View-Controller) pattern(see following chart). The cell presentation is separate from its internal value.

Nested headers
One of the new features is the ability to have unlimited levels of nested headers. This allows for presentation of adjacent columns related to each other. See demo.

OGNL format supported
smooth objects converting between presentation layer and logic layer. hot! See demo.

Online Printing
Online printing technology, to make it easy to build a traditional-look printable reports without anything installed. hot! See demo.

Pure javascript codes
Seamless Integration with any server side solution, such as j2ee, .net, PHP, perl. v Cross browers
IE 5.x+ \ Mozilla 1.4+ supported.

Paging
This feature enable developer display data page by page. Data will not be retrieved from server side until end user come to the page it is at. Developer can control how many rows are displayed at one time. See demo.

Resizable Columns
Columns width could be changed by end user draging columns header.

Single selection & multi selection
Sigma grid has the ability to select non-contiguous rows. This allows for more robust manipulation of records in the Grid. See demo.

Slice rendering
You may load thousands rows of data into grid in one time.Slice rendering could help you increase user experience. When this mode activated, everytime the vertical scroll bar is dragged, SigmaGrid will detemine which rows are visible and paint them out. See demo.

Sorting & various data types
End user can sort records by clicking on the header of a column. Developer can specify sorting way for various types including string,number,boolean,link,select and percent. Developer may define a new data type and a new way to sort.

User defined editor & renderer
Extensibility enable you to replace built-in cell editor with custom external component, present cell data as your customers' wish. See demo.

Various load sources
Developers can export data to / load data from variouse sources, including in JSON, XML, CSV (Comma Separated Values) format, to support further editing within spreadsheet or any other applications.