TdxSpreadSheetTableViewSelection.Items Property

Provides indexed access to selected cell ranges.

Declaration

property Items[Index: Integer]: TcxRect read; default;

Property Value

Type	Description
TcxRect	Cell range boundaries, in row and column indexes.

Remarks

Use this property to access individual selected cells and cell ranges by their indexes. The indexes reflect the order of selection (areas with lower indexes were selected earlier).

The following code example uses the Items property to fill the background of all selected cells with the yellow color (clYellow):

Delphi

var
  ATableView: TdxSpreadSheetTableView;
  ACell: TdxSpreadSheetCell;
  I, J, K: Integer;
begin
  ATableView := dxSpreadSheet1.ActiveSheetAsTable;
  ATableView.BeginUpdate; // Stops worksheet redraw operations
  for I := 0 to ATableView.Selection.Count - 1 do // Iterates through all selected cell ranges
  begin
    // Iterates through cell rows within the current cell range
    for J := ATableView.Selection.Items[I].Top to ATableView.Selection.Items[I].Bottom do
    begin
      // Iterates through cells within the current row
      for K := ATableView.Selection.Items[I].Left to ATableView.Selection.Items[I].Right do
      begin
        ACell := ATableView.CreateCell(J, K);
        ACell.Style.Brush.BackgroundColor := clYellow;
      end;
    end;
  end;
  ATableView.EndUpdate; // Resumes worksheet redraw operations and applies the visual changes
end;

C++

  TdxSpreadSheetTableView *ATableView;
  TdxSpreadSheetCell *ACell;
  // ...
  ATableView = dxSpreadSheet1->ActiveSheetAsTable;
  ATableView->BeginUpdate(); // Stops worksheet redraw operations
  for (int i = 0; i < ATableView->Selection->Count; i++) // Iterates through all selected cell ranges
  {
    // Iterates through cell rows within the current cell range
    for (int j = ATableView->Selection->Items[i].Top; j <= ATableView->Selection->Items[i].Bottom)
    {
      // Iterates through cells within the current row
      for (int k = ATableView->Selection->Items[i].Left; k <= ATableView->Selection->Items[i].Right)
      {
        ACell = ATableView->CreateCell(j, k);
        ACell->Style->Brush->BackgroundColor = clYellow;
      }
    }
  }
  ATableView->EndUpdate(); // Resumes worksheet redraw operations and applies the visual changes