https://bugs.documentfoundation.org/show_bug.cgi?id=90433
Wolfgang Jäger <j...@psilosoph.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
CC| |j...@psilosoph.de
Ever confirmed|1 |0
--- Comment #5 from Wolfgang Jäger <j...@psilosoph.de> ---
I will try again:
1. What is wrong? See subject!
2. Steps to reproduce the bug:
- Create a new Calc doument.
- Go to B3 and Enter there (B3 refers to the respecive cell in the demo):
=IF(1>0;"No Link Here!";HYPERLINK("http://libreoffice.org";"Linked Now!"))
3. Expected Result (since 1>0 is TRUE):
- Cell will show "No Link Here!" with no URL being assigned.
- MouseOver the text or Ctrl+MouseOver will not offer to go to an URL.
4. Factual Result
4.a Setting. 'Ctrl-click required...' TICKED:
- MouseOver triggers the hint "Ctrl-Click to follow:No Link Here!"
4.a Setting. 'Ctrl-click required...' NOT TICKED:
- MouseOver triggers the hint "click to open hyperlink:No Link Here!"
4.c Both cases
- Click or Ctrl-Click respectivley brings up the error message:
"No Link Here!" is not an absolute URL that can be passed to an external
application to open it.
5. Analogous, demontsrated in cell B4:
- CHOOSE with at least one of the numbered result parameters containing a
syntactically accepatbel HYPERLINK expression will show the analogous bug if a
result was selected by the first parameter NOT returned by HYPERLINK.
6. Even a deeply wraped-in usage of the HYPERLINK function NOT EVALUATED
because of the actual conditions will make the cell wrongly "linked" to a non
existing URL. See cell B6 of the demo.
7. Evaluating to an error value (and only this) will break the wrong link.
- Demonstrated in cells B15, B16 of the demo sheet.
8 Special oddity (with a sophisticated example):
- See cell B12 of the attached sheet where the correct result 11 is shown.
- The hint given is "Ctrl-Click to follow link:22" Yes, 22!
I demontsrted the issue as best I could with the attached Calc doc. It may look
a bit to colourful to someone.
Of course, the bug does not block real work, but it brings to the surface that
there is something wrong, possibly with the tokenising of expressions
containing HYPERLINK but only having to evaluate it under conditions.
It is really hard to report a bug here.
Hi Joel! head up! I read your "Reality Essay" and I can feel with you.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
