https://bugs.kde.org/show_bug.cgi?id=503260
Bug ID: 503260
Summary: CSV importer does not use the decimal dot setting
Classification: Applications
Product: kmymoney
Version: 5.1.95
Platform: Gentoo Packages
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: importer
Assignee: kmymoney-devel@kde.org
Reporter: cheepe...@gmx.net
Target Milestone: ---
SUMMARY
The CSV import setup has a "Decimal symbol" setting on the Formats page, but it
ignores it when performing the import. This creates problems on systems that
have customised locale settings.
On my system, I have numbers as en-GB, which use . (dot) as a decimal point and
currency as ro-RO, which uses , (comma). The reason for that is that many tools
assume lists of numbers are separated by commas, so I cannot process files
easily across my tools with the ro-RO number locale. At the same time, I cannot
read the en-GB/US currency formats, with negative numbers in parentheses etc.
Side comment: it was better before.
For some reason, kmymoney chose to use comma everywhere, including in the CSV
importer, and not the number locale. Even if I set the Decimal symbol to dot in
the bank setup, the number parser seems to walk over the dot.
STEPS TO REPRODUCE
1. Create a CSV that represents numbers using a different decimal symbol than
the system locale.
2. Setup your number format to en-GB and your currency format to ro-RO
3. Import the CSV
OBSERVED RESULT
EXPECTED RESULT
SOFTWARE/OS VERSIONS
Windows:
macOS:
(available in the Info Center app, or by running `kinfo` in a terminal window)
Linux/KDE Plasma:
KDE Plasma Version:
KDE Frameworks Version:
Qt Version:
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are the assignee for the bug.
