Editable JavaScript TreeGrid
Version 2.1

Description
EJS TreeGrid is DHTML component written in pure JavaScript to display
and edit data in table, grid, tree or tree and grid. It is client component and
runs on client browser. It is compatible with the most of standard browsers. It
does not require any installation or other components on client or server side.
It has very small code (about 50 kB) due compression used. It communicates with
server by standard HTML submit (POST) command. Bandwidth between server and
client is reduced to minimum because all actions are performed on client side
and to server are sent just pure data on submit.
Basics
- Compatible with Internet Explorer 5.0+, Mozilla 1.0+,
Mozilla Firefox 1.0+, Netscape Navigator 6.0+, Opera 7.0+.
- There is no other requirements on client side.
- All operations are performed on client side, without sending data to
server.
- Data format is small, server sends only values, not graphic formatting.
- TreeGrid code is compressed to about 50 kB
- User script extension by defined events in TreeGrid. For data
validation or changing value after edit, to approve an operation, to change
TreeGrid look, and many more.
- Extended API to control all functions of TreeGrid
- Visual settings by CSS styles.
- Row and cell colors by their state (changed, deleted, added,
focused, selected, mouse hover, editable, ...).
- User settings (column position and size, type of sorting, grid settings)
are saved at client to cookies or sent to server.
- More treegrids on one page, possible operations among them (dragging rows
for example). Different styles/images/colors for them are possible !
- Master / detail grids or even tree grids.
- Calculated cells like in MS Excel, include mathematic, aggregate
(sum, count, sumif, ...), statistic and user-defined functions. Or any JavaScript code in
formulas.
- Control panel for TreeGrid operations. Can be inside or outside of
TreeGrid.
- Detailed documentation of TreeGrid usage, events, data format, API and cell formulas.
Functions
- Displaying data in rows and columns in treeview with tree and grid or in
pure datagrid without tree.
- Displaying and formatting values according to their type (string, boolean,
integer, float, enum (select), datetime, html, ...). Possible edit masks.
- Values types and formats are usually set for whole column but can be set
individually for cell. Cells can be set as readonly.
- Editing values based on their type and html form elements (input, checkbox,
select, textarea, ...). For dates is used own calendar.
- User buttons in cells, prepared user dialog
- Expanding / collapsing rows in tree.
- Controlling by mouse or by keys.
- Adding and deleting rows.
- Moving and copying rows by mouse dragging (drag and drop operations
with rows and groups of rows). Even among more TreeGrids. Controlled by user
events.
- Resizing and moving columns.
- Selecting rows and operations with selected groups (moving, copying,
deleting, dragging, ...)
- Sorting rows by one or even more columns, string compare - case and
localization sensitive or ignore
- Scrolling of parts of content - fixed and variable rows and columns
on all sides. Mouse wheel compatible.
- Localization possible. Now in English and Czech language.
Examples
- Pure grid with fixed rows and columns, dragging enabled, many column types,
user button and dialog, ... - E - PureGrid.html.
- Calculated pure grid (some bill) -
E - Calculated PureGrid.html.
- Calculated tree grid (extended bill), with dragging enabled, different
types in one column, sorting, column resizing/moving, read-only cells, ...
E - Calculated TreeGrid.html.
- Master and detail grid - more grids at one page, related as master and
detail. With dragging enabled. Just simple example -
E - MasterDetail (Just
simple).html.
- Sample real application - Employee bonuses -
Bonuses.aspx.
Documentation
Download
- Evaluation version. This version includes
TreeGrid core files, examples and help. Examples can be executed on
local computer, just in browser. Remember, in IE on Windows XP SP2 you must
confirm JavaScript execution if you browse locally (fortunately, on server it
is not needed).
Licensing and prices
- Client usage is unlimited and free, the TreeGrid is licensed just for
server.
- With TreeGrid you will get documentation of simple use, detailed
description of data format, events and simple API (or extended API) in English
language.
- I can cooperate with you on your application or I can write whole
application with TreeGrid for you by your specifications. I charge 55 USD
per hour. In case of whole commission we can negotiate the price.
- License for one copy for one application and one server - 600 USD.
The code of TreeGrid can be used in one web application running at one server
- if you develop your web application just for single usage (at your own
server or at server of one your customer).
- License for unlimited copies in one web application - 1300 USD. The
code of TreeGrid can be used as part of one application created by one company.
- License for one company - 2500 USD. The code of the TreeGrid can be
used as part of all applications created by one company.
- Extended API - 600 USD. Just together with some license. You will
get TreeGrid version with all functions visible and documentation for them.
- Source code of TreeGrid - 1500 USD. Just together with some license.
Email
- If you wish to use this grid on your web pages or build office web
applications with such or similar components, email me:
prst@atlas.cz
© Jan Kohout, 2005