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