[GNC] GNU generated report in HTML to XL

David Carlson david.carlson.417 at gmail.com
Thu Jan 3 11:17:30 EST 2019


I have a message composed on a different computer but it does not wish to
talk to G-Mail.  When I get that fixed I will get it sent.  The problem
seems to be local to that computer as this computer is on the same network.

On Thu, Jan 3, 2019 at 9:04 AM Christopher Lam <christopher.lck at gmail.com>
wrote:

> 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.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.
> _______________________________________________
> 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