[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