<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Firebird - Error when transferring/pasting NUMERIC or DECIMAL table data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116893">bug 116893</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>DUPLICATE
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Firebird - Error when transferring/pasting NUMERIC or DECIMAL table data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116893#c22">Comment # 22</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Firebird - Error when transferring/pasting NUMERIC or DECIMAL table data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116893">bug 116893</a>
from <span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span></b>
<pre>(In reply to Drew Jensen from <a href="show_bug.cgi?id=116893#c18">comment #18</a>)
<span class="quote">> Created <span class=""><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></span>
> 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</span >
This is fixed in <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - base(firebird): Incorrect Posting of Numeric Data"
href="show_bug.cgi?id=123591">bug 123591</a>.
Regarding the DECIMAL migration, this is already covered by <a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Migration of DECIMAL creates unusable values"
href="show_bug.cgi?id=126268">bug 126268</a>.
Closing as RESOLVED DUPLICATED
*** This bug has been marked as a duplicate of <a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Migration of DECIMAL creates unusable values"
href="show_bug.cgi?id=126268">bug 126268</a> ***</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>