[GNC] GNU generated report in HTML to XL

Finbar Mahon mahon.finbar at neuf.fr
Fri Jan 4 04:26:50 EST 2019


Hello again.

I think I solved the problem.

I did what David suggested, but copied the whole doc, title and 
all,after 'select all. Then I tried just the data, no title, it worked! 
Offered me all the 'paste' options in calc....

Don't ask me why!

Thanks, Barry

On 03/01/2019 13:09, 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.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.
>>
> _______________________________________________
> gnucash-user mailing list
> 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