Copy and paste reports to Excel doesn't work

Mac OS X 10.9 or higher.

Moderator: Renato

Post Reply
LeoB
New MMEX User
Posts: 1
Joined: Tue Sep 20, 2022 9:26 am
Are you a spam bot?: No

Copy and paste reports to Excel doesn't work

Post by LeoB »

I need to be able to export income and expenditure by category to excel and have seen in the forum that other users can copy and paste direct from the report page but when I do this it pastes all data into a single cell with no obvious delimiters so csv doesn't seem to be an option either. Can anyone help with another way? I'm using mmex version 1.5.20 on Monterey 12.3.1
User avatar
Renato
MVP MMEX User
Posts: 420
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Copy and paste reports to Excel doesn't work

Post by Renato »

maybe this will help: search.php?keywords=paste
regards Renato use MMEX since 2009, now with Windows 11
whall3y
MMEX Developer
Posts: 297
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Copy and paste reports to Excel doesn't work

Post by whall3y »

Justed tested and works fine.
  • MacOS 12.6
  • Excel for Mac M365 Subscription v16.65
CleanShot 2022-09-20 at 13.44.20@2x.png
CleanShot 2022-09-20 at 13.44.20@2x.png (138.54 KiB) Viewed 267 times
CleanShot 2022-09-20 at 13.45.05@2x.png
CleanShot 2022-09-20 at 13.45.05@2x.png (93.39 KiB) Viewed 267 times
dbolton
MVP MMEX User
Posts: 103
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No
Contact:

Re: Copy and paste reports to Excel doesn't work

Post by dbolton »

LeoB, in Excel make sure to single click on a cell and paste directly on the sheet (not in the field above the sheet)
Post Reply