Go to Sigma Grid 2.0 with more powerful functionalities
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
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.
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.
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.
Sigma Grid architecture adopts typical MVC (Model-View-Controller) pattern(see following chart). The cell presentation is separate from its internal value.
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.
OGNL format supported
smooth objects converting between presentation layer and logic layer. hot!
Online printing technology, to make it easy to build a traditional-look printable reports without anything installed. hot! See demo.
Seamless Integration with any server side solution, such as j2ee, .net, PHP, perl. v
IE 5.x+ \ Mozilla 1.4+ supported.
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
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.
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.
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.
All contents are (c) Copyright 2005 - 2007, Sigma Software
Inc. All rights Reserved