[Issue 126821] New: text import wizard fails to detect currency ($) by default

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126821

          Issue ID: 126821
        Issue Type: DEFECT
           Summary: text import wizard fails to detect currency ($) by
                    default
           Product: Calc
           Version: 4.1.0
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: richardbrucebaxter@hotmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126821] text import wizard fails to detect currency ($) by default

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126821

--- Comment #1 from richardbaxter <ri...@hotmail.com> ---
See also; https://bz.apache.org/ooo/show_bug.cgi?id=126052

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

-- 
You are receiving this mail because:
You are the assignee for the issue.