[Libreoffice-bugs] [Bug 123436] Allow CSV numeric fields to be defined as numeric or currency, not just text

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Feb 13 19:48:09 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=123436

--- Comment #3 from Lora  Saltis <lora_saltis at yahoo.com> ---
 I am imported a CSV file from my credit union into a LIBRE Office spreadsheet
to work with the data for tax purposed which requires me to Sort and Sum
various transactions for tax reporting. The currency fields of the CSV file are
treated like text strings with a "'$" leading very number.For example:'$500.00
as a text string of characters instead of being able to define it as a numeric
or currency field 500.00 which has an arithmetic value and can be calculated.

I'm not sure its a database issue.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190213/a6bc0e2a/attachment-0001.html>


More information about the Libreoffice-bugs mailing list