[Libreoffice-bugs] [Bug 141669] The MID function would be simpler if, like LEFT or RIGHT, it dosen´t need the last parameter when it's 1.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
MID() is *specified* to take 3 mandatory parameters, see ODFF v1.3 6.20.15 MID
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs02/part4-formula/OpenDocument-v1.3-cs02-part4-formula.html#MID
That third parameter is also expected by other spreadsheet implementations so
would have to be written anyway.

It's a rather arbitrary use case that only one character would be obtained by
MID() that would justify a default handling and automatically adding a third
argument of 1.

-- 
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/20210413/e6a9b978/attachment.htm>