Cell location in spreadsheet

[backprop]

How to find location of the cell by given row and col?

For instance DF2 is (107,1), if I do not mistaking.

I have very large and dynamically created table which should at end have SUM formula. In formula need to be entered range of cells in spreadsheet, not fixed location known by application.

[wp]

Take a look at unit fpsutils. It contains a lot of Parse* functions, e.g.

Code: Pascal  [Select][+][-]

1.  function ParseCellString(const AStr: string; out ACellRow, ACellCol: Cardinal): Boolean;

for conversion between string addresses (e.g. "A1") to row/col indices (row=0, col=0). Or the opposite direction, e.g.:

Code: Pascal  [Select][+][-]

1. function GetCellString(ARow,ACol: Cardinal; AFlags: TsRelFlags = [rfRelRow, rfRelCol]): String;

The AFlags indicate whether the cell address is relative or absolute (i.e. includes a '$').

There are also conversion functions for the OpenDocument and the R1C1 syntax.