Cell location in spreadsheet
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
backprop · 2024-09-08 20:33

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 · 2024-09-08 21:38

Take a look at unit fpsutils. It contains a lot of Parse* functions,
e.g. Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  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][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i 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.