https://issues.apache.org/ooo/show_bug.cgi?id=126052
Issue ID: 126052
Issue Type: DEFECT
Summary: Calc: Scientific notation imported as text, unless
"special numbers" is checked
Product: Calc
Version: 4.1.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Created attachment 84442
--> https://issues.apache.org/ooo/attachment.cgi?id=84442&action=edit
Screenshot from Calc after import
Using the Danish version of AOO 4.1.1 I open a csv-file with just the following
contents (three lines with one number on each line):
5.49
5.49E0
5.49E-2
Calc asks me what locale should be used for the import, and I choose "English
(USA)". However, only the first number (5.49) is imported as a number, while
the two numbers in scientific notation (5.49E0 and 5.49E-2) are imported as
text.
I have found that if I tick "Detect special numbers", all three numbers are
imported as numbers. Still, I would consider this a bug. To me, "special
numbers" are numbers like NaN (not a number) or inf (infinity), not scientific
notation.
My AOO is the Danish brand. I have not tried other language versions.
The attached snip of a screenshot shows the result after import, with the
"Highlight values" (Ctrl+F8) feature turned on. Only 5.49 are in blue and
right-formatted as a number (shown as "5,49" because Danish use comma as
decimal point).
I am aware that this report have similarities with the closed issue 115683
But I am already using the language setting suggested in the responses to that
issue.
Best regards
Lars
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
