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
