Bug 123591 - base(firebird): Incorrect Posting of Numeric Data
Summary: base(firebird): Incorrect Posting of Numeric Data
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, perf, regression
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
 
Reported: 2019-02-20 10:36 UTC by perie_gut
Modified: 2019-04-09 15:04 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
database sample (11.77 KB, application/vnd.sun.xml.base)
2019-02-20 10:37 UTC, perie_gut
Details
sample data (23.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-20 10:38 UTC, perie_gut
Details
Screenshot shows how to assign columns from copy to table (36.48 KB, image/png)
2019-02-23 09:52 UTC, Robert Großkopf
Details
columns in source and target tables (10.81 KB, image/png)
2019-02-24 09:21 UTC, ribotb
Details

Note You need to log in before you can comment on or make changes to this bug.
Description perie_gut 2019-02-20 10:36:13 UTC
Posted numeric values are not correct due to inclusion of decimals.

How to generate the issue
1. Open the base file
2. Open the calc file
3. Copy the calc file data (including the Header)
4. paste the date to table t_invoice_list
5. check the posted values under the following columns: invoiceamount, localamount, reportamount.
Comment 1 perie_gut 2019-02-20 10:37:39 UTC
Created attachment 149438 [details]
database sample

* no real data
Comment 2 perie_gut 2019-02-20 10:38:09 UTC
Created attachment 149439 [details]
sample data
Comment 3 perie_gut 2019-02-20 10:39:39 UTC
Version: 6.2.0.3 (x64)
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-PH (en_PH); UI-Language: en-US
Calc: threaded
Comment 4 Robert Großkopf 2019-02-20 17:10:52 UTC
Seems Base/Firebird doesn't recognize the decimalseparator from the Calc-import-file. If set to 1 Decimal-Places (as in the example database) the shown value will be devided by 10.

Have tested this with LO 6.1.5.2 and OpenSUSE 15 64bit rpm Linux.
Comment 5 ribotb 2019-02-22 11:38:08 UTC
When I paste into to table t_invoice_list, an error message is displayed :

Avertissement
Incorrect type for setString
Voulez-vous vraiment poursuivre ?
Oui / Non

Version: 6.2.0.3 (x64)
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
Threads CPU : 4; OS : Windows 10.0; UI Render : par défaut; VCL: win; 
Locale : fr-FR (fr_FR); Langue IHM : fr-FR
Calc: threaded
Comment 6 Robert Großkopf 2019-02-23 09:52:24 UTC
Created attachment 149542 [details]
Screenshot shows how to assign columns from copy to table

The error message you reported appears if you don't assign the columns in the dialogue.

There is a design-bug in this dialogue. Could be it appears only in LO together with gtk. The buttons for moving up and down the fields will show alphabetical sorting instead. I will report this as another bug to the bug Firebird import with decimal-places doesn't work right.
Comment 7 ribotb 2019-02-24 09:19:15 UTC
The columns of the target table are in the right order in the dialog, but the columns of the source table and the columns in the target table are not in the same order.
See attachment.
Comment 8 ribotb 2019-02-24 09:21:00 UTC
Created attachment 149552 [details]
columns in source and target tables
Comment 9 ribotb 2019-02-24 10:49:01 UTC
Version: 6.2.0.3 (x64)
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
Threads CPU : 4; OS : Windows 10.0; UI Render : par défaut; VCL: win; 
Locale : fr-FR (fr_FR); Langue IHM : fr-FR
Calc: threaded
Comment 10 Robert Großkopf 2019-02-24 15:49:16 UTC
(In reply to ribotb from comment #7)
> The columns of the target table are in the right order in the dialog, but
> the columns of the source table and the columns in the target table are not
> in the same order.
> See attachment.

Couldn't you change the order by the buttons? Note bug 119693 for the wrong display in the button. The upper buttons on the left will switch the marked fields of the left up. Same behaviour with all the other buttons which will show "A→Z" instead of "UP" and "DOWN".
Comment 11 ribotb 2019-02-24 19:29:07 UTC
By ordering the columns of the source table, the copy works.

And I confirm: Base/Firebird doesn't recognize the decimalseparator from the Calc import also in v6.2.0