On 04/08/2009 05:05 AM, H.S.Rai wrote: > On Wed, Apr 8, 2009 at 8:02 AM, JOE Conner <[email protected]> wrote: >>> >>> Helpfile says that arguments of a function like if and round need to >>> be separated by ";", but that gives error and in place of that "," is >>> working fine. >>> >>> Why is it so? >>> >>> Using OO 3.01 on Ubuntu. >>> >> >> Are you by chance using Go-OO or OxygenOffice? They have ported field >> separation to commas, but did not change the help files to reflect it. I >> got caught up in this last month. > > That might be. > > http://go-oo.org/download/ has following mention: > > Debian provides Go-OO in their repositories. To install it just type as > root > # apt-get install openoffice.org > > Ubuntu provides Go-OO in their repositories. To install it just type as > root > # apt-get install openoffice.org > > Does not it make files incompatible from this socalled openoffice and > real openoffice. >
Actually it does. Ubuntu need to fix their documentation as they copied it directly from OOo without modifying to show the ',' use rather than the ';' use. The following help section is identical in both OOo 3.0.1 and OOo(U) 3.0.1: ==== OR Returns TRUE if at least one argument is TRUE. This function returns the value FALSE, if all the arguments have the logical value FALSE. The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values. When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula. If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE! Syntax OR(LogicalValue1; LogicalValue2 ...LogicalValue30) LogicalValue1; LogicalValue2 ...LogicalValue30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row. Example The logical values of entries 12<11; 13>22, and 45=45 are to be checked. =OR(12<11;13>22;45=45) returns TRUE. =OR(FALSE;TRUE) returns TRUE. ==== Using a simple test case in by copying directly from the help file in both: OOo: =OR(FALSE;TRUE) results in 'TRUE'. OOo(U) =OR(FALSE;TRUE) results in 'Err:508' Only when modified to use =OR(FALSE,TRUE) does it work. You should file a bug report here: https://launchpad.net/ubuntu/+source/openoffice.org/+bugs My _guess_ is that the go-oo branch modified to ',' to appease the Windows Excel users; I think if you google long enough or check the bug reports long enough you'll find a history somewhere. If they are going to do that, then they also need to spend the time to correct their documentation to reflect the same. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
