Sorry, withdraw this. It seems to be a feature rather than a bug: Excel, Google and Lotus Sympony all do the same. The documentation on operator precedence is incomplete and incorrect as far as it goes, but it appears that by design the unary minus takes precedence over exponentiation takes precedence over subtraction. That is, -A1^2 is interpreted as (-A1)^2 (unary minus) but 0-A1^2 is interpreted as 0-(A1^2) (subtraction). This is bizarre in comparison to mathematical notation, and no doubt leads to lots of wrong spreadsheets, but if that is how it is supposed to work then there is no bug.
-- Calculation error: calc ignores - sign in some formulas https://bugs.launchpad.net/bugs/460549 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
