TAdvStringGrid

Contents - Events - Methods - Properties


Description
TAdvStringGrid for CLX v 1.0 beta

Copyright © 1996-2001 by TMS software

Web: http://www.tmssoftware.com

Email : info@tmssoftware.com

Single developer license for commercial use & source code : 60 USD

Also available :

- TMS Component pack : includes TAdvStringGrid

- TAdvSpreadGrid : spreadsheet add-on

- TAdvColumnGrid : TAdvStringGrid extended with column property management


TAdvStringGrid - Events

Contents - TAdvStringGrid - Properties - Methods

OnAnchorClick
Event handler is called when an anchor within a HTML formatted cells is clicked.

Delphi declaration
property OnAnchorClick: TAnchorClickEvent;
C++ declaration
__property TAnchorClickEvent OnAnchorClick

Description
The anchor parameter is the value of the HREF tag. Set AutoHandle to true if the grid can perform a ShellExecute on the anchor, or set to false and handle the anchorclick from the application.

OnAnchorEnter
Delphi declaration
property OnAnchorEnter: TAnchorEvent;
C++ declaration
__property TAnchorEvent OnAnchorEnter

Description
Event called when the mouse enters an anchor inside a cell with HTML formatted text.
OnAnchorExit
Delphi declaration
property OnAnchorExit: TAnchorEvent;
C++ declaration
__property TAnchorEvent OnAnchorExit

Description
Event called when the mouse leaves an anchor inside a cell with HTML formatted text.
OnAutoAddRow
Event triggered when a row is added when navigating to the end of the grid and Navigation.AdvanceInsert

is true.

Delphi declaration
property OnAutoAddRow: TAutoAddRowEvent;
C++ declaration
__property TAutoAddRowEvent OnAutoAddRow

Description
TNavigation.AdvanceInsert must be true to allow automatic row insertion after navigation through the last row.

OnAutoDeleteRow
Event handler called after user has deleted a row by pressing DEL button.

Delphi declaration
property OnAutoDeleteRow: TAutoDeleteRowEvent;
C++ declaration
__property TAutoDeleteRowEvent OnAutoDeleteRow

Description
The Arow parameter indicates the row that is deleted

OnAutoInsertCol
Event triggered when a column is added when navigating to the end of the grid and when Navigation.AdvanceInsert

is true.

Delphi declaration
property OnAutoInsertCol: TAutoInsertColEvent;
C++ declaration
__property TAutoInsertColEvent OnAutoInsertCol

Description
TNavigation.AdvanceInsert must be true to allow automatic column insertion after navigation through the last column.

OnAutoInsertRow
Event handler called after user has inserted a row by pressing INS button. Can be used to initialize a row to default data.

Delphi declaration
property OnAutoInsertRow: TAutoInsertRowEvent;
C++ declaration
__property TAutoInsertRowEvent OnAutoInsertRow

Description
The Arow parameter indicates the row insert position

OnButtonClick
Delphi declaration
property OnButtonClick: TButtonClickEvent;
C++ declaration
__property TButtonClickEvent OnButtonClick

Description
Event fired when a button in the cell is pressed. The button is added to the grid with the AddButton method.
OnCanAddRow
Delphi declaration
property OnCanAddRow: TCanAddRowEvent;
C++ declaration
__property TCanAddRowEvent OnCanAddRow

Description
Event triggered to query if a new row can be added when navigating from the current last row of the grid.
OnCanDeleteRow
Delphi declaration
property OnCanDeleteRow: TCanDeleteRowEvent;
C++ declaration
__property TCanDeleteRowEvent OnCanDeleteRow

Description
Event triggered to query if a row can be deleted with the Del key.
OnCanEditCell
Event handler to set a cell to read-only.

Delphi declaration
property OnCanEditCell: TCanEditCellEvent;
C++ declaration
__property TCanEditCellEvent OnCanEditCell

Description
Set canedit to false if the cell Arow,Acol must be readonly. The OnCanEditCell can be used for different types of inplace editors

OnCanInsertRow
Delphi declaration
property OnCanInsertRow: TCanInsertRowEvent;
C++ declaration
__property TCanInsertRowEvent OnCanInsertRow

Description
Event triggered to query if a row can be inserted with the Ins key.
OnCanSort
Event handler called when user clicked on a column header to sort a column.

Delphi declaration
property OnCanSort: TCanSortEvent;
C++ declaration
__property TCanSortEvent OnCanSort

Description
The event handler is called before starting the sort to query if the column can be sorted. If no handler is specified or handler simply returns, sorting is performed, otherwise, set dosort to false to disable sorting a specific column. The Acol parameter indicates which column will be sorted. This event is called before the sort starts. Only when dosort is true, the sort starts.

OnCellChanging
Event handler is called when the selected row is about to change.

Delphi declaration
property OnCellChanging: TCellChangingEvent;
C++ declaration
__property TCellChangingEvent OnCellChanging

Description
Called when the grid's cell changes from the OldRow,OldCol to NewRow,NewCol. With the Allow parameter, this change can be programmatically disabled or not.

OnCellsChanged
Delphi declaration
property OnCellsChanged: TCellsChangedEvent;
C++ declaration
__property TCellsChangedEvent OnCellsChanged

Description
Event triggered whenever the contents of a cell change. Cell contents can change due to editing, clipboard operations or loading new contents from file.
OnCellValidate
Event handler to add possibility to do input validation or autocorrection.

Delphi declaration
property OnCellValidate: TCellValidateEvent;
C++ declaration
__property TCellValidateEvent OnCellValidate

Description
The event handler is called after the user leaves a cell after editing. Set the Valid parameter to false is input is not accepted and cell should contain old value.

For autocorrection, the edited string, passed in the Value parameter can be modified while the Valid parameter is true. The corrected value will be entered in the grid instead of the typed value.

OnCheckBoxClick
Event handler called after the current checkbox inplace editor is clicked.

Delphi declaration
property OnCheckBoxClick: TCheckBoxClickEvent;
C++ declaration
__property TCheckBoxClickEvent OnCheckBoxClick

Description
aCol and aRow indicate the cell in which the checkbox is displayed and the state parameter indicates the new checkbox state.

OnCheckBoxMouseUp
Delphi declaration
property OnCheckBoxMouseUp: TCheckBoxClickEvent;
C++ declaration
__property TCheckBoxClickEvent OnCheckBoxMouseUp

Description
Event triggered on MouseUp event for a checkbox.
OnClickCell
Event handler called when left mouse is pressed on a cell which returns column and row of the selected cell.

Delphi declaration
property OnClickCell: TClickCellEvent;
C++ declaration
__property TClickCellEvent OnClickCell

Description
Arow and Acol indicated the clicked cell.

OnClickSort
Event handler called when user clicked on the fixed column header to sort on a specific column.

Delphi declaration
property OnClickSort: TClickSortEvent;
C++ declaration
__property TClickSortEvent OnClickSort

Description
The Acol parameter indicates which column is sorted. This event is called when the sort is completed. Can be used in conjunction with the OnCanSort event which is called before the sort starts.

OnClipboardCopy
Delphi declaration
property OnClipboardCopy: TClipboardEvent;
C++ declaration
__property TClipboardEvent OnClipboardCopy

Description
Event triggered when the user performs a clipboard copy with keyboard shortcuts.

Use allow to enable / disable the clipboard action.

OnClipboardCut
Delphi declaration
property OnClipboardCut: TClipboardEvent;
C++ declaration
__property TClipboardEvent OnClipboardCut

Description
Event triggered when the user performs a clipboard cut with keyboard shortcuts

Use allow to enable / disable the clipboard action.

OnClipboardPaste
Delphi declaration
property OnClipboardPaste: TClipboardEvent;
C++ declaration
__property TClipboardEvent OnClipboardPaste

Description
Event triggered when the user performs a clipboard paste with keyboard shortcuts.

Use allow to enable / disable the clipboard action.

OnColChanging
Event handler is called when the selected col is about to change.

Delphi declaration
property OnColChanging: TColChangingEvent;
C++ declaration
__property TColChangingEvent OnColChanging

Description
Called when the grid's column changes from the OldCol to NewCol. With the Allow parameter, this change can be programmatically disabled or not.

OnColumnMove
Delphi declaration
property OnColumnMove: TColumnSizeEvent;
C++ declaration
__property TColumnSizeEvent OnColumnMove

Description
Event triggered during move of a column. Column moving can be allowed or not through the Allow parameter.
OnColumnSize
Event handler used to control whether a column can be resized or not.

Delphi declaration
property OnColumnSize: TColumnSizeEvent;
C++ declaration
__property TColumnSizeEvent OnColumnSize

Description
This allows to control programmatically which columns can be resized and which not rather than a global control with goColumnSizing.

goColumnSizing must be set true after which OnColumnSize is called on start of every column resizing with mouse.Allow is default true. To disable sizing of column aCol, set Allow to false.

OnComboChange
Event handler called whenever the selection of the current combobox inplace editor is being changed.

Delphi declaration
property OnComboChange: TComboChangeEvent;
C++ declaration
__property TComboChangeEvent OnComboChange

Description
ACol and ARow indicate the cell in which the combobox is displayed. aItemIndex indicates the new combobox selection and aSelection returns the new selection as string.

OnComboObjectChange
Delphi declaration
property OnComboObjectChange: TComboObjectChangeEvent;
C++ declaration
__property TComboObjectChangeEvent OnComboObjectChange

Description
ACol and ARow indicate the cell in which the combobox is displayed. AItemIndex indicates the new combobox selection and ASelection returns the new selection as string. In addition to the OnComboChange event, the Object that was added to the combobox item is also returned in this event.
OnContractNode
Event handler called when user clicks a node

Delphi declaration
property OnContractNode: TNodeClickEvent;
C++ declaration
__property TNodeClickEvent OnContractNode

Description
A Row contains the displayed row index of the row where the node was clicked while A RowReal indicates the real row index, based on actual total rows

OnCustomCompare
Event handler called to compare two cells with custom function.

Delphi declaration
property OnCustomCompare: TCustomCompareEvent;
C++ declaration
__property TCustomCompareEvent OnCustomCompare

Description
Allows comparing 2 strings by the application and return the result through the res parameter.

The result should be :

>0 : str1 > str2

=0 : str1 = str2

<0 : str1 < str2

This event is only called when ssCustom is specified through the OnGetFormat event

OnDateSpinClick
Event handler called when the value of the current date spineditor inplace editor is being changed.

Delphi declaration
property OnDateSpinClick: TDateTimeSpinClickEvent;
C++ declaration
__property TDateTimeSpinClickEvent OnDateSpinClick

Description
aCol and aRow indicate the cell in which the spin editor is displayed. aValue holds the new value and the updown parameter indicates whether the up or down button was pressed.

OnDblClickCell
Event handler called when left mouse is doubleclicked on a cell which returns column and row of the selected cell.

Delphi declaration
property OnDblClickCell: TDblClickCellEvent;
C++ declaration
__property TDblClickCellEvent OnDblClickCell

Description
Arow and Acol indicated the double-clicked cell.

OnEllipsClick
Event handler called when user clicked the button associated with the EditBtn inplace editor or the simple button inplace editor

Delphi declaration
property OnEllipsClick: TEllipsClickEvent;
C++ declaration
__property TEllipsClickEvent OnEllipsClick

Description
Acol, Arow contains the cell index where the button was clicked. The S parameter contains the cell text and can be modified by the handler.

OnEndColumnSize
Event handler is called when user stops column sizing

Delphi declaration
property OnEndColumnSize: TEndColumnSizeEvent;
C++ declaration
__property TEndColumnSizeEvent OnEndColumnSize

Description
A Col indicates for which the column sizing has ended.

OnEndRowSize
Delphi declaration
property OnEndRowSize: TEndRowSizeEvent;
C++ declaration
__property TEndRowSizeEvent OnEndRowSize

Description
Event triggered after a row resize has stopped.
OnExpandNode
Event handler called when user clicks a node

Delphi declaration
property OnExpandNode: TNodeClickEvent;
C++ declaration
__property TNodeClickEvent OnExpandNode

Description
aRow contains the displayed row index of the row where the node was clicked while aRowReal indicates the real row index, based on actual total rows

OnFileProgress
Delphi declaration
property OnFileProgress: TGridProgressEvent;
C++ declaration
__property TGridProgressEvent OnFileProgress

Description
Event called during LoadFromFile, LoadFromCSV, SaveToFile, SaveToCSV methods to

indicate the progress of the operation. The progress parameter is a value between 0 and

100.

OnFilterProgress
Delphi declaration
property OnFilterProgress: TGridProgressEvent;
C++ declaration
__property TGridProgressEvent OnFilterProgress

Description
Event indicates the progress of a filtering operation. The progress value is the percentage completed.
OnFitToPage
Event handler to query for allowing fit to page with calculated scalefactor.

Delphi declaration
property OnFitToPage: TDoFitToPageEvent;
C++ declaration
__property TDoFitToPageEvent OnFitToPage

Description
Set allow to false to disable fit to page, or change the scalefactor programmatically..

OnFloatSpinClick
Event handler called when the value of the current float spineditor inplace editor is being changed.

Delphi declaration
property OnFloatSpinClick: TFloatSpinClickEvent;
C++ declaration
__property TFloatSpinClickEvent OnFloatSpinClick

Description
aCol and aRow indicate the cell in which the spin editor is displayed. aValue holds the new value and the updown parameter indicates whether the up or down button was pressed.

OnGetAlignment
Event handler called to set alignment of a cell. If no handler is specified or your handler simply returns, left alignment is used.

Delphi declaration
property OnGetAlignment: TGridAlignEvent;
C++ declaration
__property TGridAlignEvent OnGetAlignment

Description
TAlignment can be taLeftJustify, taRightJustify or taCenter.

OnGetCellBorder
Event handler is called to set border style for each cell.

Delphi declaration
property OnGetCellBorder: TGridBorderEvent;
C++ declaration
__property TGridBorderEvent OnGetCellBorder

Description
Can be used to specify what cell borders must be displayed in the grid.

TCellBorder = (cbTop,cbLeft,cbRight,cbBottom);

TCellBorders = set of TCellBorder

OnGetCellColor
Event handler called to set the color of a cell. If no handler is specified or your handler simply returns, default color settings are used.

Delphi declaration
property OnGetCellColor: TGridColorEvent;
C++ declaration
__property TGridColorEvent OnGetCellColor

Description
ARow and ACol indicate cell for which color must be set. ABrush specifies the cell background brush. AFont can be used to modify font for a given cell.

Use the OnGetCellPrintColor to specify colors for printing or use the same event handler for both OnGetCellColor and OnGetCellPrintColor.

OnGetCellPrintBorder
Event handler is called to set print border style for each cell.

Delphi declaration
property OnGetCellPrintBorder: TGridBorderEvent;
C++ declaration
__property TGridBorderEvent OnGetCellPrintBorder

Description
Can be used to specify what cell borders must be displayed in the grid.

TCellBorder = (cbTop,cbLeft,cbRight,cbBottom);

TCellBorders = set of TCellBorder

Can be assigned to the OnGetCellBorder event handler to match on display output with printed output

OnGetCellPrintColor
Event handler called to set the color of a cell when printing. If no handler is specified or your handler simply return, default color settings are used.

Delphi declaration
property OnGetCellPrintColor: TGridColorEvent;
C++ declaration
__property TGridColorEvent OnGetCellPrintColor

Description
ARow and ACol indicate cell for which color must be set. ABrush specifies the cell background brush. AFont can be used to modify font for a given cell.

identical as %REF% OnGetCellColor,TAdvStringGrid,OnGetCellColor %REF% , but for printing. Can be same event handler as OnGetCellColor or a separate event handler if needed.

OnGetCheckFalse
Delphi declaration
property OnGetCheckFalse: TGetCheckEvent;
C++ declaration
__property TGetCheckEvent OnGetCheckFalse

Description
Retrieves the cell value corresponding with a unchecked checkbox for the given cell
OnGetCheckTrue
Delphi declaration
property OnGetCheckTrue: TGetCheckEvent;
C++ declaration
__property TGetCheckEvent OnGetCheckTrue

