https://bugs.documentfoundation.org/show_bug.cgi?id=157948
Stéphane Guillou (stragu) changed:
What|Removed |Added
URL||https://ask.libreoffice.org
||/t/calc-offset-function-wor
||ks-may-give-different-resul
||t-than-excel-equivalent/248
||59
Blocks||108827
CC||stephane.guillou@libreoffic
||e.org
Status|UNCONFIRMED |RESOLVED
Summary|Offset function using |Offset function using
|negative numbers|negative numbers for height
||or width works in Microsoft
||Excel, not in Calc
Resolution|--- |NOTOURBUG
--- Comment #4 from Stéphane Guillou (stragu)
---
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[1] 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
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108827
[Bug 108827] [META] Calc functions bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.