https://bugs.kde.org/show_bug.cgi?id=521760
Bug ID: 521760
Summary: CSV Import ignores all decimal separators regardless
of format or import setting
Classification: Applications
Product: kmymoney
Version First 5.2.2
Reported In:
Platform: Other
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: importer
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
DESCRIPTION
When importing CSVs, no matter whether the numbers in the CSV are formatted
with , or . as decimal separators (presence/absence of thousands separators
also makes no difference), and no matter which decimal separator option is
selected in the importer (“,”, “.” or “auto“), decimal separators are
completely ignored, resulting in most values being multiplied by 10 or 100
depending on how many digits are present after the decimal.
I tried disabling automatic decimal separator detection in the CSV import
settings, but that also made no difference.
I tried downloading the AppImage of the latest stable version and that showed
the same behaviour (as well as many other UI-related bugs which made it very
hard to use).
STEPS TO REPRODUCE
1. Import a CSV, no matter how it’s formatted or how the CSV importer is
configured
OBSERVED RESULT
Imported values match the values in the CSV
EXPECTED RESULT
Imported values ignore decimal separators and are therefore mostly multiplied
by 10 or 100
SOFTWARE/OS VERSIONS
Operating System (available in the Info Center app, or by running `kinfo` in a
terminal window):
KDE Plasma Version: 6.6.4
KDE Frameworks Version: 6.24.0
Qt Version: 6.10.2
ADDITIONAL INFORMATION
I also experienced a bug in the reconciliation UI which I thought might be
related, where decimal separators were interpreted wrong. Entering 8094.16 or
8094,16 resulted in 809,41, and only entering 8094.160 convinced KMM to
interpret the number correctly. I tried to use the same approach for the CSV
importer (adding an additional 0 in the thousandths place) but for the CSV
importer that just made the problem worse, multiplying all the values by 10
again. So it seems like they’re separate issues.
--
You are receiving this mail because:
You are watching all bug changes.
