TRIAL DOWNLOADS

• Delphi 5 (3.47 MB)
• Delphi 6 (3.84 MB)
• Delphi 7 (4.36 MB)
• Delphi 2005 (3.79 MB)
• Delphi 2006 (10.34 MB)
• Delphi 2007 (10.34 MB)
• C++Builder 5 (4.55 MB)
• C++Builder 6 (4.55 MB)
• C++Builder 2006 (10.34 MB)
• C++Builder 2007 (10.34 MB)

Purchase a license

TMS Grid Pack

TAdvStringGrid, TAdvColumnGrid, TAdvSpreadGrid, TAdvGridExcelIO, TAdvGridRTFIO, TDBAdvGrid in one money and time saving pack

• Feature overview
• What's new
• Upgrade notes
• Sample applications
• TAdvSpreadGrid built-in function overview
• TAdvSpreadGrid custom function libraries
• ESBPCS edit links for TMS grids
• ESBPCS math library for AdvSpreadGrid
• Frequently asked questions
• Purchase a license

Feature overview

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 version 1.x remain free upon request.
First class support for registered users within 24h except on holidays.

What's new

v3.5.2.0

TAdvStringGrid v4.0.6.3

• New : OnWideEllipsClick event added
• New : OnOleDropURL event added, DragDropSettings.OleAcceptURLs added
• New : MouseActions.EditOnDblClickOnly property added
• Various smaller fixes & improvements

TDBAdvGrid v2.1.9.0

• New : OnFieldToStream event added
• New : PictureStretch property added in Columns
• New : added support for unicode lookup fields
• Improved : CheckBoxField can use virtual field text to set check value
• Various smaller fixes & improvements

v3.5.1.0

TAdvStringGrid v4.0.3.0

• New : Navigation.MoveScrollOnly property added to always only perform scrolling and no selection change when pressing Up/Down/Next/Prior/Home/End
• New : public property grid.XMLEncoding to specify code table for XLM export
• New : 3 articles on usage of TAdvStringGrid
• Improved : AdvGridFindDialog.Dialog & AdvGridReplaceDialog.Dialog exposed
• Various smaller fixes & improvements

TDBAdvGrid v2.1.7.1

• Includes all latest improvements in TAdvStringGrid
• New : InvalidatePicture / OnInvalidPicture added, shows invalid picture when loading from DB fails
• Fixed : issue with lookup editing for epRow EditPostMode

v3.5.0.0

TAdvStringGrid v4.0.0.0

• New : CSV import dialog
• New : support for parenthesis in filter spec
• New : translucent cell display during column or row moving
• New : translucent cell display during drag & drop
• New : support for Unicode hints
• New : IgnoreColumns property for AutoSizeRows, Sort, Find control
• New : 4 sample applications
• New : edDateTimeEdit editor type added
• New : GroupCustomCalc method & OnGroupCalc event added
• New : UnSelectRows, UnSelectCols method added
• New : SaveWithRTF public property added
• New : SearchFooter.SearchMatchStart property added
• New : GotoCell() method added
• New : OnColumnSizing, OnRowSizing events added
• New : MaxRows & DoTrim default parameter on LoadFromFixed added
• New : Hover/down complex gradients on fixed rows
• New : Fixed row dropdown menu
• New : Automatic Group count display with Group count format
• New : Grouping.AutoSelectGroup, to automatically select all rows in a group by clicking the group header
• New : OnCustomStrToDate event added
• New : global grid Modified property added
• New : OnColumnSizing, OnRowSizing events
• New : MaxComboLength property added
• New : with goTabs, AdvanceInsert = true & TabToNextAtEnd = false, row is inserted on tab at last cell
• New : OnSearchFooterClose event added
• New : MouseActions.DirectComboClose, MouseActions.DirectDateClose properties added
• New : SelectionMirrorColor/SelectionMirrorColorTo added for Vista style gradients on selected cells
• New : Internal atScientific type added for auto text alignment / formatting / sorting
• New : Navigation.CursorWalkAlwaysEdit property added
• New : Navigation.LeftRightRowSelect property added
• New : fnSelectedCells option added for Find function
• New : exposed hilight button in searchfooter via grid.SearchPanel.HiliteButton
• New : event OnSearchFooterAction added
• New : support for MaxLen attribute for HTML cell forms
• New : support for masked & password editors for HTML cell forms
• New : fnIncludeHiddenRows in Find parameters option added to search in rows hidden by nodes
• New : OnFooterCalc event added for custom footer calculations
• Improved : extended developers guide / updated help files
• Improved : float spinedit inplace editor behaviour with Page Up/Down keys
• Improved : OnGetEditorProp also called from normal inplace editor
• Improved : ColumnSize.SynchWithGrid behavior
• Improved : HTML control drawing with XP themes
• Improced : scope option to search in selected cells added in TAdvGridFindDialog, TAdvGridReplaceDialog
• Improved : perform auto scroll when dropped over first row during OLE drag & drop
• Improved : RowModified[] can be used also when visible modified row indication is disabled
• Improved : LoadFromFixed handles out of order column indexes
• Fixed : issue with tab edit for special combinations of fixed cells
• Fixed : issue with OnButtonClick for fixed cells and FixedAsButtons = true
• Fixed : issue with AutoNumAlign and thousand separators
• Fixed : issue with getting checkbox state for data checkboxes with hidden rows
• Fixed : issue with Title attribute case sensitivity in hyperlinks on HTML formatted text
• Fixed : issue with clicking on header checkbox & sorting
• Fixed : issue with AddAdvProgress and Min,Max different from 0,100
• Fixed : issue with SortOnVirtualCells & custom sorting

