[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office] Data Grid Size element proposal
On Tue, 2008-12-02 at 13:41 +0100, Eike Rathke wrote: > Hi Andreas, > > On Monday, 2008-12-01 18:06:55 -0700, Andreas J. Guelzow wrote: > > > > OO.o 3.0 since it has more columns. > > > > > > A1..E1 contain 1..5. > > > AMJ is the last colume. > > > A2 is set to "=AMJ1" and copied to B2..E2. > > > > > > A1 = 0 and B1..E1 say "#REF!" and are set to "=REF!". > > > > So the users asked OOo to copy a formula and OOo silently changes the > > formula into an error string _without_alerting the user? > > The result displays #REF!, which is a standard error displayed for > references errors. My copy of OOo 3.0 does _not_ display #REF! just as a result but in fact it changes the formula entered to "=REF!". (If it just showed the result of #REF! I could go in and modify the reference. This way I cannot.) Note that OpenFormula draft requires that if the reference is beyond the capabilities of the application the reference should evaluate to REF! I ma wondering what OOo would do would it encounter this in a file and the file is being saved without user modification. Would it change the formula? Since the OpenFormula draft refers to capabilities (and not gridsize) I consider Gnumeric compliant with the draft in this respect (using a toroidal grid) while OOo is not. Andreas -- "Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own." Rousseau Prof. Dr. Andreas J. Guelzow Dept. of Mathematical & Computing Sciences Concordia University College of Alberta
This is a digitally signed message part
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]