Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||The table editor displays numeric and decimal numbers as doubles|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||ACCEPTED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description andrew 2005-10-10 19:54:48 UTC
I tested using 2.0RC2 on Windows XP Professional. I created Numeric and Decimal fields that can display 50 characters with four decimal places of accuracy. If I open the table for editing in the GUI and enter the value 1234567890123456789, the displayed and stored value is 1234567890123460000.0000. I can set the value using SQL oResultSet = oStatement.executeQuery("update ""Numbers"" Set ""Number2""=1234567890123456789.1234 Where ID=3") I can now retrieve the value 1234567890123456789.1234 using SQL, but this still displays as 1234567890123460000.0000, even in the query designer.
Comment 1 andrew 2005-10-10 22:05:49 UTC
Created attachment 30294 [details] Look at the NUM table, row with ID=0 for an example.
Comment 2 marc.neumann 2005-10-11 10:08:15 UTC
Hi, I can reproduce this. Reassign to the right developer and set target. Bye Marc
Comment 3 ocke.janssen 2005-10-11 13:43:42 UTC
Is a problem of the formatted field. Thanks for take care of this one. PS: The same happens in calc
Comment 4 Frank Schönheit 2005-10-11 14:53:21 UTC
A lot of the infrastructure of entering data here uses |double| values, which unfortunately cannot lossless carry a number such as 1234567890123456789. (side note: Calc in parts uses the same infrastructure - try entering the same value into a Calc cell, you will note that it's also truncated) Changing this is possible, but pretty risky, and certainly not reasonably possible in the 2.0.1 time frame.