Issue 55740 - The table editor displays numeric and decimal numbers as doubles
Summary: The table editor displays numeric and decimal numbers as doubles
Status: ACCEPTED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-10-10 19:54 UTC by andrew
Modified: 2017-05-20 10:44 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Look at the NUM table, row with ID=0 for an example. (113.55 KB, application/vnd.sun.xml.base)
2005-10-10 22:05 UTC, andrew 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.
Comment 5 Marcus 2017-05-20 10:44:41 UTC 
Reset the assignee to the default "issues@openoffice.apache.org".