Methods

procedure Clear

This methods clears all of the grid's cells of any text. It also clears text in hidden columns.

procedure ClearRange( TopLeft , BottomRight : TGridCoord )

Clears the cells in the given range.

procedure ClearHeadings;

Clears the Headings property of THyperGrid. Use this instead of Headings.Clear.

procedure DeleteRow( ARow : Longint )

Deletes the given row. If the row specified is fixed or not valid, an exception will be thrown.

function GridColumnForColumnObject( Column : ThgColumn ) : Longint

Returns the grid column index for the given column object. If the column object is nil or hidden, the result will be -1. See also Grid Columns and Column Objects.

procedure InsertRow( const ARow : Longint )

Inserts a blank row at the given location. If an attempt is made to insert a row before the last fixed row, or past the last scrolling row, an exception is thrown.

procedure InvalidateColumn( const ACol : Longint )

Invalidates the entire column specified by ACol, causing THyperGrid to repaint it.

procedure InvalidateRow( const ARow : Longint )

Invalidates the entire row specified by ARow, causing THyperGrid to repaint it.

procedure LoadColumnWidthsFromRegistry( const Key : string )

Given a registry key, this method loads column widths from the registry. Column widths must have been saved with the SaveColumnWidthsToRegistry method. These two methods are used automatically by the grid, if a key is specified in the ColumnsRegistryKey property.

procedure LoadFromDataSet( DataSet : TDataSet; LoadFieldNames : Boolean; StartCol , StartRow : Longint )

This method places the contents of the given data set into the grid starting at column StartCol and row StartRow. If LoadFieldNames is true, the names of the fields are loaded in StartRow, otherwise, the field names are ignored. The grid will be expanded if necessary, that is, if there are more fields than columns, the column count will be increased accordingly. If there are more rows in the dataset, rows will be added to the grid.

procedure LoadFromFile( StartCol , StartRow : Longint; const FileName : string )

Will load the grid from the given file. The file should be a standard CSV file. See SaveToFile below.

procedure LoadFromStream( StartCol , StartRow : Longint; Stream : TStream )

Thid methods loads the grid's contents as a CSV file from the given stream.

procedure SaveColumnWidthsToRegistry( const Key : string )

Saves the widths of all columns to the registry key specified by Key.

procedure SaveToFile( StartCol , StartRow : Longint; const FileName : string )

Saves the contents of the grid, starting at StartCol and StartRow to the given file. The grid's contents are saved as a CSV file. Each row is saved as a new line, and each cell is quoted and delimited by a comma. If the cell includes quotes, they are doubled. This format is accepted by Excel and any other application that can handle standard CSV files.

procedure SaveToStream( StartCol , StartRow : Longint; Stream : TStream )

Same as above, but the grid's contents are saved to the given stream. This allows you to write some additional data to the stream before and after THyperGrid saves its cells.

procedure SelectEntireColumn( const ACol : Longint )

Selects the entire column specified by ACol. Note, this will only work if the grid is not editable, as range selection is not allowed for editable grids.

procedure SelectEntireRow( const ARow : Longint )

Selectes the row specified by ARow. Note, this will only work if the grid is not editable, as range selection is not allowed for editable grids.