Formulae: Field/Cell direct access functions CELL, etc. (2.8+)

steve — Tue, 17 Jul 2012 09:56:49 -0400

These 4 new formula functions allow you to access arbitrary cells in the data. Also available in scripting.

CELL
FIELDCOUNT
FIELDNAME
FIELDNUMBER

Formula examples to obtain cell values

CELL([Price], 53)

CELL(FIELDNAME(3), CURRENTROW()-1)

Javascript preprocessing example to list all field values


for (n = 1; n<=fieldCount(); n++) {
  out.println(fieldName(n)+": "+cell(fieldName(n), 1)+"
");
}

Formula: Referencing same-field cells

alexhoward — Thu, 29 Sep 2011 16:16:57 -0400

Within a formula, having a way to reference cells in the same field in a continuous fashion. In other words, a formula where I can, say, add row 1 to the formula in row 2. Then add row 2 to the formula in row 3, etc., etc. You can do this in Excel just by referencing the cell you want and dragging the formula down the column. I’m attaching an Excel example to help clarify what I’m talking about.

Also, thank you for the SCRIPT idea. Could you please post an example formula with a script that could help get me started writing one?

Thanks

Tagged with cells - Visokio Forums

Formulae: Field/Cell direct access functions CELL, etc. (2.8+)

Formula: Referencing same-field cells