Tips and Frequently Asked Questions

 Property FilterType


 RowSelectCount and SelectedRowCount


 Auto filtering in a grid with dynamically formatted cell values based on real cell values


 How to configure the grid so that a clipboard copy of a single cell value can be pasted at once to multiple cells


 Getting checked rows in a filtered grid


 Associating a unique ID with search list items for TAdvSearchEdit used in TAdvStringGrid


 How to draw text with end ellipsis when it is too long to fit in a cell


 How to control that at specific column positions, no column can be dropped.


 Programmatically show the filter dropdown for a grid column


 property grid.ControlLook.RadioRange: Boolean


 Image drag & drop


 Changing the font color of a part of the text in a grid cell using rich text


 Using the OnHoverButtonsShow event to configure different hover buttons for different columns


 Set a different XY offset for different cells in the grid


 Using NarrowDown but perform narrow down only for cells matching the search text from first character.


 Customizing the inplace editor for fixed cells in TAdvStringGrid


 Dealing with floating point number precision in TAdvStringGrid


 Remove the context menu at right mouse click


 Raw sort compare with virtual grid


 How to customize colors in the dropdown color cube


 How to have 2 different font colors for text within 1 cell


 How to programmatically set focus to the search box in the grid search footer


 How to initialize the TAdvGridHeaderList with hidden columns


 How to handle the event of changing the combobox from the TColumnComboEditLink component in a TAdvStringGrid


 How to add multiline comments


 How to export to PDF


 No caret is visible when editing a cell in the grid


 Inserting grid data into an existing sheet in an existing XLS file with TAdvGridExcelIO


 How to format Dates?


 How to disable scrolling with mousewheel and arrow keys


 How to change the margin between the cell border and the text


 How to set hints on images in the grid


 When "<" is in a cell text, the text in front of the "<" is always doubled when you click into the cell


 How to make certain columns editable


 How to turn off the gradient and override the fixed column color


 How to add a sheet to an existing Excel workbook using TAdvGridExcelIO.XLSExport


 Copy a row with cell values & properties from one grid to another grid


 How to prevent navigation to specific cells


 Using balloons


 I am having problems with the sorting order of special characters in other languages


 How to programmatically start inplace editing


 Printing tips


 How to filter on checkbox state


 How to set the dropdown width


  How to use TAdvColumnSetter


 How to change the TAdvGridPrintSettingsDialog to another language


 How to display special chars in a cell


 Using the HTMLSettings dialog at runtime


 Using the grid gallery picker at runtime


 Creating a grid at runtime in C++


 How to add a TAdvGlowButton in a grid


 Specifying a filter in C++


 Customizing the TAdvStringGrid Find Dialog


 Show inplace editor in a special color


 Importing data with TAdvGridExcelIO in a grid that already contains data


 Allowing multiline text & using the Enter key to start a new line


 How to use TAdvGridReplaceDialog


 Persisting grids with images to file


 How to change the size of the find next / previous / highlight buttons in the search bar


 Exporting numbers as text with TAdvGridExcelIO


 I want to override the popup menu of the default grid inplace editor


 Delphi can't find definition for TFlxFormat when using TAdvGridExcelIO


 Using TAdvStringGrid printer settings dialog combined with printer selection.


 Vertical bottom or center alignment in the grid


 Using TAdvStringGrid with Multilizer


 Copying a grid as image on the clipboard


 Saving TAdvStringGrid to a JPEG file


 Setting different max. edit lengths for the inplace editor


 Printing only selected rows in disjunct row select mode


 Setting an hourglass cursor during lengthy sort operations


 Forcing a visible cell editor when the form is displayed in the grid


 When using RowSelect, the first cell of the row is not highlighted as the other cells.


 Use a different inplace editor color than the cell color


 Still using the 3D style inplace combobox editor


 I use OnGetEditorType to specify a checkbox but it only displays when editing


 I use row selection, but the first column has a different color


 Why do rotated fonts do not print correct ?


 I want to use rotated font but the font does not show rotated


 Why do my printouts do not have colors or fonts set as displayed ?


 Copy and paste does not seem to work ?


 I want to select multiple rows with Ctrl - mouseclick and Shift - mouse click


 How can the copyright notice be removed from the grid ?


 I am not sure if the latest version of TAdvStringGrid is installed. How can I check this ?


 With the registered version of TAdvStringGrid, do we need to pay additional royalties for application distribution ?


 How can I set text in a cell ? How do I programmatically change a column width or row height ?


 How can I get the state of a checkbox added with grid.AddCheckBox ?


 I get an exception 'invalid column' during export to Excel


 I have added a button on the grid with AddButton but the OnButtonClick event is not triggered ?


 I try to set VAlignment to vtaCenter or vtaBottom but this is not working


 Can I load a gallery file programmatically at runtime ?


 I am having problems with grid.SortByColumn, it is slow or behaves incorrect


 Users of older operating systems have an error message on application startup related to a missing gdiplus.dll


 When exporting to Excel file with the method grid.SaveToXLS() I get the error : "Excel OLE server not found"


 When try to install TAdvStringGrid, I get an error that TAdvStringGrid is compiled with a different version of PictureContainer


 When I run my application I get an error "property does not exist"


 When I try to install the package, it asks for AdvGrid.pas


TMS VCL UI Pack

check_circle
TAdvStringGrid
is part of
TMS VCL UI Pack
info
Windows UI Essentials

Pricing

Single Developer License Small Team License Site License
 

TMS VCL UI Pack


€ 375

150 yearly renewal
license for 1 developer


Includes
check  Full source code
check  Access to the TMS Support Center
check  Free updates and new releases
check  All TMS VCL products
MOST POPULAR

TMS VCL Subscription


€ 895

450 yearly renewal
license for 1 developer


Includes
check  Full source code
check  Access to the TMS Support Center
check  Free updates and new releases
check  TMS VCL UI Pack
check  All TMS VCL products
more_horiz  Discover more
BEST VALUE

TMS ALL-ACCESS


€ 1,795

575 yearly renewal
license for 1 developer


Includes
check  Full source code
check  Access to the TMS Support Center
check  Free updates and new releases
check  TMS VCL UI Pack
check  All TMS VCL products
check  All TMS products
more_horiz  Discover more
All prices excl. VAT. Renewal price is subject to change and only valid up to 30 days after license has expired. After renewal period a discount price is offered to renew the license.

TMS ALL-ACCESS

key
Get unlimited access to all TMS products
local_offer
One money and time saving bundle

Free Trial

Start a free TMS VCL UI Pack evaluation today!
RAD Studio


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

TMS WEB Core

language
Create modern web apps in Delphi & VSC
build_circle
Use Object Pascal code to build JavaScript apps