https://bugs.documentfoundation.org/show_bug.cgi?id=99732
Bug ID: 99732
Summary: sum('123) = 0 wrong answer without warning
Product: LibreOffice
Version: 5.1.2.2 release
Hardware: Other
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 124913
--> https://bugs.documentfoundation.org/attachment.cgi?id=124913&action=edit
LOcalc sum function treats apparent numbers as 0 if storage is not numeric
c7 = number
c8 displays as a number but is not
c7+c7 gives the anticipated answer
sum(c7:c8) treats c8 as 0 and gives a wrong answer without warning.
Sometimes but not always, I see a single quote (') preceding the "number". In
the attached, I could not see how to fix this problem.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
