On Sat, 2005-02-05 at 08:00 -0700, Doug Thompson wrote: > G. Roderick Singleton wrote: > > On Fri, 2005-02-04 at 23:22 -0600, Peter Kupfer wrote: > > > >>javier wrote: > >> > >>>I'm stuck with quite a stupid question. > >>> > >>>I'm working in writer with a table with calculations. I wan't a cell to > >>>display a value only if it's positive and 0 when the value is negative. > >>>In calc, this formula work all right: > >>> > >>>=IF(A1>A2;A1-A2;0) > >>> > >>>but in writer > >>> > >>>=IF(<A1>><A2>;<A1>-<A2>;0) > >>> > >>>doesn't work. It always return the failed result (0). And the reverse > >>>condition <A1><<A2> can't be checked (it returns an error, probably it > >>>sees the "<" sign as the start of a cell reference). > >>> > >>>Any idea of a workaround? > >>>Should I file an Issue?. > >> > >>Try =IF(<A1>g<A2>;<A1>-<A2>;0) > >> > >>The g is the writer table command for greater than. This was listed in > >>the help. You may want to check there in the future. Search for "greater > >>table" than click *formula*. This will also get you a list of all of the > >>Writer table functions. > >> > >>Also, if you press *F2* while in a table cell, you will get the formula > >>bar. > >> > >>However, I don't see any reference in the help for the IF statement. > >> > > > > > > In preparing the user guide, I din not find any reference to IF either > > when dealing with tables or fields. The IF is implied by braketing. Sort > > of like using brackets in /bin/sh to show the use of test(). > > As most current and potential users of OOo are not programmers, the > "implied IF" needs to be carefully explained in the Help files and the > Users Guide. > My $0.02, > Doug >
Please write it up and attach it to http://www.openoffice.org/issues/show_bug.cgi?id=29679 I will integrate it as soon as I get your contribution. -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
