https://bugs.documentfoundation.org/show_bug.cgi?id=132003
--- Comment #8 from Justin L <[email protected]> --- Created attachment 196755 --> https://bugs.documentfoundation.org/attachment.cgi?id=196755&action=edit webService.ods: my testing document (In reply to Regis Perdreau from comment #5) > - WEBSERVICE is updated at loading of file, should not if not allowed I can't reproduce. It doesn't update on FILEOPEN if I cancel "Allow Updating". Tested 7.5.0, 7.5.10, 24.8.2. > if you ask to recalculate the cell with F9 > or the entire sheet with Ctrl-Shift-F9 (recalculate hard), > WEBSERVICE never will update again and show error 540 Showing error 540 is true only if you don't allow updating, and yet decide to manually request an update anyway. However, if you do allow updating, the manual requests to recalculate will have no effect. F9 and Ctrl-Shift-F9 worked until 6.1 commit 93ea7cb6b5ab3c9b964b2b38e8f4a3bde71dbadf Author: Caolán McNamara on Thu Jan 11 20:43:28 2018 +0000 handle ocWebservice similarly to ocDde That same commit seemed to start implementing caching - so that if the same URL is used in two cells, the second one is simply a copy of the first use. Prior to that commit, =WEBSERVICE("https://www.bitstamp.net/api/ticker/";) in two different cells would likely contain different timestamp values. P.S. The allow updating prompt also started in 6.1 (initially as a dialog), but turned into an infobar with 6.1 commit ff5cb6cb34e42b290affc75703a93de1d24d0bc6 Author: Caolán McNamara on Fri Jan 12 16:12:59 2018 +0000 turn update links warning dialog into an infobar -- You are receiving this mail because: You are the assignee for the bug.
