https://bugs.freedesktop.org/show_bug.cgi?id=50077
A (Andy) <stgohi-lob...@yahoo.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |stgohi-lob...@yahoo.de --- Comment #5 from A (Andy) <stgohi-lob...@yahoo.de> --- Reproducible with LO 4.4.0.0.beta1 and 4.3.4.1 (Win 8.1). But the MID function is a text function (https://help.libreoffice.org/Calc/Text_Functions). It extracts a text string out of a text and therefore the result is a text (LO Help: "Returns a text string of a text.": https://help.libreoffice.org/Calc/Text_Functions#MID). Therefore, I would mark it not as a bug. I thought about where there could maybe be a need to extract a number out of a larger number or text and I could there maybe think of a Personal ID Code or other generated codes where you need to extract a number. In this respect it is interesting to see, that LO can already calculate with the text string result and if you add a number calculates a correct sum/number. Therefore, I would mark it is an enhancement request that either the MID function can also return a number as one further feature or implement a further similiar function that returns a number. -- 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