Re: Files don't export as html
CMD/CTRL+A is standard across most operating systems for ’select all’. There are many other common keyboard shortcuts. Do a web search for ‘keyboard shortcuts for Mac’ and there are several resources with lists and cheat sheets. Regards, Adrien > On Mar 30, 2018, at 7:02 PM, Peter Kiessling wrote: > > > Thanks Ken, > Sounds Good. Is there some sort of manual for these tricks? > Pete > > On Mar 30, 2018, at 4:54 PM, Kenneth Schneider > wrote: > > > > Ken Schneider > >> On Mar 30, 2018, at 6:54 PM, Peter Kiessling wrote: >> >> >> >> Mar 30 >> Great idea Geert. >> Bottom line - it works. I had not considered it before because I didn’t know >> how to select the whole report other than using cursor pull down >> highlighting all. Turns out I can click upper left then shift-click lower >> right and all gets highlighted. > > > You might also try ctrl-a to highlight all after you click in the upper left. > > ___ > 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: Files don't export as html- text edit instead.
It’s not a Mac problem. It works fine for me on High Sierra, at least. The solution is simple enough though should it not work, just manually add the .html. (the file itself IS HTML, so this will simply tell the OS to use the default app, in this case a browser, to open the file instead of Text Edit) Numbers won’t read an HTML file, but LO Calc can import it via ‘Insert Sheet From File’ and opening in a browser for display and then copy/paste produces the same result. (Numbers can take the copy/paste) But if you’re going to copy/paste anyway, you can just skip the export entirely and copy the report directly. Regards, Adrien > On Mar 30, 2018, at 6:29 PM, DaveC49 wrote: > > Peter, > > For your info. No problem with report export ( balance sheet) as html in > Gnucash 2.6.19 running on Linux Mint 18.3, so it may be a specific Mac bug. > It may also be a change in the html import for the spreadsheet you are > using, if that has been recently updated. > > On Linux the .html extension is added to the file name by default and it > opens directly in my browser. I can also import the report.html file > directly into LibreOffice (v 6.0.2.1) and it is imported with an appropriate > set of columns. By default they have the spreadsheet default widths, so the > report does look compacted but this is easily fixed by dragging the column > boundaries. > > I know it doesn't help too much knowing it is working on other platforms but > it may help the developers isolate the problem. > > David Cousens > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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: Files don't export as html
Thanks Ken, Sounds Good. Is there some sort of manual for these tricks? Pete On Mar 30, 2018, at 4:54 PM, Kenneth Schneider wrote: Ken Schneider > On Mar 30, 2018, at 6:54 PM, Peter Kiessling wrote: > > > > Mar 30 > Great idea Geert. > Bottom line - it works. I had not considered it before because I didn’t know > how to select the whole report other than using cursor pull down highlighting > all. Turns out I can click upper left then shift-click lower right and all > gets highlighted. You might also try ctrl-a to highlight all after you click in the upper left. ___ 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: Files don't export as html
Ken Schneider > On Mar 30, 2018, at 6:54 PM, Peter Kiessling wrote: > > > > Mar 30 > Great idea Geert. > Bottom line - it works. I had not considered it before because I didn’t know > how to select the whole report other than using cursor pull down highlighting > all. Turns out I can click upper left then shift-click lower right and all > gets highlighted. You might also try ctrl-a to highlight all after you click in the upper left. ___ 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: Files don't export as html- text edit instead.
Peter, For your info. No problem with report export ( balance sheet) as html in Gnucash 2.6.19 running on Linux Mint 18.3, so it may be a specific Mac bug. It may also be a change in the html import for the spreadsheet you are using, if that has been recently updated. On Linux the .html extension is added to the file name by default and it opens directly in my browser. I can also import the report.html file directly into LibreOffice (v 6.0.2.1) and it is imported with an appropriate set of columns. By default they have the spreadsheet default widths, so the report does look compacted but this is easily fixed by dragging the column boundaries. I know it doesn't help too much knowing it is working on other platforms but it may help the developers isolate the problem. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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: Files don't export as html
Mar 30 Great idea Geert. Bottom line - it works. I had not considered it before because I didn’t know how to select the whole report other than using cursor pull down highlighting all. Turns out I can click upper left then shift-click lower right and all gets highlighted. Pastes correctly except last 2 lines (totals) which are shifted to the left cells instead of bottom right. Not a problem for me though. I don’t use them much. For fun I used the mac numbers spreadsheet also which in latest version seems to require me to tell it that the separators are tabs with this table. Pete On Mar 30, 2018, at 9:00 AM, gnucash-user-requ...@gnucash.org wrote: Op vrijdag 30 maart 2018 07:08:39 CEST schreef Peter Kiessling: Update; > I continued using my work around. Then tonight, suddenly again, the .html > extension began to reappear. I did snoop around a bit and surmise that the > only thing lacking in the report file was the extension label, which is > necessary for the browser to see it. Text edit showed a file that seemed to > have html code even though it was not labelled html or anything. Anyhow now > working. Have you tried copying straight from the gnucash report window instead of exporting to the browser and then copying ? It should give you the same result while saving you an intermediate step. Geert -- Subject: Digest Footer ___ 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. -- End of gnucash-user Digest, Vol 180, Issue 67 * ___ 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: files don't export as html. UPDATE.
Op vrijdag 30 maart 2018 07:08:39 CEST schreef Peter Kiessling: > Update; > I continued using my work around. Then tonight, suddenly again, the .html > extension began to reappear. I did snoop around a bit and surmise that the > only thing lacking in the report file was the extension label, which is > necessary for the browser to see it. Text edit showed a file that seemed to > have html code even though it was not labelled html or anything. Anyhow now > working. Have you tried copying straight from the gnucash report window instead of exporting to the browser and then copying ? It should give you the same result while saving you an intermediate step. 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: files don't export as html. UPDATE.
Update; I continued using my work around. Then tonight, suddenly again, the .html extension began to reappear. I did snoop around a bit and surmise that the only thing lacking in the report file was the extension label, which is necessary for the browser to see it. Text edit showed a file that seemed to have html code even though it was not labelled html or anything. Anyhow now working. ___ 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: files
Christine, That confirms my earlier belief that GnuCash was in fact running when you moved your files. Quit GnuCash and re-start it. This time when you get that dialog click "Open Anyway". Regards, John Ralls > On Nov 14, 2017, at 10:44 AM, Christine wrote: > > Hi john > Yes > > -Original Message- > From: John Ralls [mailto:jra...@ceridwen.us] > Sent: 14 November 2017 18:18 > To: Christine > Cc: GnuCash > Subject: Re: files > > Christine, > > Please remember to copy the list on all replies. > > Is it read-only because you got the "unable to obtain the lock" dialog and > selected "open read only"? > > Regards, > John Ralls > >> On Nov 14, 2017, at 10:12 AM, Christine wrote: >> >> Hi john >> I have windows 7 and can't remember how I opened it before, but this >> time I used open with and the file is read only so I cannot add more >> to the accounts. >> Regards >> Christine >> >> >> -Original Message- >> From: John Ralls [mailto:jra...@ceridwen.us] >> Sent: 14 November 2017 03:56 >> To: Christine >> Cc: GnuCash >> Subject: Re: files >> >> Christine, >> >> That is what I meant. How did you then open the file in the new location? >> What operating system/distro are you using? >> >> Regards, >> John Ralls >> >> >>> On Nov 13, 2017, at 8:35 AM, Christine wrote: >>> >>> Hi John >>> Sorry I panicked and could not find out where to send messages. >>> Gnucash was not open when I placed the files in a folder. If that is >>> what >> you mean. >>> Kind regards >>> Christine >>> >>> -Original Message- >>> From: John Ralls [mailto:jra...@ceridwen.us] >>> Sent: 13 November 2017 01:55 >>> To: Christine >>> Cc: GnuCash >>> Subject: Re: files >>> >>> >>>> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user >>> wrote: >>>> >>>> Hello >>>> All my files are on the desktop where I saved them. So I put them in >>>> a folder and now when I try to open one of the pages, it asks me to >>>> save it, if I click on save it wants a new path, how can I work from >>>> a main folder pls? >>>> Christine >>>> >>> >>> Please don't reply to messages when you want to start a new thread, >>> it doesn't work. >>> >>> Was GnuCash running when you moved the files? >>> >>> Regards, >>> John Ralls >>> >>> >>> --- >>> This email has been checked for viruses by Avast antivirus software. >>> https://www.avast.com/antivirus >>> >> > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: files
Hi john Yes -Original Message- From: John Ralls [mailto:jra...@ceridwen.us] Sent: 14 November 2017 18:18 To: Christine Cc: GnuCash Subject: Re: files Christine, Please remember to copy the list on all replies. Is it read-only because you got the "unable to obtain the lock" dialog and selected "open read only"? Regards, John Ralls > On Nov 14, 2017, at 10:12 AM, Christine wrote: > > Hi john > I have windows 7 and can't remember how I opened it before, but this > time I used open with and the file is read only so I cannot add more > to the accounts. > Regards > Christine > > > -Original Message- > From: John Ralls [mailto:jra...@ceridwen.us] > Sent: 14 November 2017 03:56 > To: Christine > Cc: GnuCash > Subject: Re: files > > Christine, > > That is what I meant. How did you then open the file in the new location? > What operating system/distro are you using? > > Regards, > John Ralls > > >> On Nov 13, 2017, at 8:35 AM, Christine wrote: >> >> Hi John >> Sorry I panicked and could not find out where to send messages. >> Gnucash was not open when I placed the files in a folder. If that is >> what > you mean. >> Kind regards >> Christine >> >> -Original Message- >> From: John Ralls [mailto:jra...@ceridwen.us] >> Sent: 13 November 2017 01:55 >> To: Christine >> Cc: GnuCash >> Subject: Re: files >> >> >>> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user >> wrote: >>> >>> Hello >>> All my files are on the desktop where I saved them. So I put them in >>> a folder and now when I try to open one of the pages, it asks me to >>> save it, if I click on save it wants a new path, how can I work from >>> a main folder pls? >>> Christine >>> >> >> Please don't reply to messages when you want to start a new thread, >> it doesn't work. >> >> Was GnuCash running when you moved the files? >> >> Regards, >> John Ralls >> >> >> --- >> This email has been checked for viruses by Avast antivirus software. >> https://www.avast.com/antivirus >> > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: files
Christine, Please remember to copy the list on all replies. Is it read-only because you got the "unable to obtain the lock" dialog and selected "open read only"? Regards, John Ralls > On Nov 14, 2017, at 10:12 AM, Christine wrote: > > Hi john > I have windows 7 and can't remember how I opened it before, but this time I > used open with and the file is read only so I cannot add more to the > accounts. > Regards > Christine > > > -Original Message- > From: John Ralls [mailto:jra...@ceridwen.us] > Sent: 14 November 2017 03:56 > To: Christine > Cc: GnuCash > Subject: Re: files > > Christine, > > That is what I meant. How did you then open the file in the new location? > What operating system/distro are you using? > > Regards, > John Ralls > > >> On Nov 13, 2017, at 8:35 AM, Christine wrote: >> >> Hi John >> Sorry I panicked and could not find out where to send messages. >> Gnucash was not open when I placed the files in a folder. If that is what > you mean. >> Kind regards >> Christine >> >> -Original Message- >> From: John Ralls [mailto:jra...@ceridwen.us] >> Sent: 13 November 2017 01:55 >> To: Christine >> Cc: GnuCash >> Subject: Re: files >> >> >>> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user >> wrote: >>> >>> Hello >>> All my files are on the desktop where I saved them. So I put them in >>> a folder and now when I try to open one of the pages, it asks me to >>> save it, if I click on save it wants a new path, how can I work from >>> a main folder pls? >>> Christine >>> >> >> Please don't reply to messages when you want to start a new thread, it >> doesn't work. >> >> Was GnuCash running when you moved the files? >> >> Regards, >> John Ralls >> >> >> --- >> This email has been checked for viruses by Avast antivirus software. >> https://www.avast.com/antivirus >> > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: files
Christine, That is what I meant. How did you then open the file in the new location? What operating system/distro are you using? Regards, John Ralls > On Nov 13, 2017, at 8:35 AM, Christine wrote: > > Hi John > Sorry I panicked and could not find out where to send messages. Gnucash was > not open when I placed the files in a folder. If that is what you mean. > Kind regards > Christine > > -Original Message- > From: John Ralls [mailto:jra...@ceridwen.us] > Sent: 13 November 2017 01:55 > To: Christine > Cc: GnuCash > Subject: Re: files > > >> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user > wrote: >> >> Hello >> All my files are on the desktop where I saved them. So I put them in a >> folder and now when I try to open one of the pages, it asks me to save >> it, if I click on save it wants a new path, how can I work from a main >> folder pls? >> Christine >> > > Please don't reply to messages when you want to start a new thread, it > doesn't work. > > Was GnuCash running when you moved the files? > > Regards, > John Ralls > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: files
Hi John Sorry I panicked and could not find out where to send messages. Gnucash was not open when I placed the files in a folder. If that is what you mean. Kind regards Christine -Original Message- From: John Ralls [mailto:jra...@ceridwen.us] Sent: 13 November 2017 01:55 To: Christine Cc: GnuCash Subject: Re: files > On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user wrote: > > Hello > All my files are on the desktop where I saved them. So I put them in a > folder and now when I try to open one of the pages, it asks me to save > it, if I click on save it wants a new path, how can I work from a main > folder pls? > Christine > Please don't reply to messages when you want to start a new thread, it doesn't work. Was GnuCash running when you moved the files? Regards, John Ralls --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: files
> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user > wrote: > > Hello > All my files are on the desktop where I saved them. So I put them in a > folder and now when I try to open one of the pages, it asks me to save it, > if I click on save it wants a new path, how can I work from a main folder > pls? > Christine > Please don't reply to messages when you want to start a new thread, it doesn't work. Was GnuCash running when you moved the files? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: files
Hello All my files are on the desktop where I saved them. So I put them in a folder and now when I try to open one of the pages, it asks me to save it, if I click on save it wants a new path, how can I work from a main folder pls? Christine -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+cmaloney4=talktalk@gnucash.org] On Behalf Of Erik Colson Sent: 13 November 2017 00:21 To: Cam Ellison Cc: gnucash-user@gnucash.org Subject: Re: Finance-Quote 1.47 released! Cam Ellison writes: > On 12/11/17 08:27 AM, Erik Colson wrote: >> New version 1.47 of Finance-Quote is available with the following changes: >> >> * Use AlphaVantage for currency quotes instead of Yahoo (Mike Alexander) >> >> > FYI: USD->CAD now works, but not GBP->CAD. it does here: ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl GBP CAD GBP->CAD = 1.66540274 ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl CAD GBP CAD->GBP = 0.60045536 -- erik colson ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.