https://bugs.documentfoundation.org/show_bug.cgi?id=98942
Bug ID: 98942
Summary: =sum() does not work with =fixed()
Product: LibreOffice
Version: 5.1.1.2 rc
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 123907
--> https://bugs.documentfoundation.org/attachment.cgi?id=123907&action=edit
bug is shown by example
The summation =sum() does not work combined with the =fixed() function. It
works fine for normal numbers.
When =fixed() is used to give a number with a fixed amount of decimals, the
=sum() function does not recognize the number anymore and does not sum it up.
The strange part is that adding the fixed numbers DOES work and give a good
result.
So in case A1 to A3 are =fixed(1,2), this results in =A1+A2+A3 equals 3,
whereas =sum(A1:A3) equals 0.
see example file.
--
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
