[GNC] GNU generated report in HTML to XL

David Carlson david.carlson.417 at gmail.com
Sun Jan 6 12:42:30 EST 2019


I don't recall if the OP explained why he wanted to import the report into
a spreadsheet.  I am guessing that he wanted to do some post processing
that is easier in a spreadsheet.   I am not surprised that a direct copy
and paste also works.  For some html things (not GnuCash reports) that I
have tried to paste into a spreadsheet  the resulting cell structure was so
bad that it was impossible to clean up to get a decent print anyway.

David


On Sun, Jan 6, 2019, 9:55 AM Geert Janssens <geert.gnucash at kobaltwit.be
wrote:

> On Thursday, January 3, 2019 5:33:06 PM CET David Carlson wrote:
> > I was able to run a quick test using release 2.6.17 in Ubuntu 16.04 and
> > found that first, when I tried to save a P&L report in HTML format
> GnuCash
> > did not append a .html suffix.  In Linux this did not create a problem,
> but
> > Windows did not recognize the file as html.  Appending ".html" to the
> > filename solved that problem.
> >
> > Once I had appended ".html" to the filename I could open it in Firefox or
> > whichever browser and I could get a nice printout directly or select all
> > [ctrl-A, ctrl-C] and paste [ctrl-V] into a waiting new LibreOffice
> 6.0.7.3
> > Calc doc in WIN 7.
> >
> It should even be possible to  copy and paste directly from gnucash to
> libreoffice as far as I know. The detour via firefox or similar is not
> needed.
> That's only needed for a printout that's not cutting lines in half.
>
> Geert
>
>
>


More information about the gnucash-user mailing list