money fields with zero trailing cent values (00) are dropped. 9.00 becomes 9 9.20 becomes 9.2
Non-significant zeroes to the right are not preserved in the cell, on importing, entering the value with the keyboard, or pasting. You can modify the cell format to show it properly. https://help.libreoffice.org/latest/en-US/text/scalc/01/05020000.html?DbPAR=CALC#bm_id3148663
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.