[GNC] Libre Office question - worth a shot

[Stephen C. Camidge]

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 <scamidge at fastmail.fm> 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 at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>