[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

Heiko Tietze  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||8324

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #14 from Andreas Schmid  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl
 Resolution|--- |NOTABUG
 Status|NEW |RESOLVED

--- Comment #13 from Cor Nouws  ---
(In reply to Dan Dascalescu from comment #0)
> Pressing F9 should also update data inserted via Sheet -> Link to External
> Data.
However: 

(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #12 from QA Administrators  ---
** 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!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #11 from Eike Rathke  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #10 from Heiko Tietze  ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #9 from m.a.riosv  ---
(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?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

Heiko Tietze  changed:

   What|Removed |Added

 CC||er...@redhat.com,
   ||olivier.hallot@documentfoun
   ||dation.org

--- Comment #8 from Heiko Tietze  ---
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).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #7 from m.a.riosv  ---
(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:
=MID(WEBSERVICE("http://tycho.usno.navy.mil/timer.html;);166;21)(TODAY();"")
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #6 from Heiko Tietze  ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

--- Comment #5 from m.a.riosv  ---
(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]

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |
 Status|UNCONFIRMED |NEW
 CC|libreoffice-ux-advise@lists |tietze.he...@gmail.com
   |.freedesktop.org|
 Ever confirmed|0   |1

--- Comment #4 from Heiko Tietze  ---
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)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

Buovjaga  changed:

   What|Removed |Added

   Keywords||needsUXEval
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

Xisco Faulí  changed:

   What|Removed |Added

 Status|REOPENED|UNCONFIRMED
 CC||xiscofa...@libreoffice.org
 Ever confirmed|1   |0

--- Comment #3 from Xisco Faulí  ---
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114998] Externally Linked Data should update when pressing F9

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114998

Dan Dascalescu  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---
Summary|Externally Linked Data does |Externally Linked Data
   |not update when pressing F9 |should update when pressing
   ||F9
 Ever confirmed|0   |1

--- Comment #2 from Dan Dascalescu  ---
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 are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs