https://bugs.freedesktop.org/show_bug.cgi?id=64132
Priority: medium
Bug ID: 64132
Assignee: [email protected]
Summary: Calc string-number coercion
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.5.4 release
Component: Spreadsheet
Product: LibreOffice
In calc, a formula like sum(a1:a3) applied to cells which contain a string
results in the string being coerced to 0. However, if the the string contains a
number, this coercion is incorrect.
This *is* a bug, since the correct behaviour would be to signal an error
indicating the formula has been applied to invalid inputs.
This bug bit when copying numbers from one program into libreoffice/calc. One
of the numbers was read as a string by calc, and the resulting column tally was
off by ~$400. This wasn't noticed til it was too late...
---
Btw, I discovered after the fact that View->Value Highlighting provides a way
to diagnose problems with string->0 coercion.
---
Here is a simple example:
a1: "I am not a number"
a2: =sum(a1:a1)
This may be related to
https://bugs.freedesktop.org/show_bug.cgi?id=59309
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
