Hi Brook
You are correct in that reports are in html. However, all you have to do
is highlight the whole report with the mouse. With that done do a
Control and C copy. Next open your spread sheet and paste.
Alternatively save the report, then open it with your spreadsheet. You
will likely get asked about the document layout - it is Tab delimited.
Having chosen that the file shoul load. You can then save it in the
native format of the spreadsheet.
Regards
Pete
Dr Peter Cuthbert
Creuddyn
Coedlan y Plas
Llangawsai
Aberystwyth
Sir Ceredigion
SY23 1HJ
From: Keith N. McKenna <[email protected]>
Sent: March 26, 2023 11:34:13 PM GMT+01:00
To: [email protected]
Subject: Re: [GNC] Reporting Woes - Newbie incompetence
Brook Milligan wrote:
On Mar 24, 2023, at 10:35 AM, R. Victor Klassen
<[email protected]> wrote:
I use a transaction report for what you seek. With the right options
I get the account, date, description and amount. Copy paste the result
into a spreadsheet
Perhaps I am doing something wrong, but how do you copy/paste the
result into a spreadsheet.
My understanding is that the reports are HTML documents. Perhaps
there is some magic I am not aware of?
Cheers,
Brook
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Most spreadsheet programs will open HTML files. Apache OpenOffice,
LibraOffive, and Excel I know will.
Regards
Keith N. McKenna
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
