Bug 509012

Summary:	Data copied from a report view is formatted incorrectly
Product:	[Applications] kmymoney	Reporter:	TraceyC <kdedev>
Component:	reports	Assignee:	KMyMoney Devel Mailing List <kmymoney-devel>
Status:	REPORTED ---
Severity:	normal	Keywords:	regression
Priority:	NOR
Version First Reported In:	5.2.1
Target Milestone:	---
Platform:	Solus
OS:	Linux
See Also:	https://bugs.kde.org/show_bug.cgi?id=506692
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description TraceyC 2025-09-01 22:29:05 UTC

SUMMARY
When copying data from a report, it used to be easily pasted as plain text / csv into a spreadsheet. This stopped working in 5.2.x

STEPS TO REPRODUCE
1. Have a report for expenses per month
2. Use the mouse to highlight the rows for the current month
3. Right click - copy
4. In Libre Office Calc, use Paste Special - Unformatted text
5. Change the separator from "Detected (space" to "Separated by"

OBSERVED RESULT
Every value is on its own row, there is only one column of data

Ex:
8/1/2025
Store name
Visa 1234
Widgets
-10.00

EXPECTED RESULT
Values are formatted properly, each column has the expected data for that field
Ex:
8/1/2025    Store name    Visa 1234    Widgets    -10.00


SOFTWARE/OS VERSIONS
Operating System: Solus 4.7
KDE Plasma Version: 6.4.4
KDE Frameworks Version: 6.17.0
Qt Version: 6.9.2
Kernel Version: 6.15.6-321.current (64-bit)
Graphics Platform: Wayland


ADDITIONAL INFORMATION
This used to work in KMymoney prior to 5.2.1
While there's a workaround in that I can use "Export report", that has its own problems.
1. If the report does not have "Convert values to base currency" set, the Amount column turns into a string with USD being appended to the numerical value, making it useless for calculations.
2. If the report does have "Convert values to base currency" set, there is an unwanted "Price" column that I need to delete to copy the desired data - See bug 506692

Comment 1 Jack 2025-09-01 23:05:27 UTC

Every test I have done pastes as expected, into multiple columns.  However, I just selected the text from the report and middle clicked in the first cell to paste.  Try just using "paste" instead of "paste special" to see if it works any better for you.

Comment 2 TraceyC 2025-09-02 17:35:05 UTC

Thanks for taking the time to look into this. There's still a problem with using Copy - Paste without Paste Special. It copies the data as html, which includes the color formatting. Since KMyMoney is running in dark mode, the data that gets pasted gets a dark grey background with black text, which is nearly unreadable. I would still need to use Paste Special to copy the text / numbers without any formatting.