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 VCL Grid Excel Bridge

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
• Support Center
• Tips & FAQ
• Blog posts

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