Description
Retrieves the cell value corresponding with a checked checkbox for the given cell
OnGetEditorProp
Delphi declaration
property OnGetEditorProp: TGetEditorPropEvent;
C++ declaration
__property TGetEditorPropEvent OnGetEditorProp

Description
Event called to set extra properties of custom inplace editors. The event is called after all details of the place where the control should appear are known and the window handle of the inplace editor has been created to allow further customization of the inplace edit control before editing starts.
OnGetEditorType
Event handler to query the type of inplace editor for the cell.

Delphi declaration
property OnGetEditorType: TGetEditorTypeEvent;
C++ declaration
__property TGetEditorTypeEvent OnGetEditorType

Description
For cell ACol, ARow set AEditor either one of the following editor types :

Value Meaning

edNormal Edit cell using edit control

edSpinEdit Edit cell using spin edit control

edFloatSpinEdit Edit cell using float spin edit control

edTimeSpinEdit Edit cell using time spin edit control

edDateSpinEdit Edit cell using date spin edit control

edComboEdit Edit cell using default ComboBox control

edComboList Edit cell using ComboList control

edEditBtn Edit cell using edit box with button control

edUnitEditBtn Edit cell using edit box + unit field control

edDateEdit Edit cell using date validated edit control

edButton Edit cell using button control

edNumeric Edit cell using numeric validated edit control

edPositiveNumeric Edit cell using positive numeric validated edit control

edFloat Edit cell using floating point validated edit control

edCapital Edit cell using edit control UPPER CASE only

edMixedCase Edit cell using text validated edit control

edLowerCase Edit cell in all lower case characters

edUpperCase Edit cell in all upper case characters

edTimeEdit Edit cell as time

edDateEditUpDown Edit date with updown button

edPassword Edit as password

edRichEdit Rich text inplace editoredCustom A custom inplace is used. This is set through the EditLink property.

Notice that

1) Checkboxes are set/removed with the AddCheckbox, RemoveCheckbox procedures.

2) Combobox contents are set with AddComboboxString procedure or can be accessed through the ComboBox public property

3) The properties of the spin edit control can be set through the public SpinEdit property

4) The properties of the EditBtn control can be set through the public BtnEdit property.

5) The properties of the normal inplace edit control can be set through the NormalEdit public property

OnGetFormat
Event handler called to set datatype of cells in a column. This is called during sorts to determine method for sorting. Sorting can be alphabetic, numeric, using dates or using a custom sorting format. If custom sorting is selected, an event is called to compare cells during sorts.

Delphi declaration
property OnGetFormat: TGridFormatEvent;
C++ declaration
__property TGridFormatEvent OnGetFormat

Description
TSortStyle can be ssAutomatic, ssAlphabetic, ssNumeric, ssDate, ssAlphaCase, ssAlphaNoCase, ssShortDateEU, ssShortDateUS, ssCustom, ssFinancial, ssAnsiAlpha, ssAnsiAlphaNoCase, ssRaw, ssHTML,ssImages

ssAutomatic : tries to determine best way of sorting

ssAlphabatic : simple alphabetic sort

ssNumeric : simple numeric sort, numbers can be integer of floating point

ssDate : relies of the standard date to string conversion for sort based on date. Depends on international settings of Windows

ssAlphaCase : case sensitive

ssAlphaNoCase : non case sensitive sort

ssShortDateEU : sort based on short european date notation dd/mm/yy

ssShortDateUS : sort based on short us date notation mm/dd/yy

ssCustom : calls the %REF% OnCustomCompare,TAdvStringGrid,OnCustomCompare %REF% event

ssRaw : calls the %REF% OnRawCompare,TAdvStringGrid,OnRawCompare %REF% event

ssFinancial : sort data with thousand and decimal separators

ssHTML : compares cell text with all HTML tags removed

ssAnsiAlpha : uses the ansi string compare functions with case sensitivity

ssAnsiAlphaNoCase : uses the ansi string compare functions without case sensitivity

Use aSuffix or aPrefix when this text must not be considered for the sort,

ie when sorting $100, $10, ... and ignore the $ prefix.

OnGridHint
Event handler can be used to set different hints for each cell. Set the hintstring parameter for a given column and row to specify a special hint for a given cell. Default StringGrid hint is used when no handler is defined or handler simply return.

Delphi declaration
property OnGridHint: TGridHintEvent;
C++ declaration
__property TGridHintEvent OnGridHint

Description
Based on the Arow, Acol parameters that indicate the cell where the hint will appear, the application can set a different hint for each cell.

OnIsFixedCell
Event handler is called to determine if a cell wherever in the grid is fixed style.

Delphi declaration
property OnIsFixedCell: TIsFixedCellEvent;
C++ declaration
__property TIsFixedCellEvent OnIsFixedCell

Description
Set the IsFixed parameter to true for all fixed cells.

OnIsPasswordCell
Event handler is called to determine if a cell wherever in the grid is password style.

Delphi declaration
property OnIsPasswordCell: TIsPasswordCellEvent;
C++ declaration
__property TIsPasswordCellEvent OnIsPasswordCell

Description
Set the IsPassword parameter to true for all password cells. To allow editing as password, use the edPassword style in the OnGetEditorType event.

OnOleDrag
Delphi declaration
property OnOleDrag: TOleDragDropEvent;
C++ declaration
__property TOleDragDropEvent OnOleDrag

Description
Event triggered before OLE drag drop starts. It indicates the column and row where the drag drop starts can start of the drag & drop operation can be disabled through the Allow parameter.
OnOleDragOver
Delphi declaration
property OnOleDragOver: TOleDragOverEvent;
C++ declaration
__property TOleDragOverEvent OnOleDragOver

Description
Event triggered when an OLE drag & drop operation is taking place over the control. The cell where the mouse is, is returned and the drag & drop operation can be allowed or disabled through the Allow parameter.
OnOleDragStart
Delphi declaration
property OnOleDragStart: TOleDragStartEvent;
C++ declaration
__property TOleDragStartEvent OnOleDragStart

Description
Event indicating the start of an OLE drag & drop operation from the control.
OnOleDragStop
Delphi declaration
property OnOleDragStop: TOleDragStopEvent;
C++ declaration
__property TOleDragStopEvent OnOleDragStop

Description
Event indicating the succesfull termination of an OLE drag & drop operation from the control. It indicates whether is was an OLE move or copy operation.
OnOleDrop
Delphi declaration
property OnOleDrop: TOleDragDropEvent;
C++ declaration
__property TOleDragDropEvent OnOleDrop

Description
Event triggered when an OLE drop occurs on the control. It indicates the cell where the OLE drop operation took place.
OnOleDropCol
Delphi declaration
property OnOleDropCol: TOleDropColEvent;
C++ declaration
__property TOleDropColEvent OnOleDropCol

Description
Event triggered when an OLE column drop occurs on the control. It indicates the cell where the OLE drop operation took place. An OLE column drop, only returns an index of the column dropped.
OnOleDropped
Delphi declaration
property OnOleDropped: TOleDroppedEvent;
C++ declaration
__property TOleDroppedEvent OnOleDropped

Description
Event triggered after text or a file is dropped on the grid through OLE drag&drop.
OnPrintNewPage
Event handler called after printing each row to query to start a new page.

Delphi declaration
property OnPrintNewPage: TGridPrintNewPageEvent;
C++ declaration
__property TGridPrintNewPageEvent OnPrintNewPage

Description
The parameter is the current row being printed, and NewPage is a boolean that can be set true to start printing on a new page.

OnPrintPage
Event handler called when a page is printed (either on hardcopy or during printpreview).

Delphi declaration
property OnPrintPage: TGridPrintPageEvent;
C++ declaration
__property TGridPrintPageEvent OnPrintPage

Description
This event handler creates the possibility to add custom drawing to the printing process. The Canvas is passed as a parameter and can be used to draw. Notice that changing canvas settings such as pen, font, brush affect printing other data. If a setting like a font must be changed for the custom printing process, the original settings must be restored. This can be done in following way for a font for example :

S ave F ont := TF ont. C reate;

S ave F ont. A ssign( F ont);

//do custom drawing here and change font

F ont. A ssign( S ave F ont);

S ave F ont. F ree;

Printing is done in a canvas set to MM_LOMETRIC. This means that all units are in 1/10mm and page coordinates go from 0,0 to xsize,-ysize. There are no restrictions to the position where custom drawing is done.

OnPrintPageDone
Delphi declaration
property OnPrintPageDone: TGridPrintPageDoneEvent;
C++ declaration
__property TGridPrintPageDoneEvent OnPrintPageDone

Description
Event triggered after each page is printed.
OnPrintSetColumnWidth
Event handler called to overrule the automatically calculated column widths.

Delphi declaration
property OnPrintSetColumnWidth: TGridPrintColumnWidthEvent;
C++ declaration
__property TGridPrintColumnWidthEvent OnPrintSetColumnWidth

Description
Use this event handler if you need to exactly define column widths for printing. All dimensions are in 1/10mm.

OnPrintSetRowHeight
Event handler called to overrule the automatically calculated row heights.

Delphi declaration
property OnPrintSetRowHeight: TGridPrintRowHeightEvent;
C++ declaration
__property TGridPrintRowHeightEvent OnPrintSetRowHeight

Description
Use this event handler if you need to exactly define row heights for printing. All dimensions are in 1/10mm.

OnPrintStart
Event handler called after calculation of number of pages and before printing is actually started.

Delphi declaration
property OnPrintStart: TGridPrintStartEvent;
C++ declaration
__property TGridPrintStartEvent OnPrintStart

Description
This event allows to specify range of pages to be printed. NrOfPages indicates the required number of pages. FromPage,ToPage are initialized to 1, NrOfPages respectively. Changing the parameters FromPage, ToPage changes range of printed pages. The PrintDialog can be used to set these variables.

OnRadioClick
Event handler called when clicking a radiobutton in a radiobutton group inplace editor.

Delphi declaration
property OnRadioClick: TRadioClickEvent;
C++ declaration
__property TRadioClickEvent OnRadioClick

Description
aCol and aRow indicate the cell in which the radiobutton group control is displayed. The aIdx parameter is a zero based index of the selected radiobutton

OnRadioMouseUp
Delphi declaration
property OnRadioMouseUp: TRadioClickEvent;
C++ declaration
__property TRadioClickEvent OnRadioMouseUp

Description
Event triggered for a MouseUp on a radio button.
OnRawCompare
Event handler called to compare two cells with custom function.

Delphi declaration
property OnRawCompare: TRawCompareEvent;
C++ declaration
__property TRawCompareEvent OnRawCompare

Description
event handler called to compare two cells with custom function. Passes just the indexes of the cell to allow compares based on other data than just the cell text as with the OnCustomCompare event. The result of the OnRawCompare event should be set in the res parameter and according to :

>0 : cell 1 > cell 2

=0 : cell 1 = cell 2

<0 : cell 1 < cell 2

This event is only called when ssRaw is specified through the %REF% OnGetFormat,TAdvStringGrid,OnGetFormat %REF%

OnRichEditSelectionChange
Delphi declaration
property OnRichEditSelectionChange: TNotifyEvent;
C++ declaration
__property Classes::TNotifyEvent OnRichEditSelectionChange

Description
Event triggered when the selection of the inplace rich text editor changes. This can be used to synchronize toolbutton properties to reflect the selection attributes of the new selected text.
OnRightClickCell
Event handler called when right mouse is pressed on a cell which returns column and row of the selected cell.

Delphi declaration
property OnRightClickCell: TClickCellEvent;
C++ declaration
__property TClickCellEvent OnRightClickCell

Description
Arow and Acol indicated the clicked cell.

OnRowChanging
Event handler is called when the selected row is about to change

Delphi declaration
property OnRowChanging: TRowChangingEvent;
C++ declaration
__property TRowChangingEvent OnRowChanging

Description
Called when the grid's row changes from the OldRow to NewRow. With the Allow parameter, this change can be programmatically disabled or not.

OnRowMove
Delphi declaration
property OnRowMove: TRowSizeEvent;
C++ declaration
__property TRowSizeEvent OnRowMove

Description
Event triggered during a row moving operation.
OnRowSize
Delphi declaration
property OnRowSize: TRowSizeEvent;
C++ declaration
__property TRowSizeEvent OnRowSize

Description
Event triggered during a row resize operation.
OnScrollHint
Event handler is called when user is scroll-tracking to modify the scrollhint text.

Delphi declaration
property OnScrollHint: TScrollHintEvent;
C++ declaration
__property TScrollHintEvent OnScrollHint

Description
Default text is Row = AR ow. Change the H int S tr parameter to your custom text if required.

OnSpinClick
Event handler called when the value of the current spineditor inplace editor is being changed.

Delphi declaration
property OnSpinClick: TSpinClickEvent;
C++ declaration
__property TSpinClickEvent OnSpinClick

Description
A Col and A Row indicate the cell in which the spin editor is displayed. aValue holds the new value and the updown parameter indicates whether the up or down button was pressed.

OnTimeSpinClick
Event handler called when the value of the current time spineditor inplace editor is being changed.

Delphi declaration
property OnTimeSpinClick: TDateTimeSpinClickEvent;
C++ declaration
__property TDateTimeSpinClickEvent OnTimeSpinClick

Description
A Col and A Row indicate the cell in which the spin editor is displayed. aValue holds the new value and the updown parameter indicates whether the up or down button was pressed.


TAdvStringGrid - Methods

Contents - TAdvStringGrid - Properties - Events

