[Bug 122728] New: TEXT function in languages using comma as a decimal separator is not imported properly

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=122728

            Bug ID: 122728
        Issue Type: DEFECT
           Summary: TEXT function in languages using comma as a decimal
                    separator is not imported properly
           Product: Calc
           Version: AOO 3.4.1
          Hardware: All
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: valmorildogoulart@gmail.com
                CC: issues@openoffice.apache.org

If a Microsoft Office spreadsheet has two cells:
A1
=TEXT(A2;"0,0")
A2
15,4

I think 15,4 in A2 cell is converted properly to 15.4; however, A1 cell was
broken until it was edited to replace the comma with a decimal point. It seems
that Microsoft Office spreadsheets store the formula using the formatting of
the language used in it; if 4/10 is stored as 0,4 the TEXT function will also
operate with a comma.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 122728] TEXT function in languages using comma as a decimal separator is not imported properly

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=122728

--- Comment #1 from Valmor Ildo Goulart <va...@gmail.com> ---
Created attachment 81073
  --> https://issues.apache.org/ooo/attachment.cgi?id=81073&action=edit
Cell A1 has a formula with a comma; cell B1 has the value converted.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 122728] TEXT function in languages using comma as a decimal separator is not imported properly

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=122728

Edwin Sharp <el...@mail-page.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |elish@mail-page.com
         Resolution|---                         |NOTABUG

--- Comment #2 from Edwin Sharp <el...@mail-page.com> ---
TEXT function returns correct value according to setting in:
Tools - Options... - Language Settings - Languages - Language of - Decimal
separator key

Rev. 1502185 Win 7

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.