Jukka Lind, the reason why one gets 0=SUM(A1) when A1='123 is to hold compatibility expectations with Excel, as it does the same. Please feel free to report any further bugs you may find.
** Changed in: openoffice.org (Ubuntu) Status: New => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/809888 Title: Calc:Some functions treat '5 as a number, some don't To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/809888/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs