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: libreoffice-bugs@lists.freedesktop.org Reporter: rob...@familiegrosskopf.de 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.