Online Documentation for Advanced Excel Report for RAD Studio

OnSetCellValue event - Example


procedure TReportContainer.CellDataSetCellValue(Sender: TObject;

  Band: TEXLReportBand; RowInTemplate, RowInReport, ColumnInReport: Integer;

  var CellValue: OleVariant);

begin

  if Band.BandType = xlrbtMasterData then

    CellValue := AnsiUpperCase(CellValue);

end;