Joe Smith wrote:
JOE Conner wrote:
... It seems to me that the Open Document format specifications
should have nailed the format down precisely. Otherwise, the
document can not fully portable.
The ODF Formula specification specifies the semicolon as the function
argument separator.
However, the syntax specification only applies to the formula text
that is stored in the document file. The application is free to use
any character it wants, as long as it turns into a semicolon in the
document file.
I must admit, it took me a looong time to get used to typing
semicolons instead of commas, like every other function syntax I've
ever used. I still find myself tripping over it.
I would be very happy to see OOo accept commas in the user interface
when the effective locale would allow it, but it strikes me as opening
a Pandora's box of complexity and bugs.
<Joe
Partly my grief with commas in OxygenOffice is that the accompanying
help files for formulas do not show commas but rather have semicolons.
That is why =IF( ISNUMBER(A1) , IF( A1=0 , "" , A1) , "")
works, where =IF( ISNUMBER(A1) ; IF( A1=0 ; "" ; A1) ; "")
fails and is in compliance with IF function help files and ISNUMBER help
files.
Joe Conner, Poulsbo WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
