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.