Created attachment 191658 [details] 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".
Created attachment 191659 [details] Have a look at the different decimal places for integer and decimal numbers
I test creating a new table and the issue is reproducible. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0f6f5048d223731aa52b768a77244d0208711391 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Fixed by a245fd604c11f4bdbd1fdc4dd52e2a7f3880d85b (tdf#156530: fix OPreparedStatement::setString).