Re: [office-formula] ADDRESS needs to support A1/R1C1 notation

From
David A. Wheeler <>
Date
2007-03-06T18:05:28+00:00
ID
Thread
Re: [office-formula] ADDRESS needs to support A1/R1C1 notation
Eike Rathke:
> 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?

Sounds great!  I presume you'll make those changes, unless you tell us otherwise.  (I want to make sure only ONE of us makes edits to the same section, if I can help it...!).

--- David A. Wheeler