Bug 135934 - Third argument to MID() should be optional for better Basic compatibility
Summary: Third argument to MID() should be optional for better Basic compatibility
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-08-20 06:32 UTC by Roy
Modified: 2020-08-21 00:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roy 2020-08-20 06:32:14 UTC 
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.
Comment 1 GerardF 2020-08-20 07:51:05 UTC 
You confuse spreadsheet function with macro function.

The lenght argument fot MID function is not optional in both Calc and Excel.
The basic function Mid in Calc and the vba function Mid in Excel have an optional lenght argument.
Comment 2 Roy 2020-08-21 00:07:08 UTC 
So this could be marked as a feature request rather than summarily closed, then?