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.fin...@neuf.fr <mailto:mahon.fin...@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@gnucash.org <mailto: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.

_______________________________________________
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