https://bugs.documentfoundation.org/show_bug.cgi?id=149627
Bug ID: 149627
Summary: MID(cell,start) gives error 'Err:511'
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: j...@curioussymbols.com
Description:
According to the documentation, MID(cell,start) is supposed to give the
contents of a string from position `start` until the end of the string.
Documentation link:
https://help.libreoffice.org/7.2/lo/text/sbasic/shared/03120306.html
However, using MID in this way gives an error.
The error can be resolved by providing the third argument, eg
MID(cell,start,999)
works without error.
Steps to Reproduce:
1. Enter 'HELLO WORLD' in A1
2. Enter '=MID(A1,7)' in A2
Actual Results:
Err:511 is dispayed cell A2
Expected Results:
Expect to see 'WORLD' in A2
Reproducible: Always
User Profile Reset: No
Additional Info:
Replace A2 with '=MID(A1,7,999)' and the expected text appears.
I tried this with both 7.2.7.2 and 7.2.6.2, on two different Ubuntu machines
(18.04 and 20.04). I did not have access to a 7.3 release, so it would be good
if someone else could check that one.
--
You are receiving this mail because:
You are the assignee for the bug.
