[GNC] Stock quotes
Ever since Yahoo shut down their service, I have not been able to get any stock quotes. I had been running a very old version, 2.6.15, I think, so I didn't try to resolve the issue but now I have updated to 3.4 and I still have the same problem. I have checked that I have the necessary version of Perl and gnc-fq-dump installed and I changed all my securities to retrieve quotes using yahoo_jason. From the command line I can get a quote: $ gnc-fq-dump yahoo_json googl Finance::Quote fields Gnucash uses: symbol: googl<=== required date: 05/17/2019 <=== recommended currency: USD <=== required last: 1168.78 <=\ nav: <=== one of these price: <=/ timezone: <=== optional but when I try from inside GNC I get the "Unknown Error" popup. Are there any debug logs I can look at to see what is going on? Perhaps I have too many securities? Is there a way to request just one from inside GNC? Thanks, Steve ___ 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] Stock quotes
Are you sure that ALL your securities are set to yahoo_json? If only ONE is set elsewhere, it wont work and you'll get this error. -derek On Fri, May 24, 2019 7:24 am, Steve wrote: > Ever since Yahoo shut down their service, I have not been able to get > any stock quotes. I had been running a very old version, 2.6.15, I > think, so I didn't try to resolve the issue but now I have updated to > 3.4 and I still have the same problem. > > I have checked that I have the necessary version of Perl and > gnc-fq-dump installed and I changed all my securities to retrieve > quotes using yahoo_jason. From the command line I can get a quote: > > $ gnc-fq-dump yahoo_json googl > Finance::Quote fields Gnucash uses: > symbol: googl<=== required > date: 05/17/2019 <=== recommended > currency: USD <=== required > last: 1168.78 <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > but when I try from inside GNC I get the "Unknown Error" popup. Are > there any debug logs I can look at to see what is going on? Perhaps I > have too many securities? Is there a way to request just one from > inside GNC? > > Thanks, > Steve > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Upcoming report deprecation
Too much to deal with in one reply. I'll split it up in smaller chunks. Op vrijdag 24 mei 2019 02:49:10 CEST schreef Frank H. Ellenberger: > Am Do., 23. Mai 2019 um 22:26 Uhr schrieb Geert Janssens > > : > > For clarity: I recommend the --extra switch *only* to experiment with > > these > > example reports (and possibly a few other experimental features). If you > > want to continue to use one for production reports, it should be > > installed as a custom report [1] > > I am still against removing or hiding them, special behind the same > flag as the bit rotten register2. I could argue the reports we're talking about are equally bit rotten. Both still compile and run, but other than that don't get any developer attention at all. I believe we'll simply have to agree to disagree here. And find a compromise that can work. > That is where menus are for: you can choose, there is no need to eat > the complete card. Again, I have different opinion. Going with your analogy: if there's too much on the menu it would take me too much time to find what I want to eat. Large projects like LibreOffice or their commercial counterpart Ms Office are aware of this and they do large usability studies in hopes of improving this. In the past I read several pointing out that too many options on a menu is actually a bad thing. Unfortunately we don't have access to such surveys for the GnuCash interface, so we have to work from limited data. At worst if no one reacts now the amount of user complaints afterwards could serve as our poor man's survey. If many complain then we can equally revert (part of) the decision. > The next time somebody may complain the business menu entries are > cluttering the whole appearance. > :-) I actually agree with that statement. In the past I have pondered a lot on how to shift to a different concept to group gnucash functionality in a way that's is more accessible than it is now. That is however a completely different topic and merits a thorough discussion on its own. The important difference though is we know the business features are actively used. So far no one indicated to be using the reports that were proposed to be removed from the menus. (With the notorious exception that you wrote they were useful to you in some way early on. I'll get back to that part in another mail.) > > So far noone who's actually using these reports has stepped up. A few have > > expressed concerns we may be dropping potentially valuable reports. > > You asked only english speaking users. You did not ask on the other > lanhuage lists. > Fair enough. I have now sent a similar mail on gnucash-nl. Feel free to solicit the other lists as well as I'm not subscribed there. 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] Upcoming report deprecation
Op vrijdag 24 mei 2019 02:49:10 CEST schreef Frank H. Ellenberger:
> Because these reports are translated, they serve also as a fallback
> for the missing translation of the incomplete documentation as they
> show a few aspects of what can be done with reports.
I'm not sure I understand what you're trying to convey here. Can you clarify
what you mean ?
Fwiw I have looked over the strings in these reports:
The daily reports has 4 strings that are unique to the report. Those are the
names of the reports and a short description.
In addition it has two strings it only shares with average-balance.scm
(related to showing subaccounts). I believe those should actually be aligned
with the other reports. They are not unique to these two reports, only
slightly formulated differently.
The average balance report adds 17 unique strings of which two are for the
report title and description and most others are for options specific to this
report. Of those again a number sound very similar to options in other reports
and can likely be aligned.
hello-world.scm probably does add the most unique strings, though most of them
are translations of things you'll need to understand in English anyway to
effectively write a custom report ("text option", "multi-column option",...).
The programming world unfortunately is very biased towards English. Function
names are almost always based on English terms. So I have my doubts on the
merits of translating those strings.
> When I played around decades ago with gnucash they had a promotional
> and a didactical use for me.
> Without them I had probaly choosen a different product, because the
> standard reports with their default setting were very US-GAAP
> oriented. And the examples told me it should be possible to get
> something conforming DE-GOB.
This part interests me more. I am curious now which report(s) exactly you are
referring to here ?
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] Upcoming report deprecation
Op vrijdag 24 mei 2019 02:49:10 CEST schreef Frank H. Ellenberger: > Am Do., 23. Mai 2019 um 22:26 Uhr schrieb Geert Janssens > > People that still want these reports can install them as explained in our > > Custom Reports wiki page [1]. > > That is ways to complicated and > where is the translation of that page to our over 50 supported languages? > I appreciate localization is your point of attention. However I take missing translations as an unfair objection. This is akin to asking to drop all undocumented features precisely because they lack documentation/translations. More in general I don't think it's realistic to block change just because it would require new documentation or translations. Keep in mind we're assuming the reports are not used (and other than your testimony there has been noone else so far claiming they have used or still use them). So it's not like we're asking everyone to jump through several hoops. As to the complexity of adding such a report, yes it's more complex. My ideal solution would have been this: - we provide an online repository with user contributed reports, similar to how kde-look or gnome-look websites host themes or wallpapers for their respective desktops - in gnucash you integrate an interface to this repository such that a user can browse available reports and install those that interest them. Unfortunately I don't have time to implement this. And I want to balance the work to spend on that against the general use of these reports. For popular reports such effort could pay off though popular reports would likely get included in the main code instead. So far it looks like the reports we talk about are hardly used if at all. But I'll wait some more for feedback from other lists. Regards, 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] Upcoming report deprecation
> On May 24, 2019, at 7:41 AM, Geert Janssens > wrote: > > > My ideal solution would have been this: > - we provide an online repository with user contributed reports, similar to > how kde-look or gnome-look websites host themes or wallpapers for their > respective desktops Is it possible to accomplish this using GitHub? Just curious... Regards, Adrien ___ 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] Upcoming report deprecation
Hi, On Fri, May 24, 2019 12:12 pm, Adrien Monteleone wrote: > > >> On May 24, 2019, at 7:41 AM, Geert Janssens >> wrote: >> >> >> My ideal solution would have been this: >> - we provide an online repository with user contributed reports, similar >> to >> how kde-look or gnome-look websites host themes or wallpapers for their >> respective desktops > > Is it possible to accomplish this using GitHub? Just curious... I don't think so. It would require people to push to github, which is effectively the same as current commiters. The wiki would be a better place. It opens it up to more people. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Upcoming report deprecation
I considered that, but didn’t think GitHub would be a hurdle for someone who has had to or is learning Scheme. Certainly the wiki would be more open. Regards, Adrien > On May 24, 2019, at 11:20 AM, Derek Atkins wrote: > > Hi, > > On Fri, May 24, 2019 12:12 pm, Adrien Monteleone wrote: >> >> >>> On May 24, 2019, at 7:41 AM, Geert Janssens >>> wrote: >>> >>> >>> My ideal solution would have been this: >>> - we provide an online repository with user contributed reports, similar >>> to >>> how kde-look or gnome-look websites host themes or wallpapers for their >>> respective desktops >> >> Is it possible to accomplish this using GitHub? Just curious... > > I don't think so. It would require people to push to github, which is > effectively the same as current commiters. > > The wiki would be a better place. It opens it up to more people. > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > > ___ 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] Upcoming report deprecation
Op vrijdag 24 mei 2019 18:20:22 CEST schreef Derek Atkins: > Hi, > > On Fri, May 24, 2019 12:12 pm, Adrien Monteleone wrote: > >> On May 24, 2019, at 7:41 AM, Geert Janssens > >> wrote: > >> > >> > >> My ideal solution would have been this: > >> - we provide an online repository with user contributed reports, similar > >> to > >> how kde-look or gnome-look websites host themes or wallpapers for their > >> respective desktops > > > > Is it possible to accomplish this using GitHub? Just curious... > > I don't think so. It would require people to push to github, which is > effectively the same as current commiters. > > The wiki would be a better place. It opens it up to more people. > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek The wiki was what David T suggested initially in the bug report. John didn't think a wiki to be a good place to park source files and I tend to agree. As for the github suggestion: it *is* currently our de facto online repository. And a repository with benefits: all reports in there are at least guaranteed to compile... The downside of this particular repo of course is it has limited write access and we're not inclined to change that soon. Both options still depend on the user copying a source file from somewhere into a specific location on their PC and write a line of code in another file. It's all still manual. 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] Upcoming report deprecation
On Fri, 24 May 2019, Adrien Monteleone wrote: Is it possible to accomplish this using GitHub? Just curious... What about a GnuCash wiki? Rich ___ 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] Upcoming report deprecation
Just noting that when I suggested originally that these reports be stored on the wiki, rather than in the application, I was told unequivocally that the wiki was NOT the proper place for these files. On May 24, 2019, at 9:51 PM, Derek Atkins wrote: Hi, On Fri, May 24, 2019 12:12 pm, Adrien Monteleone wrote: > > >> On May 24, 2019, at 7:41 AM, Geert Janssens >> wrote: >> >> >> My ideal solution would have been this: >> - we provide an online repository with user contributed reports, similar >> to >> how kde-look or gnome-look websites host themes or wallpapers for their >> respective desktops > > Is it possible to accomplish this using GitHub? Just curious... I don't think so. It would require people to push to github, which is effectively the same as current commiters. The wiki would be a better place. It opens it up to more people. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Upcoming report deprecation
> On May 24, 2019, at 9:20 AM, Derek Atkins wrote: > > Hi, > > On Fri, May 24, 2019 12:12 pm, Adrien Monteleone wrote: >> >> >>> On May 24, 2019, at 7:41 AM, Geert Janssens >>> wrote: >>> >>> >>> My ideal solution would have been this: >>> - we provide an online repository with user contributed reports, similar >>> to >>> how kde-look or gnome-look websites host themes or wallpapers for their >>> respective desktops >> >> Is it possible to accomplish this using GitHub? Just curious... > > I don't think so. It would require people to push to github, which is > effectively the same as current commiters. > > The wiki would be a better place. It opens it up to more people. Gramps does exactly that with https://github.com/gramps-project/addons. But that's the easy part. Getting GnuCash to work with the repository is more difficult and time consuming. That's what Geert doesn't have time for. Regards, John Ralls ___ 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] Upcoming report deprecation
On 5/24/19 9:40 AM, Geert Janssens wrote: > Op vrijdag 24 mei 2019 18:20:22 CEST schreef Derek Atkins: >> Hi, >> >> On Fri, May 24, 2019 12:12 pm, Adrien Monteleone wrote: On May 24, 2019, at 7:41 AM, Geert Janssens wrote: My ideal solution would have been this: - we provide an online repository with user contributed reports, similar to how kde-look or gnome-look websites host themes or wallpapers for their respective desktops >>> Is it possible to accomplish this using GitHub? Just curious... >> I don't think so. It would require people to push to github, which is >> effectively the same as current commiters. >> >> The wiki would be a better place. It opens it up to more people. >> >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> -derek > The wiki was what David T suggested initially in the bug report. John didn't > think a wiki to be a good place to park source files and I tend to agree. > > As for the github suggestion: it *is* currently our de facto online > repository. And a repository with benefits: all reports in there are at least > guaranteed to compile... 1. I would hate to see this embedded in the current repository for GnC. 2. A separate area for various contributions that would not be maintained by the devs over time. Not guaranteed to compile for future releases. 3. I do have a version of Balance Sheet that is moving away from guile (haven't made it all the way yet) but better formatted that the non-guile version. I haven't contributed it yet since I'm not satisfied with the indenting on it. However, a less strict repository for sharing would be welcome. Have to be able to bundle multiple files as a small package (my Balsheet-Formatted has 3 source code files). > The downside of this particular repo of course is it has limited write access > and we're not inclined to change that soon. > > Both options still depend on the user copying a source file from somewhere > into a specific location on their PC and write a line of code in another > file. > It's all still manual. As is rolling your own. > > 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. > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Upcoming report deprecation
> On May 24, 2019, at 9:54 AM, Stephen M. Butler wrote: > > 3. I do have a version of Balance Sheet that is moving away from guile > (haven't made it all the way yet) but better formatted that the > non-guile version. I haven't contributed it yet since I'm not satisfied > with the indenting on it. However, a less strict repository for sharing > would be welcome. Have to be able to bundle multiple files as a small > package (my Balsheet-Formatted has 3 source code files). I trust that you mean it's moving away from eguile. Writing reports without Guile itself would require a great deal of boilerplate code. Regards, John Ralls ___ 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] open network paths in gnucash
On Fri, May 24, 2019 at 12:01 PM wrote: > Date: Thu, 23 May 2019 21:00:17 -0700 > From: John Ralls > > > On May 23, 2019, at 8:03 PM, Eric Haszlakiewicz < > hawicz+gnuc...@gmail.com> wrote: > > > > Hi, I just updated to gnucash 3.5 and for the life of me I can't figure > out > > how to open my files. Now, when I try to e.g. import an qfx file, there > > doesn't seem to be anyway for me to type in the network path where it is. > > (i.e. \\myserver.example.com\some\path) > > How do I do this now? Why isn't this using the regular file dialog? > Argh! > > That's https://bugs.gnucash.org/show_bug.cgi?id=796871. The work around > is to map it to a drive letter. > hmm... related, but not quite entirely what I'm complaining about. > By "regular file dialog" you mean the Windows native file chooser? It > doesn't use it because we need to add the backend selector, so we have to > use GtkFileChooser instead of GtkNativeFileChooser. > What's a "backend selector"? Do you mean the "Data Format" dropdown when opening a completely new .gnucash file? That isn't present when importing files, so the native file chooser could be used, no? I found an alternate workaround: open a windows explorer window and navigate to somewhere on my network drive, then drag a folder over to gnucash's file chooser. I still don't get a way to type in my file path or name, which is quite frustrating, and it doesn't show the hostname of the server, but at least I can see the folder names and click around to get to things without all the overhead of mapping a drive. Eric ___ 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] Upcoming report deprecation
On 5/24/19 10:21 AM, John Ralls wrote: > >> On May 24, 2019, at 9:54 AM, Stephen M. Butler wrote: >> >> 3. I do have a version of Balance Sheet that is moving away from guile >> (haven't made it all the way yet) but better formatted that the >> non-guile version. I haven't contributed it yet since I'm not satisfied >> with the indenting on it. However, a less strict repository for sharing >> would be welcome. Have to be able to bundle multiple files as a small >> package (my Balsheet-Formatted has 3 source code files). > I trust that you mean it's moving away from eguile. Writing reports without > Guile itself would require a great deal of boilerplate code. You are correct. Slow going project. > Regards, > John Ralls > > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Libre Office question - worth a shot
I found a workaround that I can live with. Move the worksheet in workbook A to workbook B. Then it can automatically update to/from the other worksheets in workbook B. Excel can do this even if I leave it in workbook A - pity LO cannot, but I should not complain about the limitations of free software, just be grateful for what it can do (which is a lot). Thank you to all, Steve -- On Thu, May 23, 2019, at 4:40 PM, Adrien Monteleone wrote: > Steve, > > In LO preferences, set links to update Automatically (for trusted > sources) > Under Macro Security, make sure you are *not* using the “Very High” > setting, “High" or less is fine. > Then under Macro Security, Trusted Sources, in the file section, add a > local path where your files are stored. (I just added /, which might > not be safe, but it is fine for me, also, adding a path isn’t necessary > with the Low security setting) > > Now, when you open the file with the links, it will simply update them > without asking. > > If you want to have the links update without having to close and > re-open a file, such as having both spreadsheets open at the same time > and getting changes in one while updating the other, then instead of > copy/pasting or using normal references to other files, use the DDE > feature: > > https://help.libreoffice.org/index.php?title=Calc/Spreadsheet_Functions&Language=en-GB&System=WIN&Version=5.1#bm_id3154680 > > Now, when you edit the source file and save it (that’s important) when > you click in the file with the links, they will auto-update. The help > document linked above says you have to use File > Reload (or close, > open) but I just tested this and it works simply by making that window > active. (this might be a preference I set and forgot about however) > > Note the limitation that cross-platform links are not allowed using > DDE. (you can’t link a Linux spreadsheet from a Windows spreadsheet) > > Unfortunately, LO does not have a keyboard shortcut for Reload, or Edit > > Links > Update, either of which would be very convenient and get you > the same ease of use without DDE. > > Regards, > Adrien > > > On May 23, 2019, at 11:50 AM, Stephen C. Camidge > > wrote: > > > > Sorry, this is off topic but I am quite frustrated and several of you will > > know Libre Office. > > > > I have 2 spreadsheets that are linked, but unlike the behaviour in Excel, > > Libre Office will not refresh the links automatically when I make a change. > > I have set the preferences under Calc Tools and under Macro Security to > > refresh. This allows undates when the file is opened. > > > > How do I get automatically refreshed links when both files are open? > > > > Thank you. > > Steve > > > ___ > 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] open network paths in gnucash
> On May 24, 2019, at 2:10 PM, Eric Haszlakiewicz > wrote: > > On Fri, May 24, 2019 at 12:01 PM wrote: > > > >> By "regular file dialog" you mean the Windows native file chooser? It >> doesn't use it because we need to add the backend selector, so we have to >> use GtkFileChooser instead of GtkNativeFileChooser. >> > > What's a "backend selector"? Do you mean the "Data Format" dropdown when > opening a completely new .gnucash file? That isn't present when importing > files, so the native file chooser could be used, no? Yes. You're right, it's not present for file import, though it is for open and save as as well as new. Regards, John Ralls ___ 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] Libre Office question - worth a shot
Certainly, there may be special cases where you need to have worksheets/tabs in separate files. This is not a common use case, but not entirely out of the ordinary either, especially in a multi-user environment. Most spreadsheet applications can handle 65K+ individual sheets/tabs. If there is no special or overriding reason for them to be in separate files, life is certainly easier if they are all in one. (most users do not realize this) Glad to hear you found a path that works for you. Regards, Adrien > On May 24, 2019, at 4:44 PM, Stephen C. Camidge wrote: > > I found a workaround that I can live with. Move the worksheet in workbook A > to workbook B. Then it can automatically update to/from the other worksheets > in workbook B. > > Excel can do this even if I leave it in workbook A - pity LO cannot, but I > should not complain about the limitations of free software, just be grateful > for what it can do (which is a lot). > > Thank you to all, > Steve > ___ 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.
