https://bugs.documentfoundation.org/show_bug.cgi?id=172698
Bug ID: 172698
Summary: Text Import Dialog fails to parse currency symbols ($)
into numbers despite "Detect special numbers" and
matching Locale being selected in this case as English
Australia Cells get pasted as Text instead of numbers.
Last used 1 year ago it used to work.
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Text Import Dialog used on MYOB's output report file created as Tab Limited
Text File fails to parse fields with currency symbols ($) into numbers despite
"Detect special numbers" and matching Locale being selected in this case as
English Australia. Cells get pasted as Text instead of numbers. Last used 1
year ago it used to work. The input file cells with a $ prefix were correctly
evaluated as numbers, and the resultant output file cells in LibreOffice Calc
were not only stripped of the $ symbols but the ISNUMBER test on them showed
TRUE. Now it shows FALSE.
--
You are receiving this mail because:
You are the assignee for the bug.