TDBAdvGrid v2.1.6.0

• Improved : automatically loads edit length for string/widestring fields from DB field

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

Notes on upgrading from TMS GridPack v1.X to v1.8

Make sure to read this information first when upgrading

Frequently asked questions about TAdvStringGrid

Selection of frequently asked questions and answers

Sample applications

Download pack of all sample projects for TAdvStringGrid for Delphi:

• example application 1: printing with TAdvStringGrid
• example application 2: setting colors with TAdvStringGrid
• example application 3: navigation in TAdvStringGrid
• example application 4: general demo of TAdvStringGrid
• example application 5: comboboxes, lookupediting & imagelist images in TAdvStringGrid.
• example application 6: sorting, including custom sorting in TAdvStringGrid
• example application 7: C++Builder demo showing setting of cell color, alignment and sorting styles.
• example application 8: rich text capabilities in TAdvStringGrid
• example application 9: using bitmaps for printing headers & footers
• example application 10: demonstration of some new v1.81 features
• example application 11: node expand / contract functions
• example application 12: radiobutton inplace editors
• example application 13: combining the versatility of TAdvStringGrid and TWebData to build a stock quote downloader.
• example application 14: demonstrating the TAdvStringGrid v1.83 grouping features
• example application 15: rich text drag & drop, printing and enhanced row and column moving
• example application 16: using the printsettings dialog & print preview dialog
• example application 17: load a MS Access table into TAdvStringGrid through ADO
• example application 18: using custom sort sequences
• example application 19: using the new edUnitEditBtn for split physical value editing in C++Builder
• example application 20: using the new HTML formatting capabilities
• example application 21: C++Builder version of the main demo
• example application 22: using the new filtering capabilities
• example application 23: an image catalogue program exploring the new support for TPicture in cells
• example application 24: using other TMS edit controls as inplace editors in TAdvStringGrid
• example application 25: printing multiple grids on a single page
• example application 26: using the ESBPCS edit controls as inplace editors in TAdvStringGrid
• example application 27: using the JPMOPen font and color combobox as inplace editors in TAdvStringGrid
• example application 28: using row, cell, cell ranges and column drag & drop
• example application 29: adding a field chooser to TAdvStringGrid
• example application 30: using an inplace rich editor in TAdvStringGrid
• example application 31: using TAdvStringGrid with TChartLink
• example application 32: using the TImagePicker as inplace editor for TAdvStringGrid
• example application 33: a scriptable grid: TGridScript unleashes the power of TatPascalScripter for TAdvStringGrid
• example application 34: using Addict Spell Checker with TAdvStringGrid
• example application 35: using a ColumnComboBox as inplace editor
• example application 36: using the new ControlLook property to select different inplace editor control looks
• example application 37: sorting on selected fixed rows of choice
• example application 38: grouping and merged group headers in TAdvStringGrid
• example application 39: merged cell access, merge cell printing and HTML export
• example application 40: sort independent cell access
• example application 41: virtual cells and disjunct row selection
• example application 42: merged cell printing
• example application 43: advanced border control
• example application 44: floating footer usage
• example application 45: virtual cell sorting
• example application 46: various new TAdvStringGrid v2.0 features
• example application 47: using the new capability to load data from MDB files
• example application 48: disjunct cell selection
• example application 49: automatically calculating fixed floating footer cells
• example application 50: (ab)using TAdvStringGrid: console app based sorting & fileformat conversion
• example application 51: cell property access, clipboard persistent cell properties and binary save
• example application 52: custom drawing and custom drawing printing support
• example application 53: inplace memo and popup memo editor
• example application 54: using mini HTML forms in TAdvStringGrid cells
• example application 55: almost codeless interface to use any TWinControl as inplace editor for TAdvStringGrid
• example application 56: using the new TAdvGridExcelIO for reading / writing Excel files directly with TAdvStringGrid
• example application 57: using cell controls to show a grid inside a grid
• example application 58: using TAdvGridWorkbook
• example application 59: using TAdvGridWorkbook with the new TAdvGridExcelIO to load/save multisheet XLS files
• example application 60: using data-dependent images
• example application 61: some combobox tricks with TAdvStringGrid
• example application 62: checkbox-based disjunct row selection
• example application 63: subgrouping with TAdvStringGrid
• example application 64: using TAdvGridRTFIO for native RTF export
• example application 65: using TAdvGridCSVPager for using large CSV files with paging
• example application 66: using OnPrintNewPage to start a new page for new data in a column
• example application 67: using the Unicode features of TAdvStringGrid
• example application 68: persisting column states
• example application 69: using Windows Vista style column header dropdown menus
• example application 70: custom group calculation
• example application 71: using the TAdvGridImportDialog
• example application 72: using the ICellGraphic interface for cells

