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: [email protected]
Reporter: [email protected]
=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.
