[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]