https://bz.apache.org/ooo/show_bug.cgi?id=126404
Issue ID: 126404
Issue Type: DEFECT
Summary: Lost precision when copying table data
Product: Base
Version: 4.1.1
Hardware: All
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P5
Component: code
Assignee: [email protected]
Reporter: [email protected]
Created attachment 84825
--> https://bz.apache.org/ooo/attachment.cgi?id=84825&action=edit
Sample database with high-precision data
When copying data from a table (or query) in Base, the data is copied "as
shown" which leads to loss of precision. I would expect that copying a table
from Base to Calc would preserve full precision, but this is not the case.
Example: The attached sample database contains a table with the following data:
MyTimestamp MyDouble
01-01-2015 00:00:01 1.2345
01-01-2015 00:00:15 3.1415
However, when the table is opened then the times is only shown the the level of
minutes, and the numbers are rounded to two decimal places:
01-01-15 00:00 1.23
01-01-15 00:00 3.14
Showing it like this is not an error, but when I copy the data then data are
only copied to this precision. This is the case whether I copy the whole table,
or open the table and choose all data. Thus, precision is SILENTLY lost in the
copying process. I learned this only after loosing data in a copy.
(Full precision is kept if database is registered and a connection made to the
data from Calc.)
Lars J
--
You are receiving this mail because:
You are the assignee for the issue.
