[Libreoffice-bugs] [Bug 119033] ADDRESS function >> result of calculation is displayed instead of #VALUE! error if "ABS" argument is value in range from 5 to 8

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|medium                      |low
           Severity|minor                       |trivial

--- Comment #4 from Eike Rathke <erack at redhat.com> ---
The cases 5,6,7,8 are explicitly handled as synonyms for 1,2,3,4 at
https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr1.cxx#8089

I guess that is for some compatibility with another spreadsheet application.

Excel documentation
https://support.office.com/en-US/article/ADDRESS-function-D0C26C0D-3991-446B-8DE4-AB46431D4F89
doesn't mention these values either, but maybe it handles them or earlier
versions did such thing?

The code is in since the early (then deactivated) prototype of 2006 commit
6aadb208c71286cf4fcbaf7c611c45fd2e0c6c92

FWIW, Gnumeric handles this the same but also documents only 1,2,3,4. (not
really a surprise considering the author of the OOo prototype code was Jody ;-)

-- 
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/20180815/998b0a2b/attachment-0001.html>