Thank you for taking the time to report this issue and helping to make
Ubuntu better. Examining the information you have given us, this does
not appear to be a bug report so we are closing it and converting it to
a question in the support tracker. We appreciate the difficulties you
are facing, but it would make more sense to raise problems you are
having in the support tracker at https://answers.launchpad.net/ubuntu if
you are uncertain if they are bugs. For help on reporting bugs, see
https://help.ubuntu.com/community/ReportingBugs .
SOLUTION: OpenOffice has a slightly different syntax for the IF clause, you
should have written something like this instead:
=IF(sheet.cell = 0; ""; sheet.cell)
(Note, that I'm not using apostrophe (') and use ";" instead of comma)
** Changed in: openoffice.org (Ubuntu)
Status: New => Invalid
** bug changed to question:
https://answers.edge.launchpad.net/ubuntu/+source/openoffice.org/+question/31938
--
Formula error OpenOffice 2.4
https://bugs.launchpad.net/bugs/226154
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs