Ask Your Question

LibreOffice Base - Table - Column Format - Currency - Won't register decimal correctly

asked 2017-09-04 02:50:54 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I use this format for payment.value column = [$RM-43E]#,##0.00;[RED]-[$RM-43E]#,##0.00

I have set the decimal place to be 2.

I have entered value of $297.67. But LibreOffice Base automatically records as only $297.00.

My database shall not be correct. An unaccountable amount of $0.67 has not been registered should a query report is made.

Please help me with a solution.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-04 05:08:54 +0200

Ratslinger gravatar image

The format for a field in a table has nothing to do with how it is stored. You must have the correct Field Type, Length, and Decimal places defined and the saved amount will be correct:

image description

If you have an incorrect field type (such as Integer) or the number of decimals in Field Properties is not set correctly, no matter what format you use it will not work.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-04 02:50:54 +0200

Seen: 783 times

Last updated: Sep 04 '17