AddBitmap
Delphi declaration
procedure AddBitmap(ACol, ARow: Integer; ABmp: TBitmap; transparent: Boolean; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddBitmap(int ACol, int ARow, Graphics::TBitmap *ABmp, bool transparent, TCellHAlign hal, TCellVAlign val)

Description
Adds a bitmap to cell Acol,Arow with alignment defined by hal and val. The transparent parameter controls display the bitmap transparently. Transparency color is determined by the pixel in the upper left corner of the bitmap. Make sure EnableGraphics is set true.
AddButton
Delphi declaration
procedure AddButton(ACol, ARow, bw, bh: Integer; caption: string; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddButton(int ACol, int ARow, int bw, int bh, AnsiString caption, TCellHAlign hal, TCellVAlign val)

Description
Adds a button to cell Acol,Arow with alignment defined by hal and val. Make sure EnableGraphics is set true.

When the button is clicked, the OnButtonClick event is triggered.

AddCheckBox
Delphi declaration
procedure AddCheckBox(Acol,Arow:integer;state,data:boolean);
C++ declaration
void AddCheckBox(int Acol,int Arow, bool State, bool Data);

Description
Adds a checkbox to cell Acol,Arow. The checkbox can be set checked or unchecked with the State parameter. The state of the checkbox can be dependent of the value in the cell when Data is true. In this case, the cell content takes the value of the CheckTrue property when the checkbox is checked and the value of the CheckFalse property when it is unchecked.M ake sure EnableGraphics is set true.
AddColumn
Delphi declaration
procedure AddColumn;
C++ declaration
void __fastcall AddColumn(void)

Description
Adds a column to the grid.
AddComboString
Delphi declaration
procedure AddComboString(const s: string);
C++ declaration
void __fastcall AddComboString(const AnsiString s)

Description
Add string s to the the inplace combobox editor.
AddComboStringObject
Delphi declaration
procedure AddComboStringObject(const s: string; AObject: TObject);
C++ declaration
void __fastcall AddComboStringObject(const AnsiString s, System::TObject *AObject)

Description
Adds a string and object to the inplace combobox editor. The object can be retrieved in the OnComboObjectChange event.
AddComment
Delphi declaration
procedure AddComment(ACol, ARow: Integer; comment: string);
C++ declaration
void __fastcall AddComment(int ACol, int ARow, AnsiString comment)

Description
Adds a comment indicator to cell Acol, Arow with text comment that will popup when mouse is over the cell. Make sure EnableGraphics is set true.
AddDataImage
Delphi declaration
procedure AddDataImage(ACol, ARow, Aidx: Integer; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddDataImage(int ACol, int ARow, int Aidx, TCellHAlign hal, TCellVAlign val)

Description
Adds a cell data dependent image to a cell. The alignment is equal to the alignment in AddImageIdx. Aidx specifies the index from where to start in the imagelist. Ie. if cell[acol,arow] contains 5 and Aidx=2, image 7 from the imagelist will be displayed.

Make sure EnableGraphics is set true.

AddFilePicture
Delphi declaration
procedure AddFilePicture(ACol, ARow: Integer; afilepicture: tfilepicture; transparent: Boolean; stretchmode: TStretchMode; padding: Integer; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddFilePicture(int ACol, int ARow, Advobj::TFilePicture *afilepicture, bool transparent, TStretchMode stretchmode, int padding, TCellHAlign hal, TCellVAlign val)

Description
Adds a picture to cell Acol,Arow with alignment defined by hal and val. The transparent parameter controls display the picture transparently. Transparency color is determined by the pixel in the upper left corner of the picture.
AddIcon
Delphi declaration
procedure AddIcon(ACol, ARow: Integer; aicon: ticon; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddIcon(int ACol, int ARow, Graphics::TIcon *aicon, TCellHAlign hal, TCellVAlign val)

Description
Adds an icon to cell Acol,Arow with alignment defined by hal and val. Make sure EnableGraphics is set true.
AddImageIdx
Delphi declaration
procedure AddImageIdx(ACol, ARow, Aidx: Integer; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddImageIdx(int ACol, int ARow, int Aidx, TCellHAlign hal, TCellVAlign val)

Description
Adds an image idx from the imagelist assigned to GridImages to cell Acol,Arow with alignment defined by hal and val.

hal = (haLeft,haCenter,haRight,haBeforeText,haAfterText)

val = (vaTop,vaCenter,vaBottom,vaAboveText,vaUnderText)

Make sure EnableGraphics is set true.

AddMarker
Delphi declaration
procedure AddMarker(ACol, ARow, ErrPos, ErrLen: Integer);
C++ declaration
void __fastcall AddMarker(int ACol, int ARow, int ErrPos, int ErrLen)

Description
Adds an error marker line (red line under text) in the cell ACol,ARow from character position ErrPos with length of ErrLen characters. EnableGraphics must be true to have effect.
AddMultiImage
Delphi declaration
procedure AddMultiImage(ACol, ARow, Dir: Integer; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddMultiImage(int ACol, int ARow, int Dir, TCellHAlign hal, TCellVAlign val)

Description
Adds a multi image cell to the grid. The indexes of the images in the image list are specified through the CellImages property. This property is an integer list, holding the indexes of the multiple images in the GridImages image list. The direction parameter is 0 for horizontal positioned multiple images and 1 for vertical positioned images. Make sure EnableGraphics is set true.
AddNode
Delphi declaration
procedure AddNode(ARow, Span: Integer);
C++ declaration
void __fastcall AddNode(int ARow, int Span)

Description
Adds a node at visible row aRow to the grid, with span indicating the number of rows it contracts or expands

Make sure EnableGraphics is set true.

AddPicture
Delphi declaration
procedure AddPicture(ACol, ARow: Integer; apicture: TPicture; transparent: Boolean; stretchmode: TStretchMode; padding: Integer; hal: TCellHalign; val: TCellValign);
C++ declaration
void __fastcall AddPicture(int ACol, int ARow, Graphics::TPicture *apicture, bool transparent, TStretchMode stretchmode, int padding, TCellHAlign hal, TCellVAlign val)

Description
Adds a picture to cell Acol,Arow with alignment defined by hal and val. The transparent parameter controls display the picture transparently. Transparency color is determined by the pixel in the upper left corner of the picture.

With TStretchMode = (noStretch,Stretch,StretchWithAspectRatio,Shrink,ShrinkWithAspectRatio);

AddProgress
Delphi declaration
procedure AddProgress(ACol, ARow: Integer; FGColor, BKColor: TColor);
C++ declaration
void __fastcall AddProgress(int ACol, int ARow, Graphics::TColor FGColor, Graphics::TColor BKColor)

Description
Adds a progress bar graphic to a cell Acol, Arow with foreground and background colors specified in the FGColor and BGColor parameters. The progressbar position reflects the cell value which should be between 0 and 100. Make sure EnableGraphics is set true.
AddProgressEx
Delphi declaration
procedure AddProgressEx(ACol, ARow: Integer; FGColor, FGTextColor, BKColor, BKTextColor: TColor);
C++ declaration
void __fastcall AddProgressEx(int ACol, int ARow, Graphics::TColor FGColor, Graphics::TColor FGTextColor, Graphics::TColor BKColor, Graphics::TColor BKTextColor)

Description
Same as AddProgress but adds 2 additional color settings for the foreground and background text color of the progress bar.
AddRadio
Delphi declaration
procedure AddRadio(ACol, ARow, DirRadio, IdxRadio: Integer; sl: TStrings);
C++ declaration
void __fastcall AddRadio(int ACol, int ARow, int DirRadio, int IdxRadio, Classes::TStrings *sl)

Description
Adds a radiobutton to grid cell aCol,Arow. If DirRadio is true, the radiobuttons are in the vertical direction, otherwise it is in the horizontal direction. IdxRadio determines the selected radiobutton group item, while the sl stringlist holds the radiobutton labels.

Make sure EnableGraphics is set true.

AddRotated
Delphi declaration
procedure AddRotated(ACol, ARow: Integer; aAngle: smallint; s: string);
C++ declaration
void __fastcall AddRotated(int ACol, int ARow, short aAngle, AnsiString s)

Description
Adds rotated text to a cell with aAngle specified in degrees (0°-360°). The rotated text uses additionally the alignment specified through the VAlignment property and horizontal cell alignment specified through the OnGetAlignment event handler and font, color settings through the OnGetCellColor event handler.

Make sure a Truetype font is used as well as EnableGraphics is set true.

AddRow
Delphi declaration
procedure AddRow;
C++ declaration
void __fastcall AddRow(void)

Description
Adds a row to the grid
AppendToCSV
Delphi declaration
procedure AppendToCSV(FileName: String);
C++ declaration
void __fastcall AppendToCSV(AnsiString fileName)

void __fastcall AppendToCSV(AnsiString FileName)

Description
Same as %REF%SaveToCSV,TAdvStringGrid,SaveToCSV%REF% except that this function adds grid data to the end of the file.

AppendToHTML
Delphi declaration
procedure AppendToHTML(FileName: String);
C++ declaration
void __fastcall AppendToHTML(AnsiString FileName)

Description
Same as SaveToHTML except that this function adds grid data to the end of the file.
AutoNumberCol
Delphi declaration
procedure AutoNumberCol(const ACol: Integer);
C++ declaration
void __fastcall AutoNumberCol(const int ACol)

Description
Simple autonumbering of cells in a column starting from 1 in first non-fixed row.
AutoNumberRow
Delphi declaration
procedure AutoNumberRow(const ARow: Integer);
C++ declaration
void __fastcall AutoNumberRow(const int ARow)

Description
Simple autonumbering of cells in a row starting from 1 in first non-fixed column.
AutoSizeCells
Delphi declaration
procedure AutoSizeCells(const DoFixedCells: Boolean; const PaddingX, PaddingY: Integer);
C++ declaration
void __fastcall AutoSizeCells(const bool DoFixedCells, const int PaddingX, const int PaddingY)

Description
Modifies the width and height of all cells (except fixed rows if specified) so that all text properly fits in the cells. Optionally adds extra space at right and bottom as specified in the PaddingX and PaddingY parameters.
AutoSizeCol
Delphi declaration
procedure AutoSizeCol(const ACol: Integer);
C++ declaration
void __fastcall AutoSizeCol(const int ACol)

Description
Modifies the width of column ACol so that all text properly fits in the column.
AutoSizeColumns
Delphi declaration
procedure AutoSizeColumns(const DoFixedCols: Boolean; const Padding: Integer);
C++ declaration
void __fastcall AutoSizeColumns(const bool DoFixedCols, const int Padding)

Description
Modifies the width of all columns (except fixed columns if specified) so that all text properly fits in the columnn and optionally adds extra space specified in the padding parameter.
AutoSizeRow
Delphi declaration
procedure AutoSizeRow(const ARow: Integer);
C++ declaration
void __fastcall AutoSizeRow(const int ARow)

Description
Modifies the height of row ARow so that all text properly fits in the row. Only required when using the grid in multiline mode.
AutoSizeRows
Delphi declaration
procedure AutoSizeRows(const DoFixedRows: Boolean; const Padding: Integer);
C++ declaration
void __fastcall AutoSizeRows(const bool DoFixedRows, const int Padding)

Description
Modifies the height of all rows (except fixed rows if specified) so that all text properly fits in the rows. Only required when using the grid in multiline mode. Optionally adds extra space specified in the padding parameter.
BeginUpdate
Delphi declaration
procedure BeginUpdate;
C++ declaration
void __fastcall BeginUpdate(void)

Description
Temporarily stops painting the grid. Can be used during lengthy update operations.
CellToRich
Delphi declaration
procedure CellToRich(Col, Row: Integer; Richeditor: TRichEdit);
C++ declaration
void __fastcall CellToRich(int Col, int Row, Comctrls::TRichEdit *Richeditor)

Description
Transfers text from cell Acol, Arow to the richedit control. RichEdit can be the internal rich edit control of TAdvStringGrid which can be accessed through the RichEdit property.
CheckCell
Delphi declaration
function CheckCell(Col, Row: Integer): Boolean;
C++ declaration
bool __fastcall CheckCell(int Col, int Row)

Description
Use the attached CellChecker component to check the value and possibly autocorrect the value of a single cell.
CheckCells
Delphi declaration
function CheckCells(FromCol, FromRow, ToCol, ToRow: Integer): Boolean;
C++ declaration
bool __fastcall CheckCells(int FromCol, int FromRow, int ToCol, int ToRow)

Description
Use the attached CellChecker component to check the value and possibly autocorrect the value of a range of cells.
CheckCol
Delphi declaration
function CheckCol(DoFixed: Boolean; Col: Integer): Boolean;
C++ declaration
bool __fastcall CheckCol(bool DoFixed, int Col)

Description
Use the attached CellChecker component to check the value and possibly autocorrect th e value of a all cells in a column
CheckGrid
Delphi declaration
function CheckGrid(DoFixed: Boolean): Boolean;
C++ declaration
bool __fastcall CheckGrid(bool DoFixed)

Description
Use the attached CellChecker component to check the value and possibly autocorrect th e value of a all cells in the grid.
CheckRow
Delphi declaration
function CheckRow(DoFixed: Boolean; Row: Integer): Boolean;
C++ declaration
bool __fastcall CheckRow(bool DoFixed, int Row)

Description
Use the attached CellChecker component to check the value and possibly autocorrect th e value of a all cells in a row
Clear
Delphi declaration
procedure Clear;
C++ declaration
void __fastcall Clear(void)

Description
Clears contents of all cells. No cells are removed, only content is cleared.
ClearCols
Delphi declaration
procedure ClearCols(ColIndex, CCount: Integer);
C++ declaration
void __fastcall ClearCols(int ColIndex, int CCount)

Description
Clears contents of all cells starting from row ColIndex to ColIndex+Ccount-1.
ClearColumnHeaders
Delphi declaration
procedure ClearColumnHeaders;
C++ declaration
void __fastcall ClearColumnHeaders(void)

Description
Clears the content of the column headers.
ClearComboString
Delphi declaration
procedure ClearComboString;
C++ declaration
void __fastcall ClearComboString(void)

Description
Removes all strings from the inplace combobox editor
ClearNormalCells
Delphi declaration
procedure ClearNormalCells;
C++ declaration
void __fastcall ClearNormalCells(void)

Description
Clears contents of all cells except fixed cells.
ClearRect
Delphi declaration
procedure ClearRect(ACol1, ARow1, ACol2, ARow2: Integer);
C++ declaration
virtual void __fastcall ClearRect(int ACol1, int ARow1, int ACol2, int ARow2)

Description
Clears contents of all cells in rectangle indicated by [aCol1,aRow1] and [aCol2,aRow2].
ClearRowHeaders
Delphi declaration
procedure ClearRowHeaders;
C++ declaration
void __fastcall ClearRowHeaders(void)

Description
Clears the content of the row headers
ClearRows
Delphi declaration
procedure ClearRows(RowIndex, RCount: Integer);
C++ declaration
void __fastcall ClearRows(int RowIndex, int RCount)

Description
Clears contents of all cells starting from row RowIndex to RowIndex+Rcount-1.
ClearRowSelect
Delphi declaration
procedure ClearRowSelect;
C++ declaration
void __fastcall ClearRowSelect(void)

Description
If DisjunctRowSelect is enabled, this method clears selection of all rows.
ClearSelection
Delphi declaration
procedure ClearSelection;
C++ declaration
void __fastcall ClearSelection(void)

Description
Clear the currently selected cells.
ColumnAvg
Delphi declaration
function ColumnAvg(ACol, fromRow, toRow: Integer): double;
C++ declaration
double __fastcall ColumnAvg(int ACol, int fromRow, int toRow)

Description
Returns the average of cell values in column ACol from row FromRow to row ToRow.
ColumnMax
Delphi declaration
function ColumnMax(ACol, fromRow, toRow: Integer): double;
C++ declaration
double __fastcall ColumnMax(int ACol, int fromRow, int toRow)

Description
Returns the maximum of cell values in column ACol from row FromRow to row ToRow.
ColumnMin
Delphi declaration
function ColumnMin(ACol, fromRow, toRow: Integer): double;
C++ declaration
double __fastcall ColumnMin(int ACol, int fromRow, int toRow)

Description
Returns the minimum of cell values in column ACol from row FromRow to row ToRow.
ColumnSum
Delphi declaration
function ColumnSum(ACol, fromRow, toRow: Integer): double;
C++ declaration
double __fastcall ColumnSum(int ACol, int fromRow, int toRow)

Description
Returns the average of cell values in column ACol from row FromRow to row ToRow.
ContractAll
Delphi declaration
procedure ContractAll;
C++ declaration
void __fastcall ContractAll(void)

Description
Contracts all nodes in the grid
ContractNode
Delphi declaration
procedure ContractNode(ARow: Integer);
C++ declaration
void __fastcall ContractNode(int ARow)

Description
Contracts the node at real row index aCol
CopySelectionToClipboard
Delphi declaration
procedure CopySelectionToClipboard;
C++ declaration
void __fastcall CopySelectionToClipboard(void)

Description
Copies contents of selected cells to the clipboard.
CopyToClipBoard
Delphi declaration
procedure CopyToClipBoard;
C++ declaration
void __fastcall CopyToClipBoard(void)

Description
Copies contents of stringgrid to the clipboard.
CreateBitmap
Delphi declaration
function CreateBitmap(ACol, ARow: Integer; transparent: Boolean; hal: TCellHalign; val: TCellValign): TBitmap;
C++ declaration
Graphics::TBitmap *__fastcall CreateBitmap(int ACol, int ARow, bool transparent, TCellHAlign hal, TCellVAlign val)

Description
Creates and adds a bitmap to cell Acol,Arow with alignment defined by hal and val. The transparent parameter controls display the bitmap transparently. Transparency color is determined by the pixel in the upper left corner of the bitmap. Make sure EnableGraphics is set true. The bitmap is automatically cleaned up when RemoveBitmap is called or the grid is destroyed.
CreateFilePicture
Delphi declaration
function CreateFilePicture(ACol, ARow: Integer; transparent: Boolean; stretchmode: TStretchMode; padding: Integer; hal: TCellHalign; val: TCellValign): TFilePicture;
C++ declaration
Advobj::TFilePicture *__fastcall CreateFilePicture(int ACol, int ARow, bool transparent, TStretchMode stretchmode, int padding, TCellHAlign hal, TCellVAlign val)

Description
Creates and adds a picture to cell Acol,Arow with alignment defined by hal and val. The transparent parameter controls display the picture transparently. The picture is automatically cleaned up when RemovePicture is called or the grid is destroyed. Use TFilePicture.Filename to assign the filename.
CreateIcon
Delphi declaration
function CreateIcon(ACol, ARow: Integer; hal: TCellHalign; val: TCellValign): ticon;
C++ declaration
Graphics::TIcon *__fastcall CreateIcon(int ACol, int ARow, TCellHAlign hal, TCellVAlign val)

Description
Adds an icon to cell Acol,Arow with alignment defined by hal and val. Make sure EnableGraphics is set true. The icon is automatically cleaned up when RemoveIcon is called or the grid is destroyed.
CreatePicture
Delphi declaration
function CreatePicture(ACol, ARow: Integer; transparent: Boolean; stretchmode: TStretchMode; padding: Integer; hal: TCellHalign; val: TCellValign): TPicture;
C++ declaration
Graphics::TPicture *__fastcall CreatePicture(int ACol, int ARow, bool transparent, TStretchMode stretchmode, int padding, TCellHAlign hal, TCellVAlign val)

Description
Creates and adds a picture to cell Acol,Arow with alignment defined by hal and val. The transparent parameter controls display the picture transparently. The picture is automatically cleaned up when RemovePicture is called or the grid is destroyed. Use TPicture.LoadFromFile(filename:string) to load the image.
CutSelectionToClipboard
Delphi declaration
procedure CutSelectionToClipboard;
C++ declaration
void __fastcall CutSelectionToClipboard(void)

Description
Copies contents of the selected cells in the stringgrid to the clipboard and clears the selected cells.
CutToClipboard
Delphi declaration
procedure CutToClipboard;
C++ declaration
void __fastcall CutToClipboard(void)

Description
Copies contents of stringgrid to the clipboard and clears all cells.
DisplColIndex
Delphi declaration
function DisplColIndex(ACol: Integer): Integer;
C++ declaration
int __fastcall DisplColIndex(int ACol)

Description
Inverse function of RealColIndex. Returns the display column index for a given column index.
DisplRowIndex
Delphi declaration
function DisplRowIndex(ARow: Integer): Integer;
C++ declaration
int __fastcall DisplRowIndex(int ARow)

Description
Inverse function of RealRowIndex. Returns the display column index for a given row index.
EndUpdate
Delphi declaration
procedure EndUpdate;
C++ declaration
void __fastcall EndUpdate(void)

Description
Reenables grid painting and forces a display update.
ExpandAll
Delphi declaration
procedure ExpandAll;
C++ declaration
void __fastcall ExpandAll(void)

Description
Expands all nodes in the grid
ExpandNode
Delphi declaration
procedure ExpandNode(ARow: Integer);
C++ declaration
void __fastcall ExpandNode(int ARow)

Description
Expands the node at real row index aRow
Find
Delphi declaration
function Find(StartCell: TPoint; s: string; FindParams: TFindParams): TPoint;
C++ declaration
Windows::TPoint __fastcall Find(const Windows::TPoint & StartCell, AnsiString s, TFindParams FindParams)

Description
Starts a find of string s from the StartCell coordinates with the FindParams settings.
FindFirst
Delphi declaration
function FindFirst(s: string; findparams: tfindparams): tpoint;
C++ declaration
Windows::TPoint __fastcall FindFirst(AnsiString s, TFindParams FindParams)

Description
Searches the stringgrid for text s, with options for search in findparams.

This set is defined as :

TFindParameters = (fnMatchCase,fnMatchStart,fnMatchFull,fnMatchRegular,fnDirectionLeftRight,

fnFindInCurrentRow,fnFindInCurrentCol,fnIncludedFixed,fnAutoGoto)

TFindParams = set of TFindParameters;

FindFirst returns col/row of first cell matching the search specification. If no cell is found, the returned cell is (-1,-1)

For easy of use, there is a FindBusy property indicating whether the find has reached the end of the grid.

FindNext
Delphi declaration
function FindNext: TPoint;
C++ declaration
Windows::TPoint __fastcall FindNext()

Description
Continues the search in the grid for text initiated by FindFirst.

For easy of use, there is a FindBusy property indicating whether the find has reached the end of the grid.

GetBitmap
Delphi declaration
function GetBitmap(ACol, ARow: Integer): TBitmap;
C++ declaration
Graphics::TBitmap *__fastcall GetBitmap(int ACol, int ARow)

Description
Returns the bitmap object in cell Acol,Arow
GetCheckBoxState
Delphi declaration
function GetCheckboxState(Acol,Arow:integer; var state:boolean ):boolean;
C++ declaration
bool GetCheckboxState(int Acol,int Arow, bool &state);

Description
Gets the status of the checkbox in cell Acol,Arow and returns in result in state. If cell Acol,Arow does not contain a checkbox, the function returns false.
GetComboCount
Delphi declaration
function GetComboCount: Integer;
C++ declaration
int __fastcall GetComboCount(void)

Description
Retrieves the number of items currently in the combobox.
GetFilePicture
Delphi declaration
function GetFilePicture(ACol, ARow: Integer): tFilePicture;
C++ declaration
Advobj::TFilePicture *__fastcall GetFilePicture(int ACol, int ARow)

Description
Returns the picture object in cell Acol,Arow
GetImageIdx
Delphi declaration
function GetImageIdx(ACol, ARow: Integer; var idx: Integer): Boolean;
C++ declaration
bool __fastcall GetImageIdx(int ACol, int ARow, int & idx)

Description
Returns true if the cell aCol, Arow contains an image from the imagelist. In the idx parameter, the actual index of the image in the imagelist is returned.
GetMarker
Delphi declaration
procedure GetMarker(ACol, ARow: Integer; var ErrPos, ErrLen: Integer);
C++ declaration
void __fastcall GetMarker(int ACol, int ARow, int & ErrPos, int & ErrLen)

Description
Gets the character position and length of an error marker in the cell if it is added. When no Error Marker is added in the cell, the ErrPos returns -1.
GetNodeState
Delphi declaration
function GetNodeState(ARow: Integer): Boolean;
C++ declaration
bool __fastcall GetNodeState(int ARow)

Description
Returns true if the node at visible row index aRow is in the expanded state
GetPicture
Delphi declaration
function GetPicture(ACol, ARow: Integer): TPicture;
C++ declaration
Graphics::TPicture *__fastcall GetPicture(int ACol, int ARow)

Description
Returns the picture object in cell Acol,Arow
GetRadioIdx
Delphi declaration
function GetRadioIdx(ACol, ARow: Integer; var IdxRadio: Integer): Boolean;
C++ declaration
bool __fastcall GetRadioIdx(int ACol, int ARow, int & IdxRadio)

Description
Gets the index of the selected radiobutton in the radiobuttongroup at cell aCol, aRow
GetVersionNr
Delphi declaration
function GetVersionNr: Integer;
C++ declaration
virtual int __fastcall GetVersionNr(void)

Description
Returns the version number of the component as integer. Low 16bit contain the minor version nr, high 16bit contain the major version nr.
GetVersionString
Delphi declaration
function GetVersionString: string;
C++ declaration
virtual AnsiString __fastcall GetVersionString()

Description
Returns the version number of the component as string.
Group
Delphi declaration
procedure Group(Colindex: Integer);
C++ declaration
void __fastcall Group(int Colindex)

Description
Groups the data in the grid by column ColIndex. It creates expand / contract nodes in column 0. Is equivalent to the use of the GroupColumn property.
GroupAvg
Delphi declaration
procedure GroupAvg(Colindex: Integer);
C++ declaration
void __fastcall GroupAvg(int Colindex)

Description
Calculates the average of cell values in column ACol in all groups and displays value in group row.
GroupCount
Delphi declaration
procedure GroupCount(ColIndex: Integer);
C++ declaration
void __fastcall GroupCount(int ColIndex)

Description
Calculates the number of row in all groups and displays value in group to p row.
GroupMax
Delphi declaration
procedure GroupMax(Colindex: Integer);
C++ declaration
void __fastcall GroupMax(int Colindex)

Description
Calculates the maximum of cell values in column ACol in all groups and displays value in group top row.
GroupMin
Delphi declaration
procedure GroupMin(Colindex: Integer);
C++ declaration
void __fastcall GroupMin(int Colindex)

Description
Calculates the minimum of cell values in column ACol in all groups and displays value in group top row.
GroupSum
Delphi declaration
procedure GroupSum(Colindex: Integer);
C++ declaration
void __fastcall GroupSum(int Colindex)

Description
Calculates the sum of cell values in column ACol in all groups and displays value in group top row.
HasButton
Delphi declaration
function HasButton(ACol, ARow: Integer): Boolean;
C++ declaration
bool __fastcall HasButton(int ACol, int ARow)

Description
Returns true when the cell contains a button.
HasCheckBox
Delphi declaration
function HasCheckbox(Acol,Arow:integer):boolean;
C++ declaration
bool HasCheckbox(int Acol,int Arow);

Description
Returns true when the cell contains a checkbox.
HasDataCheckBox
Delphi declaration
function HasDataCheckBox(ACol, ARow: Integer): Boolean;
C++ declaration
bool __fastcall HasDataCheckBox(int ACol, int ARow)

Description
Returns true when the cell contains a data checkbox.
HideColumn
Delphi declaration
procedure HideColumn(Colindex: Integer);
C++ declaration
void __fastcall HideColumn(int Colindex)

Description
Hide display of column=colindex.
HideColumns
Delphi declaration
procedure HideColumns(fromCol, toCol: Integer);
C++ declaration
void __fastcall HideColumns(int fromCol, int toCol)

Description
Hides all columns from FromCol to ToCol.
HideInplaceEdit
Delphi declaration
procedure HideInplaceEdit;
C++ declaration
void __fastcall HideInplaceEdit(void)

Description
Hides the inplace editor.
HideRow
Delphi declaration
procedure HideRow(Rowindex: Integer);
C++ declaration
void __fastcall HideRow(int Rowindex)

Description
Hide display of row=rowindex.
HideRows
Delphi declaration
procedure HideRows(FromRow, ToRow: Integer);
C++ declaration
void __fastcall HideRows(int fromRow, int toRow)

void __fastcall HideRows(int FromRow, int ToRow)

Description
Hides all rows from FromRow to ToRow.

HideSelectedRows
Delphi declaration
procedure HideSelectedRows;
C++ declaration
void __fastcall HideSelectedRows(void)

Description
Hides the selected rows (in disjunct row select mode) from the grid.
HideSelection
Delphi declaration
procedure HideSelection;
C++ declaration
void __fastcall HideSelection(void)

Description
Hides the selected cell or cells.
HilightInCell
Delphi declaration
procedure HilightInCell(DoCase: Boolean; Col, Row: Integer; HiText: string);
C++ declaration
void __fastcall HilightInCell(bool DoCase, int Col, int Row, AnsiString HiText)

Description
HiLight the word HiText with or without case sensitivity depending on the value of DoCase in the cell Col,Row.
HilightInCol
Delphi declaration
procedure HilightInCol(DoFixed, DoCase: Boolean; Col: Integer; HiText: string);
C++ declaration
void __fastcall HilightInCol(bool DoFixed, bool DoCase, int Col, AnsiString HiText)

Description
HiLight the word HiText with or without case sensitivity depending on the value of DoCase in all cells of the column
HilightInGrid
Delphi declaration
procedure HilightInGrid(DoFixed, DoCase: Boolean; HiText: string);
C++ declaration
void __fastcall HilightInGrid(bool DoFixed, bool DoCase, AnsiString HiText)

Description
HiLight the word HiText with or without case sensitivity depending on the value of DoCase in all cells of the grid. When DoFixed is false, hilighting is not applied in the fixed cells.
HilightInRow
Delphi declaration
procedure HilightInRow(DoFixed, DoCase: Boolean; Row: Integer; HiText: string);
C++ declaration
void __fastcall HilightInRow(bool DoFixed, bool DoCase, int Row, AnsiString HiText)

Description
HiLight the word HiText with or without case sensitivity depending on the value of DoCase in all cells of the row. When DoFixed is false, hilighting is not applied in the fixed cells.
HilightText
Delphi declaration
function HilightText(DoCase: Boolean; S, Text: string): string;
C++ declaration
AnsiString __fastcall HilightText(bool DoCase, AnsiString S, AnsiString Text)

Description
HiLight the word T ext in a string S.
InsertCols
Delphi declaration
procedure InsertCols(ColIndex, CCount: Integer);
C++ declaration
virtual void __fastcall InsertCols(int ColIndex, int CCount)

Description
Inserts Ccount empty columns after column position ColIndex.
InsertFromCSV
Delphi declaration
procedure InsertFromCSV(FileName: String);
C++ declaration
void __fastcall InsertFromCSV(AnsiString FileName)

Description
Same %REF%LoadFromCSV,TAdvStringGrid,LoadFromCSV%REF% except that data is appended after the last row of the grid.
InsertRows
Delphi declaration
procedure InsertRows(RowIndex, RCount: Integer);
C++ declaration
virtual void __fastcall InsertRows(int RowIndex, int RCount)

Description
Inserts Rcount empty rows at row position RowIndex.
IsComment
Delphi declaration
function IsComment(ACol, ARow: Integer; var comment: string): Boolean;
C++ declaration
bool __fastcall IsComment(int ACol, int ARow, AnsiString & comment)

Description
Returns true when the cell contains a comment.
IsHiddenColumn
Delphi declaration
function IsHiddenColumn(Colindex: Integer): Boolean;
C++ declaration
bool __fastcall IsHiddenColumn(int Colindex)

Description
Returns true if column=colindex is hidden.
IsHiddenRow
Delphi declaration
function IsHiddenRow(Rowindex: Integer): Boolean;
C++ declaration
bool __fastcall IsHiddenRow(int Rowindex)

Description
Returns true if row is hidden.
IsNode
Delphi declaration
function IsNode(ARow: Integer): Boolean;
C++ declaration
bool __fastcall IsNode(int ARow)

Description
Returns true if visible row index aRow contains a node
IsRadio
Delphi declaration
function IsRadio(ACol, ARow: Integer): Boolean;
C++ declaration
bool __fastcall IsRadio(int ACol, int ARow)

Description
Returns true of cell aCol, Arow contains a radiobutton
IsRotated
Delphi declaration
function IsRotated(ACol, ARow: Integer; var aAngle: Integer): Boolean;
C++ declaration
bool __fastcall IsRotated(int ACol, int ARow, int & aAngle)

Description
If the cell contains rotation information, returns true and the angle of rotation in degrees (0°-360°)
IsSelected
Delphi declaration
function IsSelected(ACol, ARow: Integer): Boolean;
C++ declaration
bool __fastcall IsSelected(int ACol, int ARow)

Description
Returns true if the specified cell is within the selection range.
LoadColSizes
Delphi declaration
procedure LoadColSizes;
C++ declaration
void __fastcall LoadColSizes(void)

Description
Loads the column sizes from the registry or inifile at location pointed to by the ColumnSize property.
LoadFromCSV
Delphi declaration
procedure LoadFromCSV(FileName: String);
C++ declaration
void __fastcall LoadFromCSV(AnsiString FileName)

Description
Loads contents of stringgrid from a comma delimited text file. If the %REF%Delimiter,TAdvStringGrid,Delimiter%REF% is not specified, LoadFromCSV will try to make an intelligent guess for the delimiter based on the first 2 lines of the CSV file. If Delimiter is specified, this delimiter is used regardless of what is in the file.
LoadFromFile
Delphi declaration
procedure LoadFromFile(FileName: String);
C++ declaration
void __fastcall LoadFromFile(AnsiString FileName)

Description
Loads contents as well as size of the stringgrid from a ASCII file previously created by calling the SaveToFile routine.
LoadFromFixed
Delphi declaration
procedure LoadFromFixed(FileName: string; positions: TIntList);
C++ declaration
void __fastcall LoadFromFixed(AnsiString FileName, Advobj::TIntList *positions)

Description
Loads the contents of stringgrid from a formatted text file. The positions parameter is a list of the fixed offsets of the columns. Create a TIntList instance, and add the positions with the Add(position:integer) method.
LoadFromStream
Delphi declaration
procedure LoadFromStream(Stream: TStream);
C++ declaration
void __fastcall LoadFromStream(Classes::TStream *stream)

void __fastcall LoadFromStream(Classes::TStream *Stream)

Description
Loads contents as well as size of the stringgrid from a generic stream. For example, a filestream can be used to save contents to file or a memorystream to copy data from one stringgrid to another stringgrid.

LoadFromXLS
Delphi declaration
procedure LoadFromXLS(Filename: string);
C++ declaration
void __fastcall LoadFromXLS(AnsiString Filename)

Description
Uses OLE automation to transfer cell contents from XLS file with name Filename, loaded into Excel.
LoadFromXLSSheet
Delphi declaration
procedure LoadFromXLSSheet(Filename, SheetName: string);
C++ declaration
void __fastcall LoadFromXLSSheet(AnsiString Filename, AnsiString SheetName)

Description
Uses OLE automation to transfer cell contents from XLS file with name Filename and sheet with name SheetName in the workbook.
LoadPrintSettings
Delphi declaration
procedure LoadPrintSettings(Key, Section: string);
C++ declaration
void __fastcall LoadPrintSettings(AnsiString Key, AnsiString section)

void __fastcall LoadPrintSettings(AnsiString Key, AnsiString Section)

Description
Loads the printsettings from the registry at key,section

MarkInCell
Delphi declaration
procedure MarkInCell(DoCase: Boolean; Col, Row: Integer; HiText: string);
C++ declaration
void __fastcall MarkInCell(bool DoCase, int Col, int Row, AnsiString HiText)

Description
Add an error marker for the word HiText with or without case sensitivity depending on the value of DoCase in the cell Col,Row.
MarkInCol
Delphi declaration
procedure MarkInCol(DoFixed, DoCase: Boolean; Col: Integer; HiText: string);
C++ declaration
void __fastcall MarkInCol(bool DoFixed, bool DoCase, int Col, AnsiString HiText)

Description
Add an error marker for the word HiText with or without case sensitivity depending on the value of DoCase in all cell s of the column. When DoFixed is false, marking is not applied to the fixed cells.
MarkInGrid
Delphi declaration
procedure MarkInGrid(DoFixed, DoCase: Boolean; HiText: string);
C++ declaration
void __fastcall MarkInGrid(bool DoFixed, bool DoCase, AnsiString HiText)

Description
Add an error marker for the word HiText with or without case sensitivity depending on the value of DoCase in all cell s of the grid. When DoFixed is false, marking is not applied to the fixed cells.
MarkInRow
Delphi declaration
procedure MarkInRow(DoFixed, DoCase: Boolean; Row: Integer; HiText: string);
C++ declaration
void __fastcall MarkInRow(bool DoFixed, bool DoCase, int Row, AnsiString HiText)

Description
Add an error marker for the word HiText with or without case sensitivity depending on the value of DoCase in all cell s of the row. When DoFixed is false, marking is not applied to the fixed cells.
MarkText
Delphi declaration
function MarkText(DoCase: Boolean; S, Text: string): string;
C++ declaration
AnsiString __fastcall MarkText(bool DoCase, AnsiString S, AnsiString Text)

Description
Add an error marker for the word T ext in string S and returns this as a string.
MergeCols
Delphi declaration
procedure MergeCols(ColIndex1, ColIndex2: Integer);
C++ declaration
void __fastcall MergeCols(int ColIndex1, int ColIndex2)

Description
Appends strings from column 2 to strings of column 1 and removes column 2.
MoveColumn
Delphi declaration
procedure MoveColumn(FromIndex, ToIndex: Integer);
C++ declaration
HIDESBASE void __fastcall MoveColumn(int FromIndex, int ToIndex)

Description
Move contents of all cells of column FromIndex to column ToIndex.
MoveRow
Delphi declaration
procedure MoveRow(FromIndex, ToIndex: Integer);
C++ declaration
HIDESBASE void __fastcall MoveRow(int FromIndex, int ToIndex)

Description
Move contents of all cells of row FromIndex to row ToIndex.
NumHiddenColumns
Delphi declaration
function NumHiddenColumns: Integer;
C++ declaration
int __fastcall NumHiddenColumns(void)

Description
Returns the number of hidden columns.
NumHiddenRows
Delphi declaration
function NumHiddenRows: Integer;
C++ declaration
int __fastcall NumHiddenRows(void)

Description
Returns the number of hidden rows.
PasteFromClipboard
Description :

Delphi declaration
procedure PasteFromClipboard;
C++ declaration
void __fastcall PasteFromClipboard(void)

Description
Pastes data from clipboard into cells.

PasteSelectionFromClipboard
Delphi declaration
procedure PasteSelectionFromClipboard;
C++ declaration
void __fastcall PasteSelectionFromClipboard(void)

Description
Pastes data from clipboard into cells at current selected cell at position row,col.
Print
Delphi declaration
procedure Print;
C++ declaration
void __fastcall Print(void)

Description
Prints the entire stringgrid to the selected printer, using the printer setting properties of TAdvStringGrid.
PrintDraw
Delphi declaration
procedure PrintDraw(Canvas: TCanvas; DrawRect: TRect);
C++ declaration
void __fastcall PrintDraw(Graphics::TCanvas *Canvas, const Windows::TRect & DrawRect)

Description
Draws the grid on the canvas, within the rectangle specified.
PrintDrawRect
Delphi declaration
procedure PrintDrawRect(Canvas: TCanvas; DrawRect: TRect; Gridrect: TGridRect);
C++ declaration
void __fastcall PrintDrawRect(Graphics::TCanvas *Canvas, const Windows::TRect & DrawRect, const Grids::TGridRect & Gridrect)

Description
Draws the cells of the grid with the gridrect rectangle on the canvas, within the rectangle specified.
PrintPreview
Delphi declaration
procedure PrintPreview(Canvas: TCanvas; Displayrect: TRect);
C++ declaration
void __fastcall PrintPreview(Graphics::TCanvas *Canvas, const Windows::TRect & displayrect)

void __fastcall PrintPreview(Graphics::TCanvas *Canvas, const Windows::TRect & Displayrect)

Description
Shows a preview of the printout with exactly the same printer setting properties in the selected canvas in the rectangle defined by displayrect.

PrintPreviewRect
Delphi declaration
procedure PrintPreviewRect(Canvas: TCanvas; displayrect: TRect; Gridrect: TGridRect);
C++ declaration
void __fastcall PrintPreviewRect(Graphics::TCanvas *Canvas, const Windows::TRect & displayrect, const Grids::TGridRect & Gridrect)

Description
Shows a preview of the printout with exactly the same printer setting properties in the selected canvas for the cells in gridrect.
PrintRect
Delphi declaration
procedure PrintRect(Gridrect: TGridRect);
C++ declaration
void __fastcall PrintRect(const Grids::TGridRect & Gridrect)

Description
Prints only the cells in gridrect to the selected printer, using the printer setting properties of TAdvStringGrid.
QSort
Delphi declaration
procedure QSort;
C++ declaration
void __fastcall QSort(void)

Description
Performs a complete quicksort of the stringgrid, starting from the column indicated by the SortColumn property.
QSortGroup
Delphi declaration
procedure QSortGroup;
C++ declaration
void __fastcall QSortGroup(void)

Description
Performs a complete quicksort of the stringgrid, starting from the column indicated by the SortColumn property while taking grouping into account.
QSortIndexed
Delphi declaration
procedure QSortIndexed;
C++ declaration
void __fastcall QSortIndexed(void)

Description
Performs a quicksort of the stringgrid based on the column indexes in the SortIndexes property
QuickSort
Delphi declaration
procedure QuickSort(Col, Left, Right: Integer);
C++ declaration
void __fastcall QuickSort(int Col, int left, int right)

void __fastcall QuickSort(int Col, int Left, int Right)

Description
Perform a quicksort of all cells from row left to row right for a given column col.

QuickSortIndexed
Delphi declaration
procedure QuickSortIndexed(Left, Right: Integer);
C++ declaration
void __fastcall QuickSortIndexed(int left, int right)

void __fastcall QuickSortIndexed(int Left, int Right)

Description
Perform a n indexed quicksort of all cells from row left to row right for a given column col.

RandomFill
Delphi declaration
procedure RandomFill(DoFixed: Boolean; Rnd: Integer);
C++ declaration
void __fastcall RandomFill(bool DoFixed, int Rnd)

Description
Fills the grid with random numbers. When DoFixed is true, the fixed cells are filled with random numbers as well.
RealColIndex
Delphi declaration
function RealColIndex(ACol: Integer): Integer;
C++ declaration
int __fastcall RealColIndex(int ACol)

Description
Returns the real column index of the visible column index. If the number of hidden columns is 0, the real column index is always equal to the display column index. With hidden columns, the real column index of all columns after a hidden column will be incremented with the number of hidden columns before that column.
RealRowIndex
Delphi declaration
function RealRowIndex(ARow: Integer): Integer;
C++ declaration
int __fastcall RealRowIndex(int ARow)

Description
Returns the real row index of the visible row index. If the number of hidden rows is 0, the real row index is always equal to the display row index. With hidden rows, the real row index of all rows after a hidden row will be incremented with the number of hidden rows before that row.
RemoveBitmap
Delphi declaration
procedure RemoveBitmap(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveBitmap(int ACol, int ARow)

Description
Removes the bitmap in cell Acol,Arow
RemoveButton
Delphi declaration
procedure RemoveButton(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveButton(int ACol, int ARow)

Description
Removes the button in cell Acol,Arow
RemoveCheckBox
Delphi declaration
procedure RemoveCheckbox(Acol,Arow:integer);
C++ declaration
void RemoveCheckbox(int Acol,int Arow);

Description
Removes the checkbox in cell Acol,Arow
RemoveCols
Delphi declaration
procedure RemoveCols(ColIndex, CCount: Integer);
C++ declaration
virtual void __fastcall RemoveCols(int ColIndex, int CCount)

Description
Removes all columns from the stringgrid, starting from column ColIndex to column ColIndex+CCount-1.
RemoveComboString
Delphi declaration
function RemoveComboString(const s: string): Boolean;
C++ declaration
bool __fastcall RemoveComboString(const AnsiString s)

Description
Removes string s from the combobox item list.
RemoveComment
Delphi declaration
procedure RemoveComment(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveComment(int ACol, int ARow)

Description
Removes the comment indicator from cell Acol,Arow
RemoveDataImage
Delphi declaration
procedure RemoveDataImage(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveDataImage(int ACol, int ARow)

Description
Removes the image from cell aCol, Arow. Note : it is not necessary to remove the image

at the cell, before adding a new image, since AddDataImage automatically cleans up previously assigned images.

RemoveFilePicture
Delphi declaration
procedure RemoveFilePicture(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveFilePicture(int ACol, int ARow)

Description
Removes the file picture in cell Acol,Arow
RemoveIcon
Delphi declaration
procedure RemoveIcon(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveIcon(int ACol, int ARow)

Description
Removes the icon in cell Acol,Arow
RemoveImageIdx
-

Delphi declaration
procedure RemoveImageIdx(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveImageIdx(int ACol, int ARow)

Description
Removes the image from cell aCol, Arow. Note : it is not necessary to remove the image

at the cell, before adding a new image, since AddImageIdx automatically cleans up previously assigned images.

RemoveMarker
Delphi declaration
procedure RemoveMarker(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveMarker(int ACol, int ARow)

Description
Remove an error marker if it exists in the cell.
RemoveMultiImage
Delphi declaration
procedure RemoveMultiImage(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveMultiImage(int ACol, int ARow)

Description
Removes the multi image cell from the grid.
RemoveNode
Delphi declaration
procedure RemoveNode(ARow: Integer);
C++ declaration
void __fastcall RemoveNode(int ARow)

Description
Removes the node from visible row index aRow.
RemovePicture
Delphi declaration
procedure RemovePicture(ACol, ARow: Integer);
C++ declaration
void __fastcall RemovePicture(int ACol, int ARow)

Description
Removes the picture in cell Acol,Arow
RemoveProgress
Delphi declaration
procedure RemoveProgress(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveProgress(int ACol, int ARow)

Description
Removes the progressbar graphic from cell Acol,Arow.
RemoveRadio
Delphi declaration
procedure RemoveRadio(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveRadio(int ACol, int ARow)

Description
Removes the radiobuttons from cell aCol, Arow
RemoveRotated
Delphi declaration
procedure RemoveRotated(ACol, ARow: Integer);
C++ declaration
void __fastcall RemoveRotated(int ACol, int ARow)

Description
Removes text rotation information from the cell.
RemoveRows
Delphi declaration
procedure RemoveRows(RowIndex, RCount: Integer);
C++ declaration
virtual void __fastcall RemoveRows(int RowIndex, int RCount)

Description
Removes all rows from the stringgrid, starting from row RowIndex to row RowIndex+RCount-1.
RemoveSelectedRows
Delphi declaration
procedure RemoveSelectedRows;
C++ declaration
void __fastcall RemoveSelectedRows(void)

Description
Removes the selected rows (in disjunct row select mode) from the grid.
RepaintCell
Delphi declaration
procedure RepaintCell(c, r: Integer);
C++ declaration
void __fastcall RepaintCell(int c, int r)

Description
Repaints the cell at grid coordinates r,c
RepaintCol
Delphi declaration
procedure RepaintCol(ACol: Integer);
C++ declaration
void __fastcall RepaintCol(int ACol)

Description
Repaints the column AC o l .
RepaintRect
Delphi declaration
procedure RepaintRect(r: TRect);
C++ declaration
void __fastcall RepaintRect(const Windows::TRect & r)

Description
Repaints the cells within rectangle r.
RepaintRow
Delphi declaration
procedure RepaintRow(ARow: Integer);
C++ declaration
void __fastcall RepaintRow(int ARow)

Description
Repaints the row ARow.
RichToCell
Delphi declaration
procedure RichToCell(Col, Row: Integer; Richeditor: TRichEdit);
C++ declaration
void __fastcall RichToCell(int Col, int Row, Comctrls::TRichEdit *Richeditor)

Description
Transfers text from the richedit control to cell ACol, Arow. RichEdit can be the internal rich edit control of TAdvStringGrid which can be accessed through the RichEdit property.
RowAvg
Delphi declaration
function RowAvg(ARow, fromCol, toCol: Integer): double;
C++ declaration
double __fastcall RowAvg(int ARow, int fromCol, int toCol)

Description
Returns the average of cell values in column ARow from row FromCol to row ToCol.
RowMax
Delphi declaration
function RowMax(ARow, fromCol, toCol: Integer): double;
C++ declaration
double __fastcall RowMax(int ARow, int fromCol, int toCol)

Description
Returns the maximum of cell values in column ARow from row FromCol to row ToCol.
RowMin
Delphi declaration
function RowMin(ARow, fromCol, toCol: Integer): double;
C++ declaration
double __fastcall RowMin(int ARow, int fromCol, int toCol)

Description
Returns the minimum of cell values in column ARow from row FromCol to row ToCol.
RowSum
Delphi declaration
function RowSum(ARow, fromCol, toCol: Integer): double;
C++ declaration
double __fastcall RowSum(int ARow, int fromCol, int toCol)

Description
Returns the sum of cell values in column ARow from row FromCol to row ToCol.
SaveColSizes
Delphi declaration
procedure SaveColSizes;
C++ declaration
void __fastcall SaveColSizes(void)

Description
Save the current column sizes into the registry or inifile at location pointed to by the ColumnSize property.
SavePrintSettings
Delphi declaration
procedure SavePrintSettings(Key, Section: string);
C++ declaration
void __fastcall SavePrintSettings(AnsiString Key, AnsiString section)

void __fastcall SavePrintSettings(AnsiString Key, AnsiString Section)

Description
Saves the printsettings to the registry at key,section

SaveToASCII
Delphi declaration
procedure SaveToASCII(FileName: String);
C++ declaration
void __fastcall SaveToASCII(AnsiString FileName)

Description
Saves contents of stringgrid to a formatted text file. If Delimiter is not specified (ie = #0) a comma is used.
SaveToCSV
Delphi declaration
procedure SaveToCSV(FileName: String);
C++ declaration
void __fastcall SaveToCSV(AnsiString fileName)

void __fastcall SaveToCSV(AnsiString FileName)

Description
Saves contents of stringgrid to a comma delimited text file. Use the delimiter property to save with tab, space or other separators. Use SaveFixedCells property to control saving of fixed cells.

SaveToDOC
Delphi declaration
procedure SaveToDOC(Filename: string);
C++ declaration
void __fastcall SaveToDOC(AnsiString Filename)

Description
Uses OLE automation to transfer cell contents to a MS Word DOC file with table.
SaveToFile
Delphi declaration
procedure SaveToFile(FileName: String);
C++ declaration
void __fastcall SaveToFile(AnsiString FileName)

Description
Saves contents as well as size of the stringgrid to a ASCII file so it can be restored later by calling the LoadFromFile routine.
SaveToFixed
Delphi declaration
procedure SaveToFixed(FileName: string; positions: TIntList);
C++ declaration
void __fastcall SaveToFixed(AnsiString FileName, Advobj::TIntList *positions)

Description
Saves the contents of a grid to a fixed column size ASCII text file
SaveToHTML
Delphi declaration
procedure SaveToHTML(FileName: String);
C++ declaration
void __fastcall SaveToHTML(AnsiString FileName)

Description
Saves contents of stringgrid as well as aligments in HTML format. Uses the HTMLSettings property for several formatting options
SaveToStream
Delphi declaration
procedure SaveToStream(Stream: TStream);
C++ declaration
void __fastcall SaveToStream(Classes::TStream *stream)

void __fastcall SaveToStream(Classes::TStream *Stream)

Description
Saves contents as well as size of the stringgrid to a generic stream.

SaveToXLS
Delphi declaration
procedure SavetoXLS(Filename:string);
C++ declaration
void SavetoXLS(Ansistring Filename);

Description
Uses OLE automation to transfer cell contents to Excel and save to XLS file with name Filename.
SaveToXLSSheet
Delphi declaration
procedure SavetoXLS(FileName,SheetName:string);
C++ declaration
void SavetoXLS(Ansistring FileName; Ansistring SheetName);

Description
Uses OLE automation to transfer cell contents to Excel and save to XLS file with name Filename in the sheet specified by the sheetname.
SaveToXML
Delphi declaration
procedure SaveToXML(FileName: String; ListDescr, RecordDescr: string; FieldDescr: TStrings);
C++ declaration
void __fastcall SaveToXML(AnsiString FileName, AnsiString ListDescr, AnsiString RecordDescr, Classes::TStrings *FieldDescr)

Description
Saves contents of stringgrid as XML file. ListDescr specifies the XML list descriptor name, RecordDescr the record descriptor name and FieldDescr is a stringlist holding the field names for each column of the grid. Fixed columns and rows are not saved to XML.
ScrollInView
Delphi declaration
procedure ScrollInView(ColIndex, RowIndex: Integer);
C++ declaration
void __fastcall ScrollInView(int ColIndex, int RowIndex)

Description
Scrolls the cell ColIndex, RowIndex in view
Search
Delphi declaration
function Search(s: string): Integer;
C++ declaration
int __fastcall Search(AnsiString s)

Description
Returns the first cell containing the string s, or partially matching string s.
SelectCols
Delphi declaration
procedure SelectCols(ColIndex, CCount: Integer);
C++ declaration
void __fastcall SelectCols(int ColIndex, int CCount)

Description
Selects CCount columns starting from ColIndex.
SelectRange
Delphi declaration
procedure SelectRange(FromCol, ToCol, FromRow, ToRow: Integer);
C++ declaration
void SelectRange(int FromCol, int ToCol, int FromRow, int ToRow);

void __fastcall SelectRange(int FromCol, int ToCol, int FromRow, int ToRow)

Description
Selects all cells in the rectangle specified by FromCol, ToCol, FromRow, ToRow.

SelectRows
Delphi declaration
procedure SelectRows(RowIndex, RCount: Integer);
C++ declaration
void __fastcall SelectRows(int RowIndex, int RCount)

Description
Selects RCount rows starting from RowIndex.
SetCheckBoxState
Delphi declaration
function SetCheckBoxState(Acol, Arow: integer; state: boolean): boolean;
C++ declaration
bool __fastcall SetCheckBoxState(int ACol, int ARow, bool state)

Description
Sets the status of the checkbox in cell Acol,Arow. If cell Acol,Arow does not contain a checkbox, the function returns false.
SetComboSelection
Delphi declaration
procedure SetComboSelection(idx: Integer);
C++ declaration
void __fastcall SetComboSelection(int idx)

Description
Sets the current selected item to item idx in the combobox inplace editor. Can be called during the OnGetEditorType event to set default combobox items differently for each column or even cell.
SetComboSelectionString
Delphi declaration
function SetComboSelectionString(const s: string): Boolean;
C++ declaration
bool __fastcall SetComboSelectionString(const AnsiString s)

Description
Sets the current selected item to s in the combobox inplace editor. Can be called during the OnGetEditorType event to set default combobox items differently for each column or even cell.
SetNodeState
Delphi declaration
procedure SetNodeState(ARow: Integer; Value: Boolean);
C++ declaration
void __fastcall SetNodeState(int ARow, bool Value)

Description
Sets the node state at visible row index aRow to the expanded state if true, to the contracted state if false.
SetRadioIdx
Delphi declaration
function SetRadioIdx(ACol, ARow, IdxRadio: Integer): Boolean;
C++ declaration
bool __fastcall SetRadioIdx(int ACol, int ARow, int IdxRadio)

Description
Sets the index of the selected radiobutton in the radiobuttongroup at cell aCol, aRow
ShowInplaceEdit
Delphi declaration
procedure ShowInplaceEdit;
C++ declaration
void __fastcall ShowInplaceEdit(void)

Description
Shows the inplace editor in cell [grid.col,grid.row].
SortByColumn
Delphi declaration
procedure SortByColumn(Col: Integer);
C++ declaration
void __fastcall SortByColumn(int Col)

Description
Sort the column col and set SortColumn property to col.
SwapColumns
Delphi declaration
procedure SwapColumns(ACol1, ACol2: Integer);
C++ declaration
void __fastcall SwapColumns(int ACol1, int ACol2)

Description
Swaps contents of all cells of column 1 and column 2.
SwapRows
Delphi declaration
procedure SwapRows(ARow1, ARow2: Integer);
C++ declaration
void __fastcall SwapRows(int ARow1, int ARow2)

Description
Swaps contents of all cells of row 1 and row 2.
TextFill
Delphi declaration
procedure TextFill(DoFixed: Boolean; Txt: string);
C++ declaration
void __fastcall TextFill(bool DoFixed, AnsiString Txt)

Description
Fills the grid with cell text Txt. When DoFixed is true, fixed cells are filled as well.
ToggleCheckBox
Delphi declaration
function ToggleCheckbox(Acol,Arow:integer):boolean;
C++ declaration
bool ToggleCheckbox(int Acol,int Arow);

Description
Changes the checked state of the checkbox at acol,arow
UnGroup
Delphi declaration
procedure UnGroup;
C++ declaration
void __fastcall UnGroup(void)

Description
If grouping is active, ungroups.
UnHideColumn
Delphi declaration
procedure UnHideColumn(Colindex: Integer);
C++ declaration
void __fastcall UnHideColumn(int Colindex)

Description
Shows a hidden column=colindex again.
UnHideColumns
Delphi declaration
procedure UnHideColumns(fromCol, toCol: Integer);
C++ declaration
void __fastcall UnHideColumns(int fromCol, int toCol)

Description
Shows all hidden columns from FromCol to ToCol again.
UnHideColumnsAll
Delphi declaration
procedure UnHideColumnsAll;
C++ declaration
void __fastcall UnHideColumnsAll(void)

Description
Unhides all hidden columns
UnHideRow
Delphi declaration
procedure UnHideRow(Rowindex: Integer);
C++ declaration
void __fastcall UnHideRow(int Rowindex)

Description
Shows a hidden row=rowindex again.
UnHideRows
Delphi declaration
procedure UnHideRows(FromRow, ToRow: Integer);
C++ declaration
void __fastcall UnHideRows(int fromRow, int toRow)

void __fastcall UnHideRows(int FromRow, int ToRow)

Description
Shows all hidden rows from FromRow to ToRow again.

UnHideRowsAll
Delphi declaration
procedure UnHideRowsAll;
C++ declaration
void __fastcall UnHideRowsAll(void)

Description
Unhides all hidden rows
UnHideSelection
Delphi declaration
procedure UnHideSelection;
C++ declaration
void __fastcall UnHideSelection(void)

Description
Unhides the selected cell or cells after HideSelection
UnHilightInCell
Delphi declaration
procedure UnHilightInCell(Col, Row: Integer);
C++ declaration
void __fastcall UnHilightInCell(int Col, int Row)

Description
Removes all hilights from the specified cell(s)
UnHilightInCol
Delphi declaration
procedure UnHilightInCol(DoFixed: Boolean; Col: Integer);
C++ declaration
void __fastcall UnHilightInCol(bool DoFixed, int Col)

Description
Removes all hilights from the specified cell(s)
UnHilightInGrid
Delphi declaration
procedure UnHilightInGrid(DoFixed: Boolean);
C++ declaration
void __fastcall UnHilightInGrid(bool DoFixed)

Description
Removes all hilights from the specified cell(s)
UnHilightInRow
Delphi declaration
procedure UnHilightInRow(DoFixed: Boolean; Row: Integer);
C++ declaration
void __fastcall UnHilightInRow(bool DoFixed, int Row)

Description
Removes all hilights from the specified cell(s)
UnHilightText
Delphi declaration
function UnHilightText(S: string): string;
C++ declaration
AnsiString __fastcall UnHilightText(AnsiString S)

Description
Removes all hilights from the specified cell(s)
UnMarkInCell
Delphi declaration
procedure UnMarkInCell(Col, Row: Integer);
C++ declaration
void __fastcall UnMarkInCell(int Col, int Row)

Description
Removes all error markers from the specified cell(s)
UnMarkInCol
Delphi declaration
procedure UnMarkInCol(DoFixed: Boolean; Col: Integer);
C++ declaration
void __fastcall UnMarkInCol(bool DoFixed, int Col)

Description
Removes all error markers from the specified cell(s)
UnMarkInGrid
Delphi declaration
procedure UnMarkInGrid(DoFixed: Boolean);
C++ declaration
void __fastcall UnMarkInGrid(bool DoFixed)

Description
Removes all error markers from the specified cell(s)
UnMarkInRow
Delphi declaration
procedure UnMarkInRow(DoFixed: Boolean; Row: Integer);
C++ declaration
void __fastcall UnMarkInRow(bool DoFixed, int Row)

Description
Removes all error markers from the specified cell(s)
UnMarkText
Delphi declaration
function UnMarkText(S: string): string;
C++ declaration
AnsiString __fastcall UnMarkText(AnsiString S)

Description
Removes all error markers from the specified cell(s)
Zoom
Delphi declaration
procedure Zoom(x: Integer);
C++ declaration
void __fastcall Zoom(int x)

Description
Zoom in or out on stringgrid

TAdvStringGrid - Properties

Contents - TAdvStringGrid - Methods - Events

ActiveCellFont
Delphi declaration
property ActiveCellFont: TFont;
C++ declaration
__property Graphics::TFont *ActiveCellFont

Description
If ActiveCellShow is true, this font is used in the fixed row and column header for the active cell. By default, this font is bold.
ActiveCellShow
Delphi declaration
property ActiveCellShow: Boolean;
C++ declaration
__property bool ActiveCellShow={ nodefault }

Description
When true, the fixed row and column cell for the current active cell is displayed using the ActiveCellFont.

For example, when cell 5,3 is active, fixed cells 5,0 and 0,3 will display with ActiveCellFont.

AllCells
Delphi declaration
property AllCells[i, j: Integer]: string;
C++ declaration
__property AnsiString AllCells[int i][int j]

Description
Property through which the cell contents can be accessed irrespective

of hidden rows in the grid.

AllObjects
Delphi declaration
property AllObjects[i, j: Integer]: TObject;
C++ declaration
__property System::TObject *AllObjects[int i][int j]

Description
Property through which the cell objects can be accessed irrespective

of hidden rows in the grid.

ArrowColor
Delphi declaration
property ArrowColor: TColor;
C++ declaration
__property Graphics::TColor ArrowColor={ nodefault }

Description
Property controlling the color of the arrows in enhanced row / column move mode.
AutoNumAlign
Delphi declaration
property AutoNumAlign: Boolean;
C++ declaration
__property bool AutoNumAlign={ nodefault }

Description
Enables automatic right alignment for cell containing numeric data only
AutoSize
Delphi declaration
property AutoSize: Boolean;
C++ declaration
__property bool AutoSize={ nodefault }

Description
Setting the Autosize property to true, resizes all columns to widths so that all text just fits.
BackGround
Delphi declaration
Background:TBackground
C++ declaration
TBackground Background

Description
Sets the background image of the grid
Bands
Delphi declaration
property Bands: TBands;
C++ declaration
__property TBands *Bands

Description
Controls the appearance of bands in the grid.
BtnEdit
Delphi declaration
property BtnEdit: TGridEditBtn;
C++ declaration
__property TGridEditBtn *BtnEdit

Description
Exposes the inplace editor with attached button control for programmatic access to ButtonCaption and Glyph. In this way, ButtonCaption as well as Glyph can be different for editing different cells. Make sure to set ButtonCaption to a null string ('') when using a Glyph for proper glyph alignment.
BtnUnitEdit
Delphi declaration
property BtnUnitEdit: TGridUnitEditBtn;
C++ declaration
__property TGridUnitEditBtn *BtnUnitEdit

Description
Exposes the inplace editor with attached button control and unit selection for programmatic access to ButtonCaption and Glyph and unit list. In this way, ButtonCaption , Glyph and unit list can be different for editing different cells. Make sure to set ButtonCaption to a null string ('') when using a Glyph for proper glyph alignment.
CellChecker
Delphi declaration
property CellChecker: TAdvStringGridCheck;
C++ declaration
__property Asgcheck::TAdvStringGridCheck *CellChecker

Description
Attached component (descendant of TAdvStringGridCheck) that is used for auto-correction and / or marking cell text for errors.
CellImages
Delphi declaration
property CellImages[ACol, ARow: Integer]: TIntList;
C++ declaration
__property Advobj::TIntList *CellImages[int ACol][int ARow]

Description
This public property is the integer list of indexes for a multi image cell. Indexes can be added removed, cleared through the Add, Delete, Clear methods. To add an image to the cell, use CellImages[col,row].Add(index:integer)
CellNode
Delphi declaration
property CellNode: TCellNode;
C++ declaration
__property TCellNode *CellNode

Description
Controls the cell node appearance. It has the following subproperties :

Color : background color of the node when display mode is cnFlat

ContractGlyph : glyph to display when node is in contracted state when NodeType is cnGlyph

ExpandGlyph : glyph to display when node is in expanded state when NodeType is cnGlyph

NodeColor : node color when mode is cnFlat

NodeType : controls 3 node display modes : cnFlat, cn3D, cnGlyph

CheckFalse
Delphi declaration
property CheckFalse: string;
C++ declaration
__property AnsiString CheckFalse

Description
Used with the DataCheckBox inplace editor. Reflects the value of the cell when the checkbox is not checked.
CheckTrue
Delphi declaration
property CheckTrue: string;
C++ declaration
__property AnsiString CheckTrue

Description
Used with the DataCheckBox inplace editor. Reflects the value of the cell when the checkbox is checked.
ColCount
Delphi declaration
property ColCount: Integer;
C++ declaration
__property int ColCount={ nodefault }

Description
Sets the number of columns in the grid.
Colors
Delphi declaration
property Colors[i, j: Integer]: TColor;
C++ declaration
__property Graphics::TColor Colors[int i][int j]

Description
Sets the background color for the cell. The EnableGraphics property needs to be true for the Colors property to have effect.
ColumnHeaders
Delphi declaration
property ColumnHeaders: TStringList;
C++ declaration
__property Classes::TStringList *ColumnHeaders

Description
Allows setting header text of columns at design time. Column headers can take HTML formatted text and to specify multiline column headers the specifier can be used to indicate line breaks.
ColumnSize
Delphi declaration
property ColumnSize: TColumnSize;
C++ declaration
__property TColumnSize *ColumnSize

Description
Controls saving and restoring of column widths as well as behaviour of column resizing.
Combobox
Delphi declaration
property Combobox: TGridCombo;
C++ declaration
__property TGridCombo *Combobox

Description
Gives you access to all the properties of the inplace combobox editor. You can set sort, dropdowncount, style through this property.
CurrentCell
Delphi declaration
property CurrentCell: string;
C++ declaration
__property AnsiString CurrentCell

Description
Property with which the current cell can be set or retrieved.
Cursor
Delphi declaration
property Cursor: TCursor;
C++ declaration
__property Controls::TCursor Cursor={ nodefault }

Description
Sets the cursor for the grid.
Dates
Access the cells as TDateTime values.

Delphi declaration
property Dates[ACol, ARow: Integer]: TDateTime;
C++ declaration
__property System::TDateTime Dates[int ACol][int ARow]

Description
Returns the cell content as TDateTime. An exception is raised when cell does not contain a valid date string.

DateTimePicker
Delphi declaration
property DateTimePicker: TDateTimePicker;
C++ declaration
__property Comctrls::TDateTimePicker *DateTimePicker

Description
Gives you access to all the properties of the inplace date / time editor. Can be used to set colors, min. and max. dates etc. Look at help of TDateTimePicker for all properties. only for Delphi 3 and above.
Delimiter
Delimiter used for CSV input / output

Delphi declaration
property Delimiter: char;
C++ declaration
__property char Delimiter={ nodefault }

Description
Public only property to set delimiter character to use for functions SaveToCSV / LoadFromCSV, defaults to comma. Delimiter is default #0, which indicates that the grid will try to determine in an intelligent way the column delimiter. It checks characters , ; # TAB | @ '* - + and & to find the used delimiter.

EditLink
Delphi declaration
property EditLink: TEditLink;
C++ declaration
__property TEditLink *EditLink

Description
Sets the EditLink component to use when the inplace editor type is edCustom. The TEditLink component is used to do the communication between the grid and any external edit control used within the grid.
EditWithTags
Delphi declaration
property EditWithTags: Boolean default False;
C++ declaration
__property bool EditWithTags={ default=0 }

Description
When true, HTML tags are preserved for inplace editing.
EnableGraphics
Delphi declaration
property EnableGraphics: Boolean;
C++ declaration
__property bool EnableGraphics={ nodefault }

Description
If false, users can store non-objects to string Objects[] property.
EnableHTML
Delphi declaration
property EnableHTML: Boolean;
C++ declaration
__property bool EnableHTML={ nodefault }

Description
When false, the mini HTML engine does not process any cells that contain HTML formatting tags. Default value is true.
EnableWheel
Delphi declaration
property EnableWheel: Boolean;
C++ declaration
__property bool EnableWheel={ nodefault }

Description
When true, mousewheel messages are handled by the grid, such as scrolling, panning and zooming.
EnhRowColMove
Delphi declaration
property EnhRowColMove: Boolean;
C++ declaration
__property bool EnhRowColMove={ nodefault }

Description
If true, shows column or row header while dragging it into the new position.
EnhTextSize
Delphi declaration
property EnhTextSize: Boolean;
C++ declaration
__property bool EnhTextSize={ nodefault }

Description
If true, text in cells is appended with ... if it doesn't fit into the cell.
ExcelClipboardFormat
Delphi declaration
property ExcelClipboardFormat: Boolean;
C++ declaration
__property bool ExcelClipboardFormat={ nodefault }

Description
Make clipboard functions for multiline text fully compatible with Excel.
ExcelStyleDecimalSeparator
Delphi declaration
property ExcelStyleDecimalSeparator: Boolean default False;
C++ declaration
__property bool ExcelStyleDecimalSeparator={ default=0 }

Description
When true, the correct international decimal separator is entered when the decimal point on the numeric keypad is pressed.
FastPrint
Delphi declaration
property FastPrint: Boolean;
C++ declaration
__property bool FastPrint={ nodefault }

Description
When true, printing is done without page calculation.
Filter
Multi column filter specification collection.

Delphi declaration
property Filter: Tfilter;
C++ declaration
__property TFilter *Filter

Description
Holds the filter specifier for a filtering operation. Filter is a TCollection of elements with 2 properties, Condition, which is a string and Column which is an integer. The Condition property can contain a condition in following formats :

substring filterting :

S*, S? : * or ? denote multi or single character matches

>, < , >=, =< : larger than, less than, larger or equal, less or equal (when data is numeric, comparison take place based on numeric data, when a valid date is detected, date comparison is used, otherwise it defaults to alphabetic comparisons)

= , ! : equal or not equal

& : logical AND

^ : logical OR

; : logical OR

Thus, an expression : >20 & <30 is a valid filtering expression as well as !A*

FilterActive
Delphi declaration
property FilterActive: Boolean default False;
C++ declaration
__property bool FilterActive={ default=0 }

Description
Set true to start filtering based on the filter specified with the Filter property.
FindBusy
Delphi declaration
property FindBusy: Boolean;
C++ declaration
__property bool FindBusy={ nodefault }

Description
Indicates if search has started but not all cells have been searched yet.
FixedAsButtons
When true, the fixed cells behave as buttons

Delphi declaration
property FixedAsButtons: Boolean;
C++ declaration
__property bool FixedAsButtons={ nodefault }

Description
When true, the fixed cells behave as buttons.

FixedColAlways
Delphi declaration
property FixedColAlways: Boolean default False;
C++ declaration
__property bool FixedColAlways={ default=0 }

Description
When true, a fixed column is always available also if the number of columns is equal to the number of fixed columns.
FixedCols
Delphi declaration
property FixedCols: Integer;
C++ declaration
__property int FixedCols={ nodefault }

Description
Sets the number of fixed columns in the grid.
FixedColWidth
Width of the fixed column(s)

Delphi declaration
property FixedColWidth: Integer;
C++ declaration
__property int FixedColWidth={ nodefault }

Description
Set the width of the fixed column which can otherwise not be set during design time.

FixedFont
Delphi declaration
property FixedFont: TFont;
C++ declaration
__property Graphics::TFont *FixedFont

Description
Sets the font used for fixed cells.
FixedFooters
Delphi declaration
property FixedFooters: Integer;
C++ declaration
__property int FixedFooters={ nodefault }

Description
Set number of fixed rows at bottom side of the grid
FixedRightCols
Delphi declaration
property FixedRightCols: integer;
C++ declaration
__property int FixedRightCols={ nodefault }

Description
Set number of fixed columns at right side of the grid
FixedRowAlways
Delphi declaration
property FixedRowAlways: Boolean default False;
C++ declaration
__property bool FixedRowAlways={ default=0 }

Description
When true, a fixed row is always available also if the number of rows is equal to the number of fixed row.
FixedRowHeight
Width of the fixed row(s)

Delphi declaration
property FixedRowHeight: Integer;
C++ declaration
__property int FixedRowHeight={ nodefault }

Description
Set the height of the fixed row which can otherwise not be set during design time.

FixedRows
Delphi declaration
property FixedRows: Integer;
C++ declaration
__property int FixedRows={ nodefault }

Description
Sets the number of fixed rows in the grid.
Flat
Delphi declaration
property Flat: Boolean;
C++ declaration
__property bool Flat={ nodefault }

Description
When true, the grid is shown in flat style.
FlatCheckBox
Delphi declaration
property FlatCheckBox: Boolean;
C++ declaration
__property bool FlatCheckBox={ nodefault }

Description
When true, checkboxes are displayed in flat style.
FloatFormat
Delphi declaration
property FloatFormat: string;
C++ declaration
__property AnsiString FloatFormat

Description
Float formatting string used to format the cell when a float is added through the Floats[col,row] property.
Floats
Delphi declaration
property Floats[ACol, ARow: Integer]: double;
C++ declaration
__property double Floats[int ACol][int ARow]

Description
Property to access the cells as float values. The result is 0 if the cell doesn't contain a valid float value. When setting the float value of a cell, the FloatFormat property is used to format the float into a string.
GridImages
Delphi declaration
property GridImages: TImageList;
C++ declaration
__property Controls::TImageList *GridImages

Description
Set imagelist from which bitmaps are taken to display when using SetImageIdx / RemoveImageIdx functions or when referring to imagelist images in HTML formatting.
GroupColumn
Delphi declaration
property GroupColumn: Integer;
C++ declaration
__property int GroupColumn={ nodefault }

Description
Sets the current grouping column. To ungroup, set GroupColumn to -1. Note that column 0 is the placeholder for the grouping expand / contract nodes. The appearance of the expand / contract nodes is controlled through the CellNode property. Also note that EnableGraphics must be through in order to display the nodes.
HideFocusRect
Delphi declaration
property HideFocusRect: Boolean default False;
C++ declaration
__property bool HideFocusRect={ default=0 }

Description
When false, disables the painting of a focusrectangle for the current focused cell.
HintColor
Sets the color of the hints appearing in the stringgrid.

Delphi declaration
property HintColor: TColor;
C++ declaration
__property Graphics::TColor HintColor={ nodefault }

Description
Sets the hint color of the grid but this does not modify color of hints on other components on the same form.

HintShowCells
Delphi declaration
property HintShowCells: Boolean;
C++ declaration
__property bool HintShowCells={ nodefault }

Description
Hints are full cell contents. (Only for Delphi 3 and higher or C++Builder 3 and higher)
HintShowLargeText
Delphi declaration
property HintShowLargeText: Boolean;
C++ declaration
__property bool HintShowLargeText={ nodefault }

Description
When true a hint is displayed on cells that do not fit in the cell.
HintShowSizing
Delphi declaration
property HintShowSizing: Boolean;
C++ declaration
__property bool HintShowSizing={ nodefault }

Description
When true, a hint is shown while columns or rows are resized indicating the new column or row size in pixels.
Hovering
Delphi declaration
property Hovering: Boolean default False;
C++ declaration
__property bool Hovering={ default=0 }

Description
When true, the cell under the mouse cursor is automatically selected when the mouse is over it for some time.
HTMLSettings
property controlling several options for the SaveToHTML function.

Delphi declaration
property HTMLSettings: THTMLSettings;
C++ declaration
__property THTMLSettings *HTMLSettings

Description
Controls the generation of a HTML table of the grid contents :

BorderSize : table border size in HTML

CellSpacing : table cellspacing in HTML

FooterFile : file that is optionally appended at the end of the HTML for the grid content.

HeaderFile : file that is optionally included before the grid content

PrefixTag : optional HTML tags included before the grid content HTML code

SuffixTag : optional HTML tags included after the grid content HTML code

SaveColor : when true, color information is saved in HTML

SaveFonts : when true, font information is saved in HTML

TableStyle : optional table style tags for HTML

Width : width in % of the HTML table

ImageCache
Delphi declaration
property ImageCache: THTMLPictureCache;
C++ declaration
__property Picturecontainer::THTMLPictureCache *ImageCache
InplaceRichEdit
Delphi declaration
property InplaceRichEdit: TAdvRichEdit;
C++ declaration
__property TAdvRichEdit *InplaceRichEdit

Description
Exposes the inplace rich editor. Through this inplace editor, the selection attributes of the text can be set or retrieved.
IntelliPan
Delphi declaration
property IntelliPan: TIntelliPan;
C++ declaration
__property TIntelliPan IntelliPan={ nodefault }

Description
Selects the panning mode. Panning can be allowed vertical, horizontal or in both directions. Panning is started by clicking the mousewheel and moving the mouse.
IntelliZoom
Delphi declaration
property IntelliZoom: Boolean default True;
C++ declaration
__property bool IntelliZoom={ default=1 }

Description
When true, zooming with the mouse is possible.Zooming is done with holding the Ctrl key and the mousewheel.
Ints
Access the cells as integers.

Delphi declaration
property Ints[ACol, ARow: Integer]: Integer;
C++ declaration
__property int Ints[int ACol][int ARow]

Description
Returns the cell content as integer. An exception is raised when cell does not contain integer data and read is performed.

JavaCSV
Delphi declaration
property JavaCSV: Boolean;
C++ declaration
__property bool JavaCSV={ nodefault }

Description
Property. When true, the CSV file is in Java compatible mode, ie. line breaks are saved as ~ characters.
Look
Delphi declaration
property Look: TGridLook default glStandard;
C++ declaration
__property TGridLook Look={ default=0 }

Description
Sets the look of the grid either to the standard look or a soft flat look.
Lookup
Enable autolookup edit controls in grid, based on stringlist LookupItems.

Delphi declaration
property Lookup: Boolean;
C++ declaration
__property bool Lookup={ nodefault }

Description
TAdvStringGrid can automatically memorize all text typed in its cells and suggest autocompletion of text already entered in the grid or programmatically added in the %REF% LookupItems,TAdvStringGrid,LookupItems %REF% stringlist property

LookupCaseSensitive
Delphi declaration
property LookupCaseSensitive: Boolean;
C++ declaration
__property bool LookupCaseSensitive={ nodefault }

Description
When true, the lookups performed are case sensitive.
LookupHistory
Delphi declaration
property LookupHistory: Boolean;
C++ declaration
__property bool LookupHistory={ nodefault }

Description
Enable automatic history list building for lookup edit control.
LookupItems
Delphi declaration
property LookupItems: TStringList;
C++ declaration
__property Classes::TStringList *LookupItems

Description
Items for auto lookup of inplace edit controls. This is a stringlist to which lookup strings can be added programmatically.

Example : AdvStringGrid.LookupItems.Add('example'); or AdvStringGrid.LookupItems.Assign(frequenttextlist);

MaxEditLength
Delphi declaration
property MaxEditLength: Integer;
C++ declaration
__property int MaxEditLength={ nodefault }

Description
Sets the maximum length in characters for inplace editing.Can be set different for each cell, by changing the value of this property in the OnGetCellEditor event.
MouseActions
Delphi declaration
property MouseActions: TMouseActions;
C++ declaration
__property TMouseActions *MouseActions

Description
Holds all settings of enhanced mouse handling in the grid
Multilinecells
Enable / disable multiline cells

Delphi declaration
property Multilinecells: Boolean;
C++ declaration
__property bool Multilinecells={ nodefault }

Description
If true, multiline cells are supported. Multiline text can be entered in cells by using the #13 line separator. For example : 'this is a'#13'multiline text' will be displayed as two lines when enabled.

As an alternative wordwrapped style can be choosen for multiline text

Navigation
Delphi declaration
property Navigation: TNavigation;
C++ declaration
__property TNavigation *Navigation

Description
Holds all settings of enhanced keyboard navigation in the grid
NodeState
Delphi declaration
property NodeState[ARow: Integer]: Boolean;
C++ declaration
__property bool NodeState[int ARow]

Description
Returns the node state for a row. When true, the node is contracted.
NormalEdit
Delphi declaration
property NormalEdit: TAdvInplaceEdit;
C++ declaration
__property TAdvInplaceEdit *NormalEdit

Description
Exposes the normal inplace editor. Can be used to get the selected text from the inplace editor or to set additional properties if required.
OemConvert
Delphi declaration
property OemConvert: boolean;
C++ declaration
__property bool OemConvert={ nodefault }

Description
When true, the LoadFromCSV, SaveToCSV functions use OEM character conversion routines to load/save to ASCII CSV file.
OleAcceptFiles
Delphi declaration
property OleAcceptFiles: Boolean default False;
C++ declaration
__property bool OleAcceptFiles={ default=0 }

Description
When true, the control accepts OLE file drag & drop operations
OleAcceptText
Delphi declaration
property OleAcceptText: Boolean default False;
C++ declaration
__property bool OleAcceptText={ default=0 }

Description
When true, the control accepts OLE text drag & drop operations
OleDropRTF
Delphi declaration
property OleDropRTF: Boolean default False;
C++ declaration
__property bool OleDropRTF={ default=0 }

Description
When true, enables full rich text drag and drop. (Only for Delphi 3 and higher)
OleDropSource
Delphi declaration
property OleDropSource: Boolean default False;
C++ declaration
__property bool OleDropSource={ default=0 }

Description
When true, the grid allows that a range of cells is dragged into another application that supports OLE drag & drop (like Excel / Word) The range of cells needs to be selected first in the grid and then dragged by clicking near the border of the selected cells (just like in Excel). (Only for Delphi 3 and higher)
OleDropTarget
Delphi declaration
property OleDropTarget: Boolean default False;
C++ declaration
__property bool OleDropTarget={ default=0 }

Description
When true, the grid accepts data being dropped on the grid (from Excel, Word) or a CSV file from Explorer. Select a range of cells in Excel or another OLE drag & drop source, and drag into the grid. The data is inserted from the position where the drop is performed. If a filename from Explorer is dropped into the grid, the grid will attempt to open the file if it's a CSV file. (Only for Delphi 3 and higher)
OleEntireRows
Delphi declaration
property OleEntireRows: Boolean default False;
C++ declaration
__property bool OleEntireRows={ default=0 }

Description
When true, entire rows are copied in OLE drag & drop operations (including fixed rows)
OleInsertRows
Delphi declaration
property OleInsertRows: Boolean default False;
C++ declaration
__property bool OleInsertRows={ default=0 }

Description
When true, rows are automatically inserted during drag & drop operations.
OleRemoveRows
Delphi declaration
property OleRemoveRows: Boolean default False;
C++ declaration
__property bool OleRemoveRows={ default=0 }

Description
When true, rows are automatically removed during OLE drag & drop move operations
OriginalCellValue
Delphi declaration
property OriginalCellValue: string;
C++ declaration
__property AnsiString OriginalCellValue

Description
Holds the cell value before editing started so the content can be restored at later time if for example validation fails.
PasswordChar
Delphi declaration
property PasswordChar: char;
C++ declaration
__property char PasswordChar={ nodefault }

Description
Determines which character is used in password cells. A password cell is defined through the event OnIsPasswordCell. Default value is *
PictureContainer
Delphi declaration
property PictureContainer: TPictureContainer;
C++ declaration
__property Picturecontainer::TPictureContainer *PictureContainer

Description
Attached picture container that can be used to hold GIF, JPEG, BMP, WMF or ICO files for use in HTML formatted cells referencing these images by their name in the PictureContainer.
PreviewPage
Delphi declaration
property PreviewPage: Integer;
C++ declaration
__property int PreviewPage={ nodefault }

Description
Sets the page number to generate for page preview. Its default value is 1. This is a public property.
PrintColEnd
Delphi declaration
property PrintColEnd: Integer;
C++ declaration
__property int PrintColEnd={ nodefault }

Description
Property indicates the column index of the last printed column on the current printed page. Property is valid during OnPrintPage event handler.
PrintColOffset
Delphi declaration
property PrintColOffset[ACol: Integer]: Integer;
C++ declaration
__property int PrintColOffset[int ACol]

Description
Property indicates the offset from left margin of the column ACol on the current printed page. Property is valid during OnPrintPage event handler.
PrintColStart
Delphi declaration
property PrintColStart: Integer;
C++ declaration
__property int PrintColStart={ nodefault }

Description
Property indicates the column index of the first printed column on the current printed page. Property is valid during OnPrintPage event handler.
PrintColWidth
.

Delphi declaration
property PrintColWidth[ACol: Integer]: Integer;
C++ declaration
__property int PrintColWidth[int ACol]

Description
Property indicates the width of column ACol on the current printed page. Property is valid during OnPrintPage event handler

PrinterDriverFix
Delphi declaration
property PrinterDriverFix: Boolean;
C++ declaration
__property bool PrinterDriverFix={ nodefault }

Description
When true, uses a fix required for some printer drivers for printing rotated fonts.
PrintNrOfPages
Delphi declaration
property PrintNrOfPages: Integer;
C++ declaration
__property int PrintNrOfPages={ nodefault }

Description
Property indicates the number of pages required for printing during the OnPrintPage event handler.
PrintPageRect
Delphi declaration
property PrintPageRect: TRect;
C++ declaration
__property Windows::TRect PrintPageRect

Description
Property indicates the page size of the currently printed page. Can be used in the OnPrintPage event handler to add special custom printing fitted on the page.
PrintPageWidth
Delphi declaration
property PrintPageWidth: Integer;
C++ declaration
__property int PrintPageWidth={ nodefault }

Description
Property indicates the width of the grid on the current printed page. Property is valid during OnPrintPage event handler.
PrintSettings
Delphi declaration
property PrintSettings: TPrintSettings;
C++ declaration
__property TPrintSettings *PrintSettings

Description
Holds all printout settings
RealCol
Returns the real column index of the current selected column.

Delphi declaration
property RealCol: Integer;
C++ declaration
__property int RealCol={ nodefault }

Description
Takes hidden columns into account to return the real column index, independent of the hidden columns.

RealRow
Returns the real row index of the current selected row.

Delphi declaration
property RealRow: Integer;
C++ declaration
__property int RealRow={ nodefault }

Description
Takes hidden rows into account to return the real row index, independent of the hidden rows.

RichEdit
Delphi declaration
property RichEdit: TAdvRichEdit;
C++ declaration
__property TAdvRichEdit *RichEdit

Description
Exposes the internal rich edit control. Can be used to do the rich text formatting of cell with its SelAttributes/SelStart/Sellength interface.
RowCount
Delphi declaration
property RowCount: Integer;
C++ declaration
__property int RowCount={ nodefault }

Description
Sets the number of rows in the grid.
RowHeaders
Delphi declaration
property RowHeaders: TStringList;
C++ declaration
__property Classes::TStringList *RowHeaders

Description
Allows setting header text of rows at design time. Row headers can take HTML formatted text and to specify multiline column headers the specifier can be used to indicate line breaks.
RowIndicator
Delphi declaration
property RowIndicator: TBitmap;
C++ declaration
__property Graphics::TBitmap *RowIndicator

Description
Bitmap holding a row indicator glyph show in the first fixed cell of a row to indicate the current row.
RowSelect
Sets a row as selected or not.

Delphi declaration
property RowSelect[ARow: Integer]: Boolean;
C++ declaration
__property bool RowSelect[int ARow]

Description
If goRowSelect is true in Options, the grid supports disjunt row selection through the RowSelect property. Multiple disjunct rows can be selected in the grid, either programmatically, or through clicking with ctrl key. RowSelect returns true for all current selected rows. After setting selected rows programmatically, call a repaint !

RowSelectCount
Delphi declaration
property RowSelectCount: Integer;
C++ declaration
__property int RowSelectCount={ nodefault }

Description
Returns the number of selected rows in disjunct row select mode.
SaveFixedCells
Delphi declaration
property SaveFixedCells: Boolean;
C++ declaration
__property bool SaveFixedCells={ nodefault }

Description
When true, fixed cells are also saved or loaded. When falls, only normal cells are saved or loaded.
SaveHiddenCells
Delphi declaration
property SaveHiddenCells: Boolean;
C++ declaration
__property bool SaveHiddenCells={ nodefault }

Description
When true, saves the values of the hidden columns as well during SaveToCSV.The default value is false.
ScrollColor
Delphi declaration
property ScrollColor: TColor;
C++ declaration
__property Graphics::TColor ScrollColor={ nodefault }

Description
Determines the background color of the scrollbars. This property has effect only when ScrollProportional is true. The default color is clNone.
ScrollHints
Delphi declaration
property ScrollHints: TScrollHintType;
C++ declaration
__property TScrollHintType ScrollHints={ nodefault }

Description
Sets the type of hints used during scrolling. See ScrollHintType
ScrollProportional
Delphi declaration
property ScrollProportional: Boolean;
C++ declaration
__property bool ScrollProportional={ nodefault }

Description
Enable proportional scrollbars.
ScrollSynch
Delphi declaration
property ScrollSynch: Boolean;
C++ declaration
__property bool ScrollSynch={ nodefault }

Description
When true, scrolling is synchronous with scrollbar movement. The grid scrolls during the scrollbar moving instead of scrolling only when the new scrollbar position is set.
ScrollType
Delphi declaration
property ScrollType: TScrollType;
C++ declaration
__property TScrollType ScrollType={ nodefault }

Description
Determines the type of scrollbars used. Can be either ssNormal, ssFlat or ssEncarta. This property has effect only when ScrollProportional is true.
ScrollWidth
Delphi declaration
property ScrollWidth: Integer;
C++ declaration
__property int ScrollWidth={ nodefault }

Description
Determines the width of the scrollbars. This property has effect only when ScrollProportional is true.
SelectionColor
Delphi declaration
property SelectionColor: TColor;
C++ declaration
__property Graphics::TColor SelectionColor={ nodefault }

Description
Sets the grid background color for selected cells. Default value is clHighLight
SelectionRectangle
Delphi declaration
property SelectionRectangle: Boolean;
C++ declaration
__property bool SelectionRectangle={ nodefault }

Description
Draws rectangle with thick borders round selected cells.
SelectionRTFKeep
Delphi declaration
property SelectionRTFKeep: Boolean;
C++ declaration
__property bool SelectionRTFKeep={ nodefault }

Description
When true, keeps RTF text coloring instead of changing to highlight text color
SelectionTextColor
Delphi declaration
property SelectionTextColor: TColor;
C++ declaration
__property Graphics::TColor SelectionTextColor={ nodefault }

Description
Sets the text color of selected cells. Default value is clHighLightText
ShowSelection
Delphi declaration
property ShowSelection: Boolean default True;
C++ declaration
__property bool ShowSelection={ default=1 }

Description
When ShowSelection is false, the selected cells are not shown when the grid has no focus.
SizeWhileTyping
Delphi declaration
property SizeWhileTyping: TSizeWhileTyping;
C++ declaration
__property TSizeWhileTyping *SizeWhileTyping

Description
Enables column sizing (vertical and/or horizontal) while typing text.
SizeWithForm
Delphi declaration
property SizeWithForm: Boolean;
C++ declaration
__property bool SizeWithForm={ nodefault }

Description
If true, the stringgrid resizes itself when the parent form also resizes.
SortAutoFormat
Delphi declaration
property SortAutoFormat: Boolean;
C++ declaration
__property bool SortAutoFormat={ nodefault }

Description
When true, a best guess is done automatically for the format of the cell contents.
SortBlankPosition
Delphi declaration
property SortBlankPosition: TSortBlankPosition default blFirst;
C++ declaration
__property TSortBlankPosition SortBlankPosition={ default=0 }

Description
When
SortColumn
Current sorted column

Delphi declaration
property SortColumn: Integer;
C++ declaration
__property int SortColumn={ nodefault }

Description
When the SortColumn property is set, the specified column is sorted with the QSort method. Can also be used to readback which column the user has clicked to sort.

SortDirection
Sets direction of sort globally for stringgrid.

Delphi declaration
property SortDirection: TSortDirection;
C++ declaration
__property TSortDirection SortDirection={ nodefault }

Description
TSortDirection = (sdAscending,sdDescending);

SortDownGlyph
Delphi declaration
property SortDownGlyph: TBitmap;
C++ declaration
__property Graphics::TBitmap *SortDownGlyph

Description
Glyph used to indicate descending sort mode instead of the default triangle.
SortFixedCols
Delphi declaration
property SortFixedCols: Boolean;
C++ declaration
__property bool SortFixedCols={ nodefault }

Description
If true, sorts fixed columns too when clicked.
SortFull
Delphi declaration
property SortFull: Boolean;
C++ declaration
__property bool SortFull={ nodefault }

Description
When true full sorting is enabled, ie. sorting on the SortColumn and subsorting on the columns right from the SortColumn. When false, sorting is limited to the SortColumn only.
SortIgnoreBlanks
Delphi declaration
property SortIgnoreBlanks: Boolean default False;
C++ declaration
__property bool SortIgnoreBlanks={ default=0 }

Description
When true, blank cells are ignored during sorting and always put as last rows after the sort.
SortIndexes
Delphi declaration
property SortIndexes: TSortIndexList;
C++ declaration
__property Advobj::TSortIndexList *SortIndexes

Description
List of column indexes that determine the sort order.
SortIndexShow
Delphi declaration
property SortIndexShow: Boolean;
C++ declaration
__property bool SortIndexShow={ nodefault }

Description
When true, the grid shows indexed sort indicators in the column headers. Mouse left click sets the main sort index while mouse shift leftclicks add additional sort indexes.
SortNormalCellsOnly
Delphi declaration
property SortNormalCellsOnly: Boolean;
C++ declaration
__property bool SortNormalCellsOnly={ nodefault }

Description
When SortNormalCellsOnly is true, fixed columns are not affected by the sort.
SortShow
Set display of sort indicator in column header.

Delphi declaration
property SortShow: Boolean;
C++ declaration
__property bool SortShow={ nodefault }

Description
If true, sorting when clicking on column headers is enabled and the sort indicators are displayed in the column headers.

The default sort indicator is a triangle, but custom bitmaps can be defined to indicate the sorting direction with the %REF% SortUpGlyph,TAdvStringGrid,SortUpGlyph %REF% and %REF% SortDownGlyph,TAdvStringGrid,SortDownGlyph %REF% properties

SortSingleColumn
Delphi declaration
property SortSingleColumn: Boolean default False;
C++ declaration
__property bool SortSingleColumn={ default=0 }

Description
When true, only cells within the column to be sorted are rearranged in sorted order leaving other columns unaffected.
SortUpGlyph
Delphi declaration
property SortUpGlyph: TBitmap;
C++ declaration
__property Graphics::TBitmap *SortUpGlyph

Description
Glyph used to indicate ascending sort mode instead of the default triangle.
SpinEdit
Delphi declaration
property SpinEdit: TGridSpin;
C++ declaration
__property TGridSpin *SpinEdit

Description
Exposes the spineditor control for programmatic access to MinValue, MaxValue and Increment properties.
StrippedCells
Property to access all the grid cells as plain text when working with HTML formatted cells.

Delphi declaration
property StrippedCells[i, j: Integer]: string;
C++ declaration
__property AnsiString StrippedCells[int i][int j]

Description
The StrippedCells property returns the text of a cell with all formatting removed. This is a read-only property.

Times
Delphi declaration
property Times[ACol, ARow: Integer]: TDateTime;
C++ declaration
__property System::TDateTime Times[int ACol][int ARow]

Description
Returns the cell content as TDateTime. An exception is raised when cell does not contain a valid time string.
URLColor
Delphi declaration
property URLColor: TColor;
C++ declaration
__property Graphics::TColor URLColor={ nodefault }

Description
Color used to display URLs.
URLEdit
Delphi declaration
property URLEdit: Boolean;
C++ declaration
__property bool URLEdit={ nodefault }

Description
URL editing enabled when right-clicking on the cell with a URL.
URLFull
Delphi declaration
property URLFull: Boolean;
C++ declaration
__property bool URLFull={ nodefault }

Description
If true, displays full URL, ie including protocol prefix.
URLShow
Delphi declaration
property URLShow: Boolean;
C++ declaration
__property bool URLShow={ nodefault }

Description
Makes grid URL-aware and displays clickable URLs in cells.
VAlignment
Delphi declaration
property VAlignment: TVAlignment;
C++ declaration
__property TVAlignment VAlignment={ nodefault }

Description
Sets vertical alignment of text in cells in single line mode with

TVAlignment = (vtaBottom, vtaCenter, vtaTop);

VersionNr
Delphi declaration
property VersionNr: Integer;
C++ declaration
__property int VersionNr={ nodefault }

Description
Returns the version number of the component as integer value; with the major version number in the high order word and the minor version number in the low order word.
VersionString
Delphi declaration
property VersionString: string;
C++ declaration
__property AnsiString VersionString

Description
Returns the version of the component as a string.
WordWrap
Delphi declaration
property WordWrap: boolean;
C++ declaration
__property bool WordWrap={ nodefault }

Description
Set normal inplace editing mode and display to automatic wordwrapping. EnhTextSize and MultilineCells property should be false if wordwrapping used.
XYOffset
Delphi declaration
property XYOffset: TPoint;
C++ declaration
__property Windows::TPoint XYOffset

Description
Sets the offset from the topleft corner of the cell to display the cell text. Default value is 2,2 which mathes with the positioning of text within the normal inplace editor.