Bug 141669 - The MID function would be simpler if, like LEFT or RIGHT, it dosen´t need the last parameter when it's 1.
Summary: The MID function would be simpler if, like LEFT or RIGHT, it dosen´t need the...
Status: CLOSED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-13 08:09 UTC by Luís Mendes
Modified: 2021-04-13 09:18 UTC (History)
0 users

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 Luís Mendes 2021-04-13 08:09:01 UTC 
When I use LEFT(A1) I´ll get the first character on de the left of A1 cell. I would like to have the same simple response when if I use MID(A1,3) to get the only character on position 3 of A1 cell, instead of using MID(A1,3,1) as I have to do now. The formulas that pick several individual characters from a cell would become simpler. Thanks.
Comment 1 Eike Rathke 2021-04-13 09:18:15 UTC 
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.