Feature overview

Includes:

• TAdvStringGrid: Highly supercharged string grid
• TAdvGridDropDown: A multi column combobox on steroids
• 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
• TAdvGridRTFIO: Component to export grid to RTF files
• TAdvGridCSVPager: Component to use CSV files with paging
• 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
• TAdvGridFilterPanel & TAdvGridFilterDialog: Components for building filters visually for TMS grids*
• TAdvDBFilterPanel & TAdvDBFilterDialog: Components for building filters visually for datasets*
• TAdvGridPDFIO: Component for exporting the TAdvStringGrid content to a PDF file*
• TAdvGridColumnPicker: Popup control that can be used to select columns to display in the grid. Columns can be moved via drag & drop between the column picker list and the grid*

* New components from Delphi XE and newer available

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
• Save to PDF 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

AVAILABLE IN DROPDOWN VERSION

A multi column combobox on steroids:

• Full TAdvStringGrid functionality in dropdown grid
• Can be used as inplace editor in TAdvStringGrid
• Lookup or narrow down control
• Search lookup text via search footer
• Add graphics, checkboxes, controls, dynamic coloring etc... in dropdown cells

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
  
  

Extra information

• TAdvStringGrid filters, free interface between TMS Grids and TMS Flexcel to provide import/export capabilities to .XLS & .XLSX, .PDF formats.
• Grid built-in functions
• Grid custom functions

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

Sample applications

Download pack of all sample projects for Delphi:

• 
  example application 1 : printing with TAdvStringGrid
• 
  example application 2 : setting colors with TAdvStringGrid (see also sample application 51)
• 
  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 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 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 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
• 
  example application 73 : using a lookup combobox in TAdvStringGrid
• 
  example application 74 : embedding charts in TAdvStringGrid
• 
  example application 75 : automatically connect TAdvStringGrid to TAdvChartView with TAdvChartLink
• 
  example application 76 : balloon functionality in TAdvStringGrid
• 
  example application 77 : filter dropdown
• 
  example application 78 : incremental filtering & narrow down capabilities
• 
  example application 79 : adding scrollbars on grid cells
• 
  example application 80 : Using the Auto filter capability
• 
  example application 81 : The edDetailDropDown and edGridDropDown inplace editors
• 
  example application 82 : The edColorPickerDropDown and edImagePickerDropDown inplace editors
• 
  example application 83 : Using the component TAdvGridDropDown
• 
  example application 84 : Customizing the item class in TAdvGridDropDown
• 
  example application 85 : VCL Drag & drop between TAdvStringGrid and a TTreeview
• 
  example application 86 : Using the TAdvGridLookupBar
• 
  example application 87 : Using TMS Spell Check with TAdvStringGrid
• 
  example application 88 : Persist column state in an INI file and allow column selection via a column picker
• 
  example application 89 : Using TAdvSearchEdit as inplace editor
• 
  example application 90 : Image drag & drop in TAdvStringGrid
• 
  example application 91 : Using TAdvRichEditor as inplace editor in the grid
• example application 92 : Showing PDF Export

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
• AdvDBFilter : sample of TAdvDBFilter Component
• AdvGridFilter: sample of TAdvGridFilter Component
• CDSPDFExport : sample showing PDF Export
• CDS : sample with a TClientDataSet

Add-ons

• ESBPCS edit links for TMS grids
• ESBPCS math library for AdvSpreadGrid

Help

• PDF manual
• Support Center
• Tips & FAQ

What our customers say

Thank you Mr. Fierens for your time and assistance. Just want to say your VCL Pack is fabulous.

- Mark Mihevc

Thank you for this superb tool collection!

- Henning Swiboda

Thanks for the effort to create the VCL grid goodies ! These chunks of outcome-oriented teaching-material are very useful. It's unbelievable how powerful the grid is when one knows how to unveil it's countless options...

- Feichtenschlager Thomas

I don''t know how I could have created and managed so many projects without the AdvStringGrid! And although there is already so much functionality in it I''m using my own derived version with automatic column widths, enhanced export to Excel (including text colors, backround colors, comments, merged cells and more), the possibility to fill in static data at design time and more. This often allows me to build a new tool in hours instead of days! Support is also great! Thanks.

- Raß Jacqueline

Keep up the great work...Every new release of TMS Component Pack is like Xmas. Top quality components! :-)

- Aidan Thomson via email

❮ ❯

Bookmarks