sorting table
 

News

On 15th February was released new version TreeGrid 6.3.
It contains many changes in Gantt chart, see TreeGrid Gantt Chart web site.



 

Brief description

EJS TreeGrid is a DHTML component written in pure JavaScript to display and edit data in sorting table, grid, tree view, tree grid or Gantt chart on HTML page

It is the fastest AJAX grid with the richest features set on the Internet.

   
 

sorting table

TreeGrid 6.0 is fast and can display large tables without any delayed rendering in reasonable times. This example displays 1,000 rows and 14 columns. All rows and columns are rendered on start and are shown immediatelly. Of course, using paging is much faster, you can choose Client paging and compare rendering times with the grid without paging. You can test features like sorting, filtering, grouping, column hiding / showing, column moving, print, export and so on, in such large table. In bottom debug window you can see the times spent by provided actions.

This example shows using editable, sortable and calculated TreeGrid with very large tables with more than 50,000 rows.
For navigation you can use vertical scrollbar, mouse wheel, arrow keys, PgDn, PgUp, Home, End, Tab.

Average count of rows in page. For client paging there are all pages created to contain this number of rows (except the last).
For server paging it determines height of page - it is default value of Count attribute.
Exact count of rows in pages can differ due to adding or deleting rows or in last incomplete page.
This value is returned as part of result of count ( ) function in formulas.
Every page must contain at least one row or is deleted. Exception is when grid does not contain any row, but must contain one page.
In TreeGrid server is this parameter used to set count of rows in page.
For large tables (> 50 000 root rows). Set it to default value of 100 to speed up rendering of large tables. Bigger value speeds up initial rendering, but can slow down TreeGrid usage and vice versa.
  
 

Supported browsers

Internet Explorer (IE6, IE7, IE8), all compatibility modes
Mozilla Firefox (FF1.5, FF2, FF3, FF3.5, FF3.6)
Google Chrome (CH3, CH4)
Safari (S3, S4)
Opera (O9, O9.5, O10)
 
And all IE, Mozilla and WebKit engine clones
 

sorting table

tree capability
advanced cell formulas , expressions and calculations like in MS Excel
various paging types to display nearly unlimited count (millions) of rows using AJAX and pager component
extended filters like in MS Excel or by any expression
searching like by Google
automatic grouping rows to tree according column values (like PivotTable in MS Excel)
fixed (frozen) columns and rows on all sides
spanning cells among columns (colspan) or rows (rowspan) or in both directions
dragging rows even among the grids (moving and copying)
selecting rows or cell ranges by key or mouse click or dragging and predefined or custom actions with the selection
moving columns, freezing or unfreezing columns by mouse
various cell types like text, number, check box, textarea, combo box, image, link or any other HTML, and so on
extended formatting values for display and edit, according to the type and format string.
calendar component to pick up dates
various editing masks
cell value validation while editing, after edit and before save
sorting table in textarea
printing capabilities
export to Microsoft Excel or any other spreadsheet program that can handle XLS files or HTML tables
synchronisation data with server
master / detail relationship
Gantt chart creating, including dependencies and dynamic updating.
displaying and dynamic updating of external objects like Adobe Flash, Microsoft SilverLight or custom JavaScript objects
fully customizable CSS styles to change grid look
extended JavaScript API with events and methods to control the grid from JavaScript
using grid without any need of JavaScript code on page
sophisticated XML input / output format
fully customizable key and mouse navigation action schemas
very fast to display and control
script modules - only required part of script can be included to HTML page
Localization possible to any language, including all texts, date and number formats
RTL version for Middle East languages plus Hirji dates
both CSS1 strict and quirks mode supported (any <!DOCTYPE> setting)
  
 

Basic grid features

editing cell content
updating changes to server by AJAX
or by page / form submit (HTTP POST)
sorting rows
adding and deleting rows
row state colors
column resizing
column hiding / displaying
toolbar
  
 

sorting table

EJS TreeGrid distribution contains many examples and predefined code for server side scripts:

ASP (VBScript)
ASP.NET (C#, Visual Basic)
JSP (Java)
PHP
HTML (all other)

EJS TreeGrid can be used also in any other server script environment that can handle and process XML data.
   
sorting table