[Issue 126746] New: Mid only calculates whole numbers

[bu...@apache.org]

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: mttech815@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.

[Issue 126746] Mid only calculates whole numbers

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126746

bmarcelly <ma...@club-internet.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |marcelly@club-internet.fr

--- Comment #1 from bmarcelly <ma...@club-internet.fr> ---
It is not a problem of MID() function. You have the same problem with
="123"/10    OK
="123.4"/10  #VALUE!

The reason is that converting a string containing an Integer is not ambiguous.
Converting a string containing a dot or a comma is ambiguous since its
interpretation depends on the locale of the user.
Having such formulas is incorrect.

Conclusion : not an issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.