After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 721447 - Entries with values of ,50 are imported as ,51
Entries with values of ,50 are imported as ,51
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Import - QIF
2.6.0
Other Windows
: Normal normal
: ---
Assigned To: gnucash-import-maint
gnucash-import-maint
: 721593 721825 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2014-01-04 12:14 UTC by Adriano
Modified: 2018-06-29 23:23 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Sample QIF file that is imported incorrectly (124 bytes, text/plain)
2014-01-04 12:14 UTC, Adriano
Details
Correctly import in 2.4.14 (43.60 KB, image/png)
2014-01-06 19:51 UTC, Adriano
Details
Failed import on 2.6 (54.46 KB, image/png)
2014-01-06 19:52 UTC, Adriano
Details

Description Adriano 2014-01-04 12:14:30 UTC
Created attachment 265301 [details]
Sample QIF file that is imported incorrectly

On my box (Windows 8.1 x64, english, format - in Clock, Language and Region control panel - as Portuguese, LANG/LANGUAGE env vars set to en_US) importing entries with a decimal value of ,50 (for instance 2,50)creates an entry with a decimal value of  ,51 (for instance, importing 2,50 ends up as 2,51).

On version 2.4.13 this works as expected.
Comment 1 Derek Atkins 2014-01-06 16:45:37 UTC
This is probably due to the change in rounding that was backported to 2.4.14.  I bet it fails in 2.6, too, right?
Comment 2 Derek Atkins 2014-01-06 16:47:57 UTC
*** Bug 721593 has been marked as a duplicate of this bug. ***
Comment 3 Adriano 2014-01-06 17:22:27 UTC
I tested only with 2.6 (in which it fails) and 2.4.13 (works).
Comment 4 Derek Atkins 2014-01-06 18:19:34 UTC
Can you verify 2.4.14?
Comment 5 Adriano 2014-01-06 18:24:42 UTC
sure, I'll and post the results here later
Comment 6 Adriano 2014-01-06 19:51:20 UTC
Created attachment 265470 [details]
Correctly import in 2.4.14
Comment 7 Adriano 2014-01-06 19:52:07 UTC
Created attachment 265471 [details]
Failed import on 2.6
Comment 8 Adriano 2014-01-06 19:53:01 UTC
Hi, I could not reproduce the issue with 2.4.14 on a VM.

What I did:

1. Installed 2.4.14 
2. Created an new GNU Cash file.
3. Imported the sample file attached in this issue (worked)
4. Installed 2.6 and repeated steps 2 & 3. The issue happend.
Comment 9 Elwood 2014-01-10 03:55:29 UTC
FWIW, I am also seeing this in 2.6 on two different Windows 7 x86 machines.

I have seen the following errors on split transaction imports:
QIF --> Gnucash
.83    .85
.78    .79
.73    .72
.65    .66
.64    .65
.63    .64
.50    .51
.42    .41
.41    .40
.40    .39
.34    .33
.03    .04
Comment 10 Frank H. Ellenberger 2014-01-16 07:47:22 UTC
Comment on attachment 265301 [details]
Sample QIF file that is imported incorrectly

Please mark text files as text/plain instead of octet/stream
Comment 11 Frank H. Ellenberger 2014-01-16 08:27:31 UTC
Importing the file under Linux I get the right values. So it seems to be a Windows issue.

Probably related is 
Bug 721825 - Online prices displayed as unreadable fractions in 2.6.0
Comment 12 John Ralls 2014-01-17 19:30:50 UTC
(In reply to comment #8)
> Hi, I could not reproduce the issue with 2.4.14 on a VM.

Was that a Windows VM or a Linux VM? As Frank notes, this problem appears to be Windows only.
Comment 13 Adriano 2014-01-17 20:19:06 UTC
Windows 8, 32bits (as I said, I can reproduce the issue in that VM but only on GnuCash 2.6)
Comment 14 John Ralls 2014-01-19 21:25:01 UTC
*** Bug 721825 has been marked as a duplicate of this bug. ***
Comment 15 John Ralls 2014-01-19 21:30:20 UTC
r23721.
(int)pow(10, 2) was returning 99 instead of 100, which created a result that was both correct and impossible to convert back to an exact decimal, at least using our extremely lame gnc_numeric_to_decimal function. In this case, that resulted in inappropriate rounding.
Comment 16 John Ralls 2018-06-29 23:23:32 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=721447. Please update any external references or bookmarks.