[GNC] Sales, Sales Taxs & Deposits

[Adrien Monteleone]

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