There is another option besides copy/paste. (which is useful for short reports)

You can export the report in html then open with a spreadsheet app or use the 
‘insert sheet from file’ function within your spreadsheet app.

I don’t think Excel plays nice, but LibreOffice/OpenOffice is known to open 
html table files generated by GnuCash with ease. Google Sheets might work as 
well. This route will likely preserve the report formatting such as font and 
size. You might be able to import it unformatted though as an option. That 
would depend on your spreadsheet app.

The html export is not paginated, so you’ll just get one set of headers and 
footers.

Regards,
Adrien


> On Jan 23, 2020 w4d23, at 2:04 PM, Jimmy R via gnucash-user 
> <gnucash-user@gnucash.org> wrote:
> 
> Ok I did not think of copy & past from the report, I figured there would be a
> csv export for it...plain & simple
> 
> Selecting "table for exporting" does not make a difference except adding a
> column Income Sales as a placeholder column
> 
> I don't have enough sales entry's for the test to see if running the
> transaction report will generate multiple pages with a headers & footers on
> each page which will make it difficult to copy and paste for 360 income
> entry's for a 6 month period
> 
> The reason to accomplish this is to put on a spreadsheet to compare sales
> data with weather conditions for a seasonal oceanfront foodservice operation
> 
> Thanks
> 
> Jimmy


_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to