[kmymoney] [Bug 496700] New: CSV export generates incorrect csv files if a comma is used as a decimal separator

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=496700

            Bug ID: 496700
           Summary: CSV export generates incorrect csv files if a comma is
                    used as a decimal separator
    Classification: Applications
           Product: kmymoney
           Version: git (master)
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: exporter
          Assignee: kmymoney-devel at kde.org
          Reporter: ralf.habacker at freenet.de
  Target Milestone: ---

Created attachment 176132
  --> https://bugs.kde.org/attachment.cgi?id=176132&action=edit
test file

STEPS TO REPRODUCE
1.  start kmymoney from master branch
2.  open appended file
3.  open report "Copy of Investment Performance by Account (Only Owned)"
4. export report to CSV
5. Inspect generated file

OBSERVED RESULT
The generated file is exported with the following content and ',' used as
column delimiter.

"Report: Copy of Investment Performance by Account (Only Owned)"
01.01.2024 to 26.11.2024
Account,Buy Value,Dividends reinvested,Market Value,Annualised return,Return On
Investment
"Shares"
"BHP"," -22.475,00"," 0,00"," 24.245,00",2,67%,7,88%
Total Shares," -22.475,00"," 0,00"," 24.245,00",2,67%,7,88%
Grand Total," -22.475,00"," 0,00"," 24.245,00",2,67%,7,88%

The problem with this file is that it contains more than the expected columns
when using a language setting with comma as decimal separator, e.g. the number
2.67% is imported as two columns with the values “2” and “67%”.

EXPECTED RESULT
The export should output numbers with quotation marks to prevent this problem. 

SOFTWARE/OS VERSIONS
Operating System: openSUSE Leap 15.5
KDE Plasma Version: 5.27.9
KDE Frameworks Version: 5.103.0
Qt Version: 5.15.8

-- 
You are receiving this mail because:
You are the assignee for the bug.