https://bugs.freedesktop.org/show_bug.cgi?id=87834
--- Comment #10 from Michael Büssow <michael.bues...@gmx.de> --- Julian: I just tested the mid()-function under MS Excel (Version 2003; but the vb description shows the same): In VB mid(text, start [,count]) there are the following cases: 1) if count is <0 then error 2) if start is <1 then error 3) if count=0 or start>length(text) then "" (empty string) 4) if start+count>length(text) then as if count isn't used In my eyes the problem in Calc is the result string "!!br0ken!!". So I would prefer (additional to the current state): A1) if start>length(text) then "" (as in Calc version 3.x) A2) if start<1 then error message (instead of "only" if start=0) In the last case (start<1) we can discuss, if it would make more sense to set start=1 or set the result to "" to avoid any error message. (The case with start=0 is a little bit confusing in ODF. There should be no error, but what should be the result, because the counting of letter begins with 1 as fas as I know ...) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs