[Libreoffice-bugs] [Bug 137932] FILEOPEN: opening csv file in calc does not preserve cents "00" formatting ($99.00 becomes $99)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Dec 4 12:59:11 UTC 2020


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

--- Comment #2 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Please post here.

>If inporting a csv file containing a money field, say  5.00, the resulting field >in calc will display 5.
>It can be manually adjusted, but the manual adjustment prevents full automation.
>If not a bug, perhaps an enhancement request?
What manual adjustment do you do?
Only the format needs to be adjusted, zeroes after the dot and the last
significant number are not saved in the cell. Maybe using styles could be easy
to do it.

-- 
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/20201204/83a46496/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list