https://bugs.documentfoundation.org/show_bug.cgi?id=156530
Bug ID: 156530
Summary: FIREBIRD: Copying a table from one database file to
another gives wrong decimal numbers.
Product: LibreOffice
Version: 7.5.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 188655
--> https://bugs.documentfoundation.org/attachment.cgi?id=188655&action=edit
Source database file for copying a table with decimal places
Take the two attached databases.
Copy the table from "DecimalCopy.odb" to "DecimalCopyTarget.odb".
You could add the data to the table in "DecimalCopyTarget.odb" or let the
wizard create a new table.
No actions needed, so choose "Create" in the wizard.
Have a look at the original table and to the result.
Field with 2 decimal places:
123.45 will copied to 1.23 (divided by 100)
Field with 3 decimal places:
123.456 will copied to 0.123 (divided by 1000)
Filed with 4 decimal places:
123.4567 will copied to 0.0123 (divided by 10000)
Note:
1. If the data will be pasted to Calc the numbers will be pasted with right
values.
2. If the data will be pasted to the same *.odb-file as table source it will
also be pasted right.
--
You are receiving this mail because:
You are the assignee for the bug.
