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
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.
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.