Accessing a cell
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
MM38 · 2015-09-15 15:15

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 · 2015-09-15 17:09

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.