Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||text import wizard fails to detect currency ($) by default|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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.