Ask Your Question

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-14 16:14:46.661095

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

Question Tools

1 follower


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

Seen: 1,410 times

Last updated: Sep 04 '17