[Libreoffice-bugs] [Bug 116893] Firebird - Error when transferring/pasting NUMERIC or DECIMAL table data

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116893

--- Comment #18 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 147393
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147393&action=edit
Results of importing data from Calc intro firebird

Today on the QA irc channel a report was made concerning importing data from
Calc into Base with firebird db. The results of doing this using drag drop from
calc to base, using the data from the users report as decimal, then double,
then numeric datatypes on the Base side are shown in the graphic.

The data in the calc sheet is:
9000.00   0.00 9000.00
 200.00   0.00 9200.00
   0.00 100.00 9100.00

If the auto detect function is used in the import wizard DOUBLE is the selected
datatype for the new table columns and in that case all the data comes in
properly.

For DECIMAL and NUMERIC the data does not come in properly, but is consistent
in both cases. 
900.00   0.00 900.00
 20.00   0.00 920.00
   0.00 10.00 910.00

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181208/96d0c8ab/attachment.html>