Apache OpenOffice (AOO) Bugzilla – Issue 126821
text import wizard fails to detect currency ($) by default
Last modified: 2016-02-04 00:52:42 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.
See also; https://bz.apache.org/ooo/show_bug.cgi?id=126052 (It is not evident that currency is a special number).