[Libreoffice-bugs] [Bug 135934] New: Third argument to MID() should be optional for better Basic compatibility

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 135934
           Summary: Third argument to MID() should be optional for better
                    Basic compatibility
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: roy-orbison at devo.net.au

I have read
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#MID
and
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/mid-function

As far as I know, MS's version has always supported the third argument being
optional. This is very useful for getting the remainder of a string without
limit, especially in combination with other functions to remove prefixes. When
the argument is omitted, it is calculated as `Length = 1 + LEN(Text) - Start`.
Since it's required in LibreOffice, making it optional should be a
backwards-compatible change.

-- 
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/20200820/91f7059e/attachment.htm>