Download pack of all sample projects for TAdvColumnGrid for Delphi:

• example application 1: New filter dropdown & popup menus
• example application 2: Creating inherited components from TAdvColumnGrid with extended column properties

Download pack of all sample projects for TDBAdvGrid for Delphi:

• ADOEditing : sample with TDBAdvGrid editing for ADO databases
• ADODataImage : sample showing data-dependent imagelist images
• ADOExport : sample with TDBAdvGrid editing for export from ADO databases
• ADOGrouping : sample with TDBAdvGrid showing grouping
• ADOLookup : sample with TDBAdvGrid for use of lookup fields with ADO databases
• ADOQuery : sample with TDBAdvGrid and ADO queries
• ADOSelColor : sample with TDBAdvGrid with value dependend cell coloring
• ADOSelection : sample with TDBAdvGrid with ADO showing checkbox based row selection and retrieval
• ADOXLSExport : sample with TDBAdvGrid and TAdvGridExcelIO to show native XLS export
• BDEAutoSize : sample with TDBAdvGrid showing auto row sizing
• BDEEditing : sample with TDBAdvGrid editing for BDE databases
• BDEExport : sample with TDBAdvGrid editing for export from BDE databases
• BDEFormatting : sample with TDBAdvGrid showing grid based numeric column formatting
• BDEHTML : sample with TDBAdvGrid editing for BDE database and columns with HTML templates
• BDEJPEG : sample with TDBAdvGrid with BDE database and JPEG display from BLOB fields
• BDEMastDetail : sample with TDBAdvGrid with BDE master/detail relationship
• BDEMisc : sample with TDBAdvGrid with BDE for miscellanous features
• BDERecordCount : sample with TDBAdvGrid showing use of OnGetRecordCount for improved performance
• BDERichEdit : sample with TDBAdvGrid with BDE rich text editing for memo field
• BDESearch : sample with TDBAdvGrid that shows search in DB grid
• BDESelection : sample with TDBAdvGrid with BDE showing checkbox based row selection and retrieval
• BDESetRange : sample with TDBAdvGrid showing use of table ranges
• BDESort : sample with TDBAdvGrid with BDE query sort
• FireBirdEditing : sample with TDBAdvGrid editing FireBird databases
• NexusEditing : sample with TDBAdvGrid editing Nexus databases
• NexusMisc : sample with TDBAdvGrid with Nexus for miscellanous features
• AdvDBLookupInGrid : sample showing how to use the TAdvDBLookupComboBox as inplace editor for TDBAdvGrid

Download demo of TDBAdvGrid with FIBPlus.

Buy online

This product is also available in TMS VCL Subscription, TMS Component Studio.