https://bugs.freedesktop.org/show_bug.cgi?id=71459
Priority: medium
Bug ID: 71459
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: No easy way to subtract two numbers (without
snap-to-zero)
Severity: normal
Classification: Unclassified
OS: All
Reporter: te...@gnome.org
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
A1=COMBIN(15,9)
A2=5005
A3=A1-A2
This produces a zero in A3, which would be correct if COMBIN actually
worked and produced 5005. COMBIN doesn't, so 0 is wrong.
A4=A1+1-A2-1
--> 9.09494701772928E-013
I understand what is happening in A3: "-" in LO does not perform IEEE 754
subtraction. It performs what can be described as snap_to_zero(A1 minus A2)
where that "minus" is IEEE 754 subtraction. I even understand the political
reasons why snap_to_zero is in place.
What I am lacking is the ability to just subtract (compare, etc.) two
numbers, i.e., answer the question "does A1 contain 5005?" Maybe that
is a RAWSUBTRACT function, maybe something else. How do you test
whether functions like COMBIN actually work without that ability?
FWIW, in Excel adding a parenthesis around the subtraction is enough to
get raw subtraction because the snap-to-zero behaviour is only used for
subtraction at the top-most level. (I think -- it might be more complicated
than that.)
Oh, and someone needs to fix COMBIN.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
