Includes:

TAdvStringGrid: highly supercharged string grid
TAdvGridWorkbook: multisheet version of TAdvStringGrid
TAdvColumnGrid: string grid with flexible column oriented property management
TAdvSpreadGrid: formula-aware spreadsheet version of TAdvStringGrid
TDBAdvGrid: data-aware version of TAdvStringGrid
TAdvPreviewDialog: print preview dialog
TAdvGridPrintSettings: dialog for setting the various grid's print options
TAdvGridHTMLSettings: dialog for setting the various grid's HTML export features
TAdvGridFindDialog: dialog wrapping all grid's find functionality
TAdvGridImportDialog: dialog for help during TXT or CSV file import
TAdvGridExcelIO: native XLS file import & export with TAdvStringGrid, TAdvColumnGrid, TAdvSpreadGrid and TAdvGridWorkbook TESBMathsLib: ESB Mathematics library for TAdvSpreadGrid by ESB Consultancy
TChartLink: Synchronize TChart's with grid's data in a codeless way
TFormCtrlLink: component to link any TWinControl descendent as inplace editor for grids

FLEXIBLE PRINTING

Through properties you can have :

• page number, date, time, title in footer or header
• different header & footer font
• use cell font and color from display or different print font control
• automatically splits columns over multiple pages if needed
• print selected regions from the grid
• set margins, print centered
• use repeated fixedrows and fixedcolumns for multiple page output
• automatic fit to page
• see before you print with preview
• specify borders of each cell for printing
• additional custom printing
• wordwrapped, rich text, HTML formatted text printing
• HTML formatted print titles

ENHANCED DISPLAY

• set text alignment to Left, Justify, Right for each cell
• each cell can have different font & background color
• select from singleline, multiple line to automatic wordwrap
• show URLs as real clickable URLs
• draw ellipsis when text doesn't fit column
• hidden columns
• wallpaper
• rich text cells
• HTML formatted cells

EASY NAVIGATION

• automatically advance to next cell
• single key insert and delete rows
• automatic cells cut and paste
• masked edits with autoadvance
• immediate caret positioning on mouseclick
• automatic sorting when column headers are clicked with several sort methods and customizations.
• cell search functions
• cell editing disable capability
• different hints for each cell
• incremental key lookup
• dynamic scroll hinting
• easy & intelligent clipboard functions with auto fill and auto expand ranges & rich text aware
• enhanced row and column moving with position indicators
• automatic skip over fixed and read-only cells

FLEXIBLE FILE INPUT OUTPUT

• save to file, load from file
• save to CSV, load from CSV
• save to XLS, XLS sheets, load from XLS, XLS sheets
  (native support, without the need to have Excel installed)
• save to streams, load from streams
• save to HTML with color,  alignment and font markup
• save / load from formatted ASCII files
• save to Word DOC files
• save to XML files
• load from MDB tables

ADVANCED EDIT CONTROLS

Have your choice of edit controls

• normal left or right aligned edit controls
• masked edit controls with automatic cell advancement
• checkboxes, comboboxes, cell data bound checkboxes
• datetimepicker, timepicker, datetimepicker with up/down
• edit control with ellipsis button
• comboboxes and edit controls with auto-lookup and auto history
• integer, float, time, date, spinedit control
• button control
• radio button control
• use another custom editor
• expand/contract node controls
• rich text inplace editing

HAVE GRAPHICS EVERYWHERE

Add images to your cells

• control positioning of image on top, bottom, right, left ...
• add icons, bitmaps, imagelist items and data dependent images
• rotated text
• multi image cells
• TPicture, TFilePicture objects opening support for all kinds of graphic formats
• progress bar
• button
• comment indicator

MAKE THE GRID FORMULA-AWARE WITH TADVSPREADGRID

• simple formula editing interface
• auto recalculation
• single cell recalculation, full recalculation
• extensive range of mathematical functions
• save with formulas
• single cell references in formulas
• cell range formulas
• formula precision for grid on cell basis
• display formulas or formula results
• date / time functions
• intelligent formula aware copy and paste
• can be extended with custom functions
• cell names
• cell name mode can be RxCy style or A1-style
• formula & constants libraries
• inter grid formulas

AND MORE ...

• Supports mousewheel events
• Saves user resized column widths to .INI file or registry
• Automatical column numbering
• All kinds of routines to delete, clear, move, hide columns & rows
• Selection of full rows & columns with mouse
• Set column headers and fixed rows at design time
• Disjunct row selection
• Flat and proportional scrollbars
• OLE drag & drop within grid and between grid and Excel, Word, ...
• Group and UnGroup functions and grouped sorting
• Multicolumn filtering
• and more ...
• Your feature could be here too, ask for it !

FREE UDATES & SUPPORT

Registered users receive license for commercial use and source code.
All source code updates for a full version cycle are free upon request.
First class support for registered users within 24h except on holidays.

New gallery of styles makes it easier and faster to choose a visually appealing look for your application: