https://bugs.documentfoundation.org/show_bug.cgi?id=97451
Bug ID: 97451
Summary: All sum calculations return a "0"
Product: LibreOffice
Version: 5.0.0.4 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 122287
--> https://bugs.documentfoundation.org/attachment.cgi?id=122287&action=edit
Sum function not working
All of a sudden the sum of any range, even a simple one like A1:A2 with a "1" &
"0" in the cells returns a zero. It seems to happen when there are formulas in
the range that are returning the numbers I am try to sum. I am set to
autocalculate in Tools/Cell contents, and have tried changing cell formatting
all different ways. there are no errors in any of the cells in that range or
the cells they refer to. the only workaround I have is to type out each cell in
the range with a "+" inbetween. very tedious. Now as I'm preparing a sample
sheet for you =IF(OR(ISNUMBER has stopped working and is returning a zero when
it should be a one. Please help I spent a lot of time on this sheet.
--
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
