You may open the .html from Libreoffice Calc (not Libreoffice writer).
File > Open, and click on the exported .html file.
On 3/1/19 8:09 pm, Finbar Mahon wrote:
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.
_______________________________________________
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.
