[Libreoffice-bugs] [Bug 122909] V 6.0.7 or earlier: After opening a CSV file in Cal, all cells appear to be text, but cannot Format $xx.xx Cells to US Currency

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is normal, and indicates that you haven't set import options such that it
would detect special numbers (like currency). You either need to select proper
options at import (first of them is the said "Detect special numbers", and it
might be also necessary to tweak columns if their formatting does not conform
to your locale's conventions), or after such import, when all the data is text,
use Data->Text to Columns. *Formatting* already existing data will never change
its data type, and only can alter visual representation (if applicable).

See also this FAQ:
https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data
(there another way to convert is explained, using Find & Replace, but
personally I prefer Data->Text to Columns).

Closing NOTABUG.

-- 
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/20190123/f6d10491/attachment-0001.html>