1. Create a new spreadsheet 2. Add a formula: '=WEBSERVICE("https://www.example.net/foo/bar/")' The result is "ERR:540" ("External content disabled"). But there's no relevant infobar with a button to enable it; and I couldn't find related function in menus (or in "Edit Links" dialog). Saving and reloading the document indeed brings the infobar; but if I close it, I again cannot enable external content without reloading the document. Tested with Version: 6.4.3.1 (x64) Build ID: 4d2b2b47cca498fed6abf712a36d0788901091eb CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: CL
Created attachment 159458 [details] What I see =WEBSERVICE("https://www.bitstamp.net/api/ticker/") works fine for me. with your formula I get #VALUE! Error: Wrong data type Version: 7.0.0.0.alpha0+ (x64) Build ID: 95ec2e9b024ff12a3005777c902d7e0975460b1d CPU threads: 4; OS: Windows 10.0 Build 19592; UI render: Skia/Raster; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
I didn't yet found what is the setting that made that here. But do you see it if you save, reload, and close the infobar using closing cross?
Ok, I see Err:540 reloading the file but seems doesn't matter to do or not 'Allow updating', and the problem it's there with the link "https://www.example.net/foo/bar/" but not "https://www.bitstamp.net/api/ticker/"
Dear Mike Kaganski, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still pending... Even for a not newly created : - WEBSERVICE is updated at loading of file, should not if not allowed - if you ask for recalculate with F9 without any condition (recalculate hard), WEBSERVICE never will update again and show error 540 So i propose to check carefully the behavior of WEBSERVICE when - loading file - pushing "allow update" button - asking for recalculation, recalculation hard. tested in 7.5.9, 24.8.03 Windows.
(In reply to Mike Kaganski from comment #0) > 1. Create a new spreadsheet > 2. Add a formula: '=WEBSERVICE("https://www.example.net/foo/bar/")' > > The result is "ERR:540" ("External content disabled"). Not for me (testing 25.2 in Ubuntu). I get #VALUE!, the same as comment #1. (In reply to Mike Kaganski from comment #2) > But do you see Err:540 instead of #VALUE! if you reload (and allow updating)? Yes, and I guess it is surprising that it wouldn't re-evaluate to #VALUE!, although it seems fairly irrelevant to me whether it indicates an error or unknown value. This started in LO 6.2 with commit da9a6f426b61937d9cda17f5be3f82d2e15e6ecd Author: Eike Rathke on Thu Jul 19 17:39:02 2018 +0200 Related: tdf#118735 introduce FormulaError::LinkFormulaNeedingCheck (Err:540) To indicate why the result isn't available ("External content disabled") and in future maybe signal to the formula cell that it could keep the hybrid string result, see source code comment.
(In reply to Justin L from comment #6) The "ERR:540" or "#VALUE!" is irrelevant. The essence of the bug is: there is no way to enable external content. It should be possible at any time; it needs an UNO command for that.
Created attachment 196755 [details] 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
(In reply to Regis Perdreau from comment #5) > WEBSERVICE never will update again Sure it does. I opened webService.ods, did NOT allow updating, pressed F9 on one of the timestamp cells, and it turned into Err:540. Then I saved and reloaded, and this time I DID allow updating. The Err:540 at that point successfully pulled in new information.