https://bz.apache.org/ooo/show_bug.cgi?id=126746
Issue ID: 126746 Issue Type: DEFECT Summary: Mid only calculates whole numbers Product: Calc Version: 4.1.2 Hardware: PC OS: Windows 10 Status: UNCONFIRMED Severity: Normal Priority: P5 (lowest) Component: editing Assignee: issues@openoffice.apache.org Reporter: mttech...@gmail.com =MID("0230";2;2)/10 will produce 2.3 =MID("023.00";2;4)/10 will produce #VALUE! Conversions are made for whole numbers. I noticed, in other issue reports, that the reason that this type of error was 'not an issue' was because the mid function returns only text, but the example above shows that the mid function does have the ability to do a conversion Wrapping the mid function with the VALUE function will correct the second situation -- You are receiving this mail because: You are the assignee for the issue.