https://bugs.documentfoundation.org/show_bug.cgi?id=119033
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|medium |low
Severity|minor |trivial
--- Comment #4 from Eike Rathke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
