Issue 55740

Summary: The table editor displays numeric and decimal numbers as doubles
Product: Base Reporter: andrew
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Look at the NUM table, row with ID=0 for an example. none

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

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.
Comment 5 Marcus 2017-05-20 10:44:41 UTC
Reset the assignee to the default "".