Accessing a cell

[MM38]

Hi
With TStringGrid, it 's possible to access directly to a cell with a ligne like

 Grid.Cells[Col,Row]:=ChaineTemp;

How can I do the same thing with FPSpreadsheet?  I want to to use tsworksheetgrid. On a web site, II saw a line
with a function writenumber(x,y,number). But it's a methode of  tsworksheet.
So Im lost !!!

Can you help me?

Thanks
 

[wp]

No, there is no "Cells" property in fpspreadsheet for historical reasons. In order to write a value (a number in the following example) you call the worksheet method

Code: [Select]

  myworksheet.WriteNumber(row, col, number);

which means "write the number into the cell at the specified row and column index". Different words but the same meaning as with the "Cells" of a grid...

In comparing with TStringGrid usage, you must be aware that row and column indexes are interchanged and - if the grid has fixed rows/columns - are offset by 1.