Re: [GNC] GNU generated report in HTML to XL

[Finbar Mahon]

I did post that  it worked for me by doing a copy and paste of the 
original exported report but not copying the title!


On 06/01/2019 16:55, Geert Janssens 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 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


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

Re: [GNC] GNU generated report in HTML to XL

[David Carlson]

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

Re: [GNC] GNU generated report in HTML to XL

[Geert Janssens]

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


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

Re: [GNC] GNU generated report in HTML to XL

[Finbar Mahon]

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

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

Re: [GNC] GNU generated report in HTML to XL

[Adrien Monteleone]

Sorry, I should have clarified, my tests were done on a Mac.

I don’t have a Windows setup to test.

I did find some forums concerning LO paste issues with respect to Windows 
however.

Regards,
Adrien

> On Jan 3, 2019, at 3:59 PM, David Carlson  wrote:
> 
> Hello All,
> 
> Happy New Year.
> 
> I am sending this from an Android tablet that sometimes makes really 
> punctuation and language errors, including dropping words like stupid from in 
> front of the word errors.
> 
> I have yet to solve my strange GMAIL problem in Firefox on my laptop, but I 
> did succeed in copying the message that was stuck in the drafts folder before 
> it crashed to a different machine and send it to the Gnucash user maillist,
>  Where it currently resides in the archive and in my sent folder of some of 
> my devices, but I am not sure if it was sent to others on the list.
> 
> I see that Adrien reports that he performed several tests with the current 
> versions of LibreOffice. And Gnucash in a windows environment without 
> encountering the problems that Barry has seen.  Not knowing exactly why he 
> wants to use that mix, it is hard to say whether certain rough edges are of 
> concern to him.  
> 
> Hopefully we are giving him clues that he will find helpful, and if he is 
> still having issues, more details about his situation.
> 
> David C 
> 
> 
> On Thu, Jan 3, 2019, 3:15 PM Adrien Monteleone 
>  I just tested the following using LibreOffice 6.1.0.3 and GnuCash 3.4:
> 
> 1. ctrl+a (select-all) and ctrl+c (copy) from the report within the GnuCash 
> report tab (not a saved file), then ctrl+v (paste) on a blank Calc 
> spreadsheet.
> 
> I was given a dialog to choose import coding, select my delimiters, and 
> otherwise fine-tune the import (paste) with a preview of my actual data.
> 
> The result is the data was imported without formatting into their respective 
> cells, except that ’Totals’ somehow had a newline character before the 
> figures which would necessitate some additional copy/paste to align them 
> correctly.
> 
> 2. Save the report to an .html file, open that file with Firefox and then 
> repeat the above select/copy/paste commands.
> 
> This gave me a less useful dialog box with little control over the end 
> result. I was able to only select the import language and asked if I wanted 
> to detect ’special numbers’ like dates.
> 
> I ended up with a formatted version of the report as it appeared in Firefox 
> but with each respective title or figure in a proper cell
> 
> 3. File > Open the .html file from within Calc as suggested by Chris Lam.
> 
> Without a dialog box, this resulted in a similar situation to #2, but with no 
> grid lines within the report. (like a sheet of paper overlaying the grid)
> 
> 4. Sheets > Insert Sheet from File (or Insert Sheet and then choose ‘From 
> File’ radio button)
> 
> I chose to ‘insert’ the .html file. This gave me the same dialog box as #2, 
> but the result was the same as #3. I could choose to insert before or after 
> the current sheet.
> 
> 
> Note, options 1-2 place the data on the current Calc notebook sheet.
> 
> Option 3 opens an entirely new workbook with only 1 sheet as your report. 
> (unless you’ve set default # of sheets higher)
> 
> Option 4 is *adding* a sheet to the notebook, so you can only place it before 
> or after the current one.
> 
> In every case, the data came through just fine, though I’d probably find 3 or 
> 4 most useful as everything is already lined up. If you wanted no empty 
> columns between your account titles and the values, 1 or 2 would work best, 
> but as noted, you’ll have to do some adjusting if you included parent account 
> total lines.
> 
> Though I used the keyboard shortcuts, Edit > Paste was always available. 
> Perhaps there is an issue with the workbook or the sheet itself that is 
> disabling it? Try a websearch on ‘Edit > Paste not available, just Paste 
> Only’ for LibreOffice.
> 
> A cursory search turns up possibilities of a protected sheet, a read-only 
> workbook, and a long-standing bug on the Windows platform that doesn’t seem 
> to be easily reproducible. However, for those first two possibilities, I 
> would think none of the paste functions would be available.
> 
> I also see a suggestion that 3rd party clipboard managers sometimes don’t 
> play nice with LO.
> 
> 
> Regards,
> Adrien
> 
> 
> > On Jan 3, 2019, at 6:09 AM, Finbar Mahon  wrote:
> > 
> > Thanks both, but I still seem to be having a problem.
> > 
> > I have a file -
> > 
> >  /gnu p
> > 
> > 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, 

Re: [GNC] GNU generated report in HTML to XL

[David Carlson]

Hello All,

Happy New Year.

I am sending this from an Android tablet that sometimes makes really
punctuation and language errors, including dropping words like stupid from
in front of the word errors.

I have yet to solve my strange GMAIL problem in Firefox on my laptop, but I
did succeed in copying the message that was stuck in the drafts folder
before it crashed to a different machine and send it to the Gnucash user
maillist,
 Where it currently resides in the archive and in my sent folder of some of
my devices, but I am not sure if it was sent to others on the list.

I see that Adrien reports that he performed several tests with the current
versions of LibreOffice. And Gnucash in a windows environment without
encountering the problems that Barry has seen.  Not knowing exactly why he
wants to use that mix, it is hard to say whether certain rough edges are of
concern to him.

Hopefully we are giving him clues that he will find helpful, and if he is
still having issues, more details about his situation.

David C


On Thu, Jan 3, 2019, 3:15 PM Adrien Monteleone <
adrien.montele...@lusfiber.net wrote:

> I just tested the following using LibreOffice 6.1.0.3 and GnuCash 3.4:
>
> 1. ctrl+a (select-all) and ctrl+c (copy) from the report within the
> GnuCash report tab (not a saved file), then ctrl+v (paste) on a blank Calc
> spreadsheet.
>
> I was given a dialog to choose import coding, select my delimiters, and
> otherwise fine-tune the import (paste) with a preview of my actual data.
>
> The result is the data was imported without formatting into their
> respective cells, except that ’Totals’ somehow had a newline character
> before the figures which would necessitate some additional copy/paste to
> align them correctly.
>
> 2. Save the report to an .html file, open that file with Firefox and then
> repeat the above select/copy/paste commands.
>
> This gave me a less useful dialog box with little control over the end
> result. I was able to only select the import language and asked if I wanted
> to detect ’special numbers’ like dates.
>
> I ended up with a formatted version of the report as it appeared in
> Firefox but with each respective title or figure in a proper cell
>
> 3. File > Open the .html file from within Calc as suggested by Chris Lam.
>
> Without a dialog box, this resulted in a similar situation to #2, but with
> no grid lines within the report. (like a sheet of paper overlaying the grid)
>
> 4. Sheets > Insert Sheet from File (or Insert Sheet and then choose ‘From
> File’ radio button)
>
> I chose to ‘insert’ the .html file. This gave me the same dialog box as
> #2, but the result was the same as #3. I could choose to insert before or
> after the current sheet.
>
>
> Note, options 1-2 place the data on the current Calc notebook sheet.
>
> Option 3 opens an entirely new workbook with only 1 sheet as your report.
> (unless you’ve set default # of sheets higher)
>
> Option 4 is *adding* a sheet to the notebook, so you can only place it
> before or after the current one.
>
> In every case, the data came through just fine, though I’d probably find 3
> or 4 most useful as everything is already lined up. If you wanted no empty
> columns between your account titles and the values, 1 or 2 would work best,
> but as noted, you’ll have to do some adjusting if you included parent
> account total lines.
>
> Though I used the keyboard shortcuts, Edit > Paste was always available.
> Perhaps there is an issue with the workbook or the sheet itself that is
> disabling it? Try a websearch on ‘Edit > Paste not available, just Paste
> Only’ for LibreOffice.
>
> A cursory search turns up possibilities of a protected sheet, a read-only
> workbook, and a long-standing bug on the Windows platform that doesn’t seem
> to be easily reproducible. However, for those first two possibilities, I
> would think none of the paste functions would be available.
>
> I also see a suggestion that 3rd party clipboard managers sometimes don’t
> play nice with LO.
>
>
> Regards,
> Adrien
>
>
> > On Jan 3, 2019, at 6:09 AM, Finbar Mahon  wrote:
> >
> > Thanks both, but I still seem to be having a problem.
> >
> > I have a file -
> >
> >  /gnu p
> >
> > 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 

Re: [GNC] GNU generated report in HTML to XL

[Adrien Monteleone]

I just tested the following using LibreOffice 6.1.0.3 and GnuCash 3.4:

1. ctrl+a (select-all) and ctrl+c (copy) from the report within the GnuCash 
report tab (not a saved file), then ctrl+v (paste) on a blank Calc spreadsheet.

I was given a dialog to choose import coding, select my delimiters, and 
otherwise fine-tune the import (paste) with a preview of my actual data.

The result is the data was imported without formatting into their respective 
cells, except that ’Totals’ somehow had a newline character before the figures 
which would necessitate some additional copy/paste to align them correctly.

2. Save the report to an .html file, open that file with Firefox and then 
repeat the above select/copy/paste commands.

This gave me a less useful dialog box with little control over the end result. 
I was able to only select the import language and asked if I wanted to detect 
’special numbers’ like dates.

I ended up with a formatted version of the report as it appeared in Firefox but 
with each respective title or figure in a proper cell

3. File > Open the .html file from within Calc as suggested by Chris Lam.

Without a dialog box, this resulted in a similar situation to #2, but with no 
grid lines within the report. (like a sheet of paper overlaying the grid)

4. Sheets > Insert Sheet from File (or Insert Sheet and then choose ‘From File’ 
radio button)

I chose to ‘insert’ the .html file. This gave me the same dialog box as #2, but 
the result was the same as #3. I could choose to insert before or after the 
current sheet.


Note, options 1-2 place the data on the current Calc notebook sheet.

Option 3 opens an entirely new workbook with only 1 sheet as your report. 
(unless you’ve set default # of sheets higher)

Option 4 is *adding* a sheet to the notebook, so you can only place it before 
or after the current one.

In every case, the data came through just fine, though I’d probably find 3 or 4 
most useful as everything is already lined up. If you wanted no empty columns 
between your account titles and the values, 1 or 2 would work best, but as 
noted, you’ll have to do some adjusting if you included parent account total 
lines.

Though I used the keyboard shortcuts, Edit > Paste was always available. 
Perhaps there is an issue with the workbook or the sheet itself that is 
disabling it? Try a websearch on ‘Edit > Paste not available, just Paste Only’ 
for LibreOffice.

A cursory search turns up possibilities of a protected sheet, a read-only 
workbook, and a long-standing bug on the Windows platform that doesn’t seem to 
be easily reproducible. However, for those first two possibilities, I would 
think none of the paste functions would be available.

I also see a suggestion that 3rd party clipboard managers sometimes don’t play 
nice with LO.


Regards,
Adrien


> On Jan 3, 2019, at 6:09 AM, Finbar Mahon  wrote:
> 
> Thanks both, but I still seem to be having a problem.
> 
> I have a file -
> 
>  /gnu p
> 
> 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 > > 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 
>>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 

[GNC] GNU generated report in HTML to XL

[David Carlson]

I had to paste this message into a different computer that is able send
G-Mail, so I hope I got all the good parts...

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

Actually, I was unable to find a method that failed.  I cannot test WIN 10
or GnuCash 3.3 directly, so others will need to test those environments.

David C
___
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.

Re: [GNC] GNU generated report in HTML to XL

[David Carlson]

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

Re: [GNC] GNU generated report in HTML to XL

[Christopher Lam]

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

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

Re: [GNC] GNU generated report in HTML to XL

[Finbar Mahon]

Thanks both, but I still seem to be having a problem.

I have a file -

 /gnu p

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

Re: [GNC] GNU generated report in HTML to XL

[Maf. King]

On Wednesday, 2 January 2019 15:24:57 GMT Finbar Mahon 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

Hi Barry,

I tend to import the html file into a blank spreadsheet - ISTR that the Calc 
menu structure moved this option from something like Insert->File to  
somethilng like Sheet -> Insert Sheet from File last time I prepared reports 
for the accountant.

HTH,
Maf.






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

Re: [GNC] GNU generated report in HTML to XL

[Adrien Monteleone]

Yes, I too have had mixed results *opening* the saved file, but copy and paste 
works every time. I’m pretty sure the wiki reference to this specifies copy and 
paste as the preferred method, but I’ll double check.

Regards,
Adrien

> On Jan 2, 2019, at 10:51 AM, 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  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
>> 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.

Re: [GNC] GNU generated report in HTML to XL

[David Carlson]

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

[GNC] GNU generated report in HTML to XL

[Finbar Mahon]

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