[Libreoffice-bugs] [Bug 94962] The RSQ function returning values greater than one.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=94962

Andreas Heinisch <andreas.heinisch at yahoo.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |andreas.heinisch at yahoo.de

--- Comment #7 from Andreas Heinisch <andreas.heinisch at yahoo.de> ---
I investigate the error and the problem arises during the calculation of the
final result, because the involved numbers are close to zero and below the
numerical limit of LO.

There are two ways in order to solve this issue. Either, if the involved
numbers are below the numerical limit, just show a division by zero error, or
set them to the numerical limit.

In the second case, the attached example would lead to:
RSQ Top
3,4504615480428E-15
RSQ Bottom
2,5975708894356E-14

Excel shows a division by zero error.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210413/e77e589b/attachment.htm>