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

From
Andreas J. Guelzow <>
Date
2007-03-05T18:30:24+00:00
ID
Thread
Re: [office-formula] ADDRESS needs to support A1/R1C1 notation
On Mon, 2007-05-03 at 18:53 +0100, Eike Rathke wrote:
> 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?

I think that is a good idea!

Andreas

> 
-- 
Andreas J. Guelzow, Professor
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta