FlexCel Studio for VCL/LCL
ContentsIndex
PreviousUpNext
TFlexCelGrid.SetCell Method

Sets the value on a cell based on a string.

Pascal
procedure SetCell(const aRow: integer; const aCol: integer; const Text: UTF16String);
C++
__fastcall SetCell(const int aRow, const int aCol, const UTF16String Text);
Parameters 
Description 
const aRow: integer 
Row for the cell (1 based) 
const aCol: integer 
Column for the cell (1 based) 
const Text: UTF16String 
Text you want to enter. If you write "=" as first character and the text is a valid Excel formula, it will enter the formula. 

This procedure sets the cell value to the Text parameter. It will try to convert the text to a date, to a number or a boolean, and if it can it will enter the correct datatype. If it can't make a conversion, it will enter the string into the cell. 

 

This is equivalent to calling SetCellString on the FlexCelImport attached to the grid, but will also convert any string starting with "=" to a formula. 

 

Copyright (c) 2002-2008 TMS Software. All rights reserved.
What do you think about this topic? Send feedback!