https://bugs.documentfoundation.org/show_bug.cgi?id=158935
Bug ID: 158935
Summary: Firebird: Decimal numbers add one decimal place, if
input are integer values.
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 191658
--> https://bugs.documentfoundation.org/attachment.cgi?id=191658&action=edit
Open the database file and execute SELECT * FROM "tbl_One" in Tools → SQL
Open the attached database.
Go to Tools → SQL.
Start
SELECT * FROM "tbl_One"
and let show the output.
It will show for fields with 2 decimal places values like
1.000, 2.000, 10.000, 20.000
It will show the right decimal places for
1.10, 2.10, 10.10, 20.10
Screenshot will show the behavior also.
Query in the database file will show how many decimal places have been defined.
If you connect a subform with a form and use a numeric field with decimal
places the connection wont work. When refreshing the subform all data input
will disappear, because the connection will look, for example, for 2 decimal
places while there appear 3 places as entry in the subform.
SO this behavior with wrong decimal places isn't only "cosmetical".
--
You are receiving this mail because:
You are the assignee for the bug.
