[kmymoney] [Bug 503260] New: CSV importer does not use the decimal dot setting

[Ciprian Ciubotariu]

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 at kde.org
          Reporter: cheepeero at 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.