On Tue, Mar 10, 2009 at 12:40 AM, JOE Conner <[email protected]>wrote:
> Joe Smith wrote: > > > <snip> > > > >> 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 Joe and Joe: Just my two cents: 1) If you've used languages like C, C++, Perl, Java, Javascript, etc., you should have no problem with using semicolons as statement separators. Excel uses its own convention, which OOo does not follow. 2) If you choose to use a non-standard port like OxygenOffice, why are you complaining to the OpenOffice user list? If OxygenOffice wants to change the OpenOffice convention, it is free to do so, but it should provide its own help files to document the changes. John
