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@kde.org
Reporter: ralf.habac...@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.
