OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office] Data Grid Size element proposal

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. Behavior is the same in Excel.

> > I personally find OO.o's behavior in this situation much more helpful
> > than magically wrapping the references.
> silently changing the content of what is being copied?
> I guess I could have thought of that: if OOo doesn't do X why would
> anyone want X?!

Got out of bed on the wrong side?


 OpenOffice.org / StarOffice Calc core developer and i18n transpositionizer.
 SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9 F9B5 87F8 D412
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]