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