Pressing F9 on a cell with a =WEBSERVICE formula, fetches new data from the URL and recalculates (https://help.libreoffice.org/Calc/Recalculate).
Pressing F9 should also update data inserted via Sheet -> Link to External Data.
As a first step to making this possible, it would help if the linked data were visible to the user - see bug 114997.
External links can be updated through Menu/Edit/Links, they are not a formula.
Whether we as developers think external links are formulas or not, from a user's perspective, external links *are* much like formulas. A user could be linking to a sheet of currency prices that are updated externally by a server, just like =WEBSERVICE would fetch that URL.
Let's adopt a user-centric mindset and consider adding link update via F9 as a feature.
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Use case makes sense when you fill the sheet with stock exchange data, weather, ot many other information that needs an automatic but also manual update.
For example: =MID(WEBSERVICE("http://tycho.usno.navy.mil/timer.html");166;21) (shows the current time in UTC but F9 doesn't update)
(In reply to Heiko Tietze from comment #4)
> For example:
> =MID(WEBSERVICE("http://tycho.usno.navy.mil/timer.html");166;21) (shows the
> current time in UTC but F9 doesn't update)
But hard recalc does the update [Ctrl+Shift+F9]
(In reply to m.a.riosv from comment #5)
> But hard recalc does the update [Ctrl+Shift+F9]
Not for me, I need to change the formula (Linux/Fresh). And anyway, as long we do not understand webservice as an add-in functions it shouldn't depend on normal vs. hard recalculate.
(In reply to Heiko Tietze from comment #6)
> (In reply to m.a.riosv from comment #5)
> > But hard recalc does the update [Ctrl+Shift+F9]
> Not for me, I need to change the formula (Linux/Fresh). And anyway, as long
> we do not understand webservice as an add-in functions it shouldn't depend
> on normal vs. hard recalculate.
A formula like:
works for me with [F9], because it has a valatile function like TODAY()
With autoupdate it's calculated every time some cell is modified, it's how volatile funcitions work.
IMHO having WEBSERVICE() as volatile could make inoperable the spreedsheet when large files/pages are retrieved. If I'm not wrong one of the main purpose of the function is to work in combination with FILTERXLM().
Maybe having the Eike opinion will be the best.
After thinking about F9 or Ctrl+F9 I agree with the hard recalculate idea. We should make sure that it updates all links to external data (doesnt work for me) and change the help respectively (add-ins and external data, or the like).
(In reply to Heiko Tietze from comment #8)
> After thinking about F9 or Ctrl+F9 I agree with the hard recalculate idea.
> .(doesnt work for me)..
Maybe because is Shift+Ctrl+F9?
(In reply to m.a.riosv from comment #9)
> Maybe because is Shift+Ctrl+F9?
Nope. Neither clicking a button after adding Hard Recalc to the toolbar works.
I think we should not update externally linked data on F9 or Shift+Ctrl+F9, because that is what the LinkManager under menu Edit -> Links to External Data is for. This bug was submitted with the example of the WEBSERVICE function, for which the data previously could not be updated other than editing the formula using it, but now (master, 6.0.1 and 5.4.5) the link passed to WEBSERVICE is added to the LinkManager as well. Any recalculation should be done with the *current* data available in the spreadsheet document.
** Please read this message in its entirety before responding **
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 http://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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
(In reply to Dan Dascalescu from comment #0)
> Pressing F9 should also update data inserted via Sheet -> Link to External
(In reply to Eike Rathke from comment #11)
> I think we should not update externally linked data on F9 or Shift+Ctrl+F9,
> because that is what the LinkManager under menu Edit -> Links to External
> Data is for. This bug was submitted with the example of the WEBSERVICE
> function, for which the data previously could not be updated other than
> editing the formula using it, but now (master, 6.0.1 and 5.4.5) the link
> passed to WEBSERVICE is added to the LinkManager as well. Any recalculation
> should be done with the *current* data available in the spreadsheet document.
Represents a clear application behavior logic. So NotABug here.
The problem with the LinkManager is that it is completely unusable for the WEBSERVICE use case -- every link looks the same in the list, only for the selected one the "Source file" row down below displays a hint what item it refers to, and this item can be on any sheet in the file.
Thus, if you have >300 such WEBSERVICE cells, distributed over several sheets, there is no way you can find the particular cell you want to update right now.
And even if would display this info within one of the columns, this LinkManager then just represents a different table with less usability, where I would like to work directly in the table that is the actual sheet I'm working with.
Thus, updating the particular cell by pressing F9 is the only "clear application behavior logic" right now.