Issue 126821 - text import wizard fails to detect currency ($) by default
Summary: text import wizard fails to detect currency ($) by default
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.0
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2016-02-04 00:41 UTC by richardbaxter
Modified: 2016-02-04 00:52 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description richardbaxter 2016-02-04 00:41:30 UTC
The text import wizard fails to detect currency ($ entries) by default.

It is not obvious that plain text containing two or more dollar entries e.g. "$1000\n$2000" can't be imported into an OO calc spreadsheet and their format properly detected (Currency/Number) without selecting "Detect special numbers". When importing such text by default (ie without selecting "Detect special numbers"), the text is interpreted by the import wizard as "Number" and a text delimiter is applied (ie "`$1000", "`$2000"). This makes it a) confusing for a standard user, and b) very difficult to change to the correct format.

Note I have added this issue based on past experience and comment #3 by dcl12 in
Comment 1 richardbaxter 2016-02-04 00:52:42 UTC
See also;

(It is not evident that currency is a special number).