Public bug reported: In Calc: Situation: cell A1 has a number typed in as text w apostrophe beginning such as '123 This cell gives diffenrent results in functions. SUM(A1) gives zero answer, but =A1 gives a value of 123.
This can be misleading, especially when the apostrophe is not shown on the sheet. I suggest the numerical functions always try first to convert text to numbers. Version info: OpenOffice.org 3.2.0 OOO320m12 (Build:9483) ooo-build 3.2.1.10, Debian 1:3.2.0-7ubuntu4.2. Wed jan 26 22:22:24 UTC 20..... ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New -- 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