v10.4.7.0 (November 19, 2020)

Version history

Feature overview

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
• Color picker,image picker, time picker
• Grid dropdown, detail dropdown list

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

3rd PARTY SUPPORT

All kinds of codeless extra features:

• ESBPCS: Can be used for a lot of additional special inplace editors
• Multilizer : can be used for internationalization

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

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!

TMS Grid Filters

Free interface between TMS Grids and TMS Flexcel to provide import/export capabilities to .XLS & .XLSX, .PDF formats.

FREE UPDATES & SUPPORT

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

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

Samples

Download pack of all sample projects for Delphi 7, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo

• 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

Help

• PDF manual (1.95 MB)
• Support
• Tips & FAQ
• Blog posts
• Videos

Bookmarks