← Prev in month ← Prev in thread

ADDRESS needs to support A1/R1C1 notation

From
Eike Rathke <>
Date
2007-03-05T17:53:23+00:00
ID
Thread
ADDRESS needs to support A1/R1C1 notation
Hi,

Our current ADDRESS definition has the syntax

ADDRESS( Integer row ; Integer column [ ; Integer abs = 4 [ ; Text sheet ] ] )

For interoperability with applications that support the R1C1 addressing
style we need the syntax where the notation (A1/R1C1) to be used can be
specified. That doesn't fit together with the current definition because
a parameter is inserted in between. I checked with Kspread, Gnumeric and
Excel, and the only application not supporting that syntax is OOo.
However, it will in future. So I propose to change the syntax to

ADDRESS( Integer row ; Integer column [ ; Integer abs = 4 [ ; Logical a1 = TRUE() [ ; Text sheet ] ] ] )

Objections?

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.
← Prev in month ← Prev in thread