[GNC] Reporting Woes - Newbie incompetence

[Peter Cuthbert]

  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 <keith.mckenna at comcast.net>

Sent: March 26, 2023 11:34:13 PM GMT+01:00

To: gnucash-user at lists.gnucash.org

Subject: Re: [GNC] Reporting Woes - Newbie incompetence



Brook Milligan wrote:




      On Mar 24, 2023, at 10:35 AM, R. Victor Klassen 
<rvklassen at gmail.com> 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
  gnucash-user at gnucash.org
  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

  gnucash-user at gnucash.org

  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.