<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird - Error when transferring/pasting NUMERIC or DECIMAL table data" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116893#c18">Comment # 18</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird - Error when transferring/pasting NUMERIC or DECIMAL table data" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116893">bug 116893</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=147393" name="attach_147393" title="Results of importing data from Calc intro firebird">attachment 147393</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=147393&action=edit" title="Results of importing data from Calc intro firebird">[details]</a> 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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>