[Libreoffice-bugs] [Bug 85551] LO Calc and MS Excel treat invalid OFFSET height and width parameters differently

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|Windows (All)               |All
           Hardware|x86-64 (AMD64)              |All
             Status|NEW                         |ASSIGNED
            Version|4.3.1.2 release             |Inherited From OOo
           Assignee|libreoffice-bugs at lists.free |erack at redhat.com
                   |desktop.org                 |

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
That MS support page meanwhile gives 404.

What does a current Excel actually do for negative height/width arguments? I'd
presume error because
https://support.office.com/en-US/article/OFFSET-function-C8DE19AE-DD79-4B9B-A14E-B4D906D11B66
says "must be a positive number" for both. 

That is congruent with ODFF
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/part4-formula/OpenDocument-v1.3-cs01-part4-formula.html#OFFSET
"Constraints: NewWidth > 0; NewHeight > 0".

So we should raise an 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/20200630/33840f04/attachment-0001.htm>