VCL
TMS Grid Pack
TAdvStringGrid, TAdvColumnGrid, TAdvSpreadGrid, TAdvGridExcelIO, TAdvGridRTFIO, TAdvGridPDFIO, TDBAdvGrid in one money and time saving pack
Also available for:
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*


FLEXIBLE PRINTING

- 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

- 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

- 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

- 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

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
Help
Trial Downloads
Site license
unlimited developers in the company
€ 510 yearly renewal *
€ 1275

Compatibility
- Delphi 7, 2007, 2010, 2009, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney, 11 Alexandria, C++Builder 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney, 11 Alexandria (Professional/Enterprise/Architect)
Licensing
- Licensing FAQ
- License for commercial use: Single developer license, Small team license, Site license
- Includes full source code
- Ask questions to our engineers related to purchased product via Support Center
- Free 1 year updates and new releases
- After 1 year, a discount renewal is offered for a 1 year extension. *
* offer valid for 30 days after end of license. Discount price is subject to change.
Tags
Bookmarks
×