[GNC] GNU generated report in HTML to XL

Finbar Mahon mahon.finbar at neuf.fr
Thu Jan 3 07:09:53 EST 2019


Thanks both, but I still seem to be having a problem.

I have a file -

.... /gnu p&l2018.html

If I try to cut and paste the data to a new libreoffice calc file I get 
only 'paste only' as an option under >edit, and nothing else 
recognisable from >insert.

I have tried 'insert sheet' under >insert but only get the option to 
insert before or after and then cannot copy the 'new' sheet into an 
existing one, if I add 'after'

There doesn't seem to be a method of cut and paste directly, afaics.

Thanks, Barry

On 02/01/2019 17:51, David Carlson wrote:
> Finbar,
>
> You may need to first open a new blank spreadsheet then cut and paste 
> from the html document into the spreadsheet rather than trying to 
> directly open HTML with Calc.
>
> My experience with LibreOffice Calc is that it will import several 
> different kinds of files.  I use it regularly to convert transaction 
> detail exports from a certain department store website to a form from 
> which I can manually extract data to enter into GnuCash, although I 
> have not figured out how to restructure it to use the CSV importer for 
> that case.
>
> David C
>
> On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon <mahon.finbar at neuf.fr 
> <mailto:mahon.finbar at neuf.fr>> wrote:
>
>     Hello,
>
>     I exported a GNUCash report to HTMl, but I don't seem to be able to
>     import it to LibreOffice Calc, the LibreOffice xl equivalent.
>
>     Does anybody know if I must use 'real' MS XL to receive the HTML
>     file?
>     In LibreOffice you can save calc files in MS format. Are there any
>     special tricks for importing?
>
>     I am using 3.3 on Windows 10.
>
>     Thanks, Barry
>
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org <mailto:gnucash-user at 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.
>


More information about the gnucash-user mailing list