Issue 126821

Summary: text import wizard fails to detect currency ($) by default
Product: Calc Reporter: richardbaxter <richardbrucebaxter>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest)    
Version: 4.1.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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 https://bz.apache.org/ooo/show_bug.cgi?id=125943.
Comment 1 richardbaxter 2016-02-04 00:52:42 UTC 
See also; https://bz.apache.org/ooo/show_bug.cgi?id=126052

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