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

--- Comment #5 from Stéphane Guillou (stragu) 
<stephane.guil...@libreoffice.org> ---
The issue was brought up before on Ask.LO, where Eike already commented on
it[1].
He explained there that MS Excel allows negative values even though both the MS
documentation[2] and the OOXML specification[3] say it is not allowed.

Closing as "not our bug" (see even MS Office users reporting it[4]), but it
would be good to have it mentioned in our documentation.[5]

[1]:
https://ask.libreoffice.org/t/calc-offset-function-works-may-give-different-result-than-excel-equivalent/24859/5?u=stragu
[2]:
https://support.microsoft.com/en-us/office/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66
[3]: ECMA-376-1:2016 section 18.17.7.245, see
https://ecma-international.org/publications-and-standards/standards/ecma-376/
[4]:
https://answers.microsoft.com/en-us/msoffice/forum/all/offset-bug-negative-height-argument/dc24aca4-b77c-e011-9b4b-68b599b31bf5
[5]: https://wiki.documentfoundation.org/Documentation/Calc_Functions/OFFSET

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to