Bug 509012 - Data copied from a report view is formatted incorrectly
Summary: Data copied from a report view is formatted incorrectly
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: reports (other bugs)
Version First Reported In: 5.2.1
Platform: Solus Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2025-09-01 22:29 UTC by TraceyC
Modified: 2025-09-02 17:35 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.