Editable JavaScript FastGrid

Main advantages

• display of millions of rows or columns without any visible paging or scroll gap
• different column sets, every row can have different columns, their widths and structure
• tree feature in rows or columns or both
• advanced cell formulas, expressions and calculations like in MS Excel
• advanced filters similar to MS Excel or filtering by any expression
• searching like in Google
• automatic rows grouping to a tree according to column values
• multi level Pivot tables (two dimensional grouping), editable, unlimited source columns
• fixed (frozen) columns and rows on all the edges
• cell spanning among columns (colspan) or rows (rowspan) or in both directions. Dynamic span by users also available.
• row dragging even among the grids (moving and copying)
• row resizing by mouse dragging. Vertical alignment of the row content.
• row, column or cell ranges selecting by key or mouse click or dragging; predefined or custom actions with the selection possible
• sticky rows - row displayed statically on top during vertical scroll until shown next sticky row
• column moving, freezing or unfreezing by a mouse.
• column adding, copying and deleting.
• various cell types like text, number, check box, textarea, combo box, image, link or any other HTML, etc.
• advanced formatting values for displaying and editing according to the type and format string.
• a calendar component to pick dates; a special dialog to choose date ranges and repeating dates.
• various editing masks
• cell value validation while editing, after edit and before save
• multi line editing in textarea
• rich text / HTML editor in contentEditable tags, full inline WYSIWYG editor, text, color and shapes styling, images and links.
• inserting images to cell text or outside cells like MS Excel, by dropping it to cell or opening image file chosen from file system.
• editing images inside or outside cells by mouse dragging - move, resize, rotate, crop, change opacity or name.
• cell focus cursor for one cell or cells rectangle like in MS Excel. Dragging focused cells.
• auto fill cell values by mouse dragging like in MS Excel
• auto complete combo with suggest list for any cell
• printing option or export to PDF with various PDF settings and possible splitting to pages in both directions
• export to Microsoft Excel or any other spreadsheet program that can handle XLSX, CSV files or HTML tables
• advanced JavaScript API with events and methods to control the grid from JavaScript
• using grid without any need of JavaScript code on a page
• sophisticated JSON input / output format
• optional very short and fast UTF8 store input format
• fully customizable key and mouse navigation action schemes
• full manual and automatic toolbar arrangement
• very fast to display and control
• localization to any language possible, including date and number formats