Exporting the report will save it as an HTML file. I don't know about
Excel, but Libreoffice Calc can import this just fine using the 'Insert
Sheet From File' menu option.
Otherwise, you can 'select all' with the report visible and then paste
into a blank spreadsheet. (CTRL/CMD+A should handle the select-all in
any OS, otherwise drag and select works too.)
You may want to instead 'paste special' or 'paste unformatted text'.
(some apps/OSs use 'paste and match style') That will use the formatting
of your spreadsheet app instead of the formatting of GnuCash. (mostly
just font, size, and color)
Be mindful during the paste or import, if you get a dialog asking for
column delimiters, to *uncheck* the comma, as that will break columns
where they appear in numerical figures. Most such dialogs will usually
give you a brief content preview so you can see how the columns will lay
out based on the options selected.
This is standard procedure for further modifying any GnuCash report.
Regards,
Adrien
On 11/3/20 9:11 PM, TanyaMc70 wrote:
Thanks for the tip to use the experimental income statement and to change the
option to show the months!
Is there a way to export this report to excel to apply totals and other
tweaks required by oversight committee?
_______________________________________________
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.
