# Product - Sigma Grid 2.0 - Demo List

## Integration Samples

Master/Details
In a master-detail case you have at least two grids. One is linked to the other somehow. In this demo, we have a list of customers, and sales for each customer.
Cell phones shop
In the mockup, you will see how to change row height, display images and create button in cells.

## Cell Editor & Renderer

User defined cell renderer
This demo shows how to customize cells presentation. In fact, you can display data with formate as you wish.
Image cell - Hyper link cell
These two samples demonstrate how to display image and hyper link in cells.
Long text in cell
Simga grid allow you to store a long text in a cell. A tip box will pop up when mouse is over those cells.
Various cell editor
Text input, downdown list and calendar are built in for cell input.
Customized cell editor
This sample can tell you how to define a new editor for some specials columns, for example, color picker for color input.
Cell editor
The feature enables end user to modify data in a grid and post the changes back to the database.
Data validation
This feature help you validate input before the content is accepted.

## Filtering

Dynamic search
Data filter enables sigma grid to present the data users are interested in only.
Filters combination
Developer can apply a couple of filters to one grid in the same time.

## Formular

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.

## Grid

Show and hide grid
This is a basic example showing how to show or hide a grid in run time.
Main menu
This sample demonstrates built-in main menu with many functionalities.
Resizable grid
End user can resize grid by dragging and dropping the right bottom angle.
CSS Based Themes
The Datagrid look is controled via CSS. Choose from existing themes, or create your own.
Event
Plentiful attibutes and event handlers give you more flexibility without coding too much.

## Header

Controls in header
The feature allows your to place controls in header.
Changable row height
This sample show how to change row height of a grid.
Nested headers
Span the grid column headers. Useful to group columns under a category.
Add image to header
The feature provides end users with a vivid description of header by inserting a picture to it.

## Huge datasets

Paging
Sigma grid enables easy paging through data. When using the built-in paging functionality you do not need to much coding work. You can set the grid to use paging and specify a page size (number of records to display).
Checkbox in paginal grid
This feature enables the grid to save checkbox status in paginal grid.

## Printing & Chart

Print
The feature helps end users to print out the grid.
Print complex grids
The feature helps end users to print out complex grids.
Charts and graghs
Bar diagram, line diagram and pie diagram built in. Translation tabular data into diagram without any server-side coding.

## Rows

Selectable Single or Multiple Rows
This Online orders example demonstrates the ability to select multiple rows in the grid.
Change row height
The cell phone shop sample show ability of sigma grid to change it's row height.
Highlight row on mouse over
Sigma grid provides the functionality to highlight the row by adding a dazzle underline.
Row number
Sigma grid provides the functionality to show row numbers in the left.
Add or delete a row
The feature enables end users to add or delete a row easily.
Row striple
The feature facilitates grid viewing by striped rows.

## Column

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.
Movable columns
The feature enables end user to move any column to a new location in the grid.
Resizable columns
The feature enables end user to resize the column widths.
Sortable columns
The feature enables end user to End users can sort the table by clicking on the header of a column.
Grouping by column
This sample shows how to group by column.