[Libreoffice-bugs] [Bug 129899] hyperlink() not working

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to CSLam from comment #3)
> 2. While appreciating the meaning of "#" in the technical world, this
> particular thing is a valid filename character.  In other words, there are
> indeed files in the world that bears "#", which is not meant for the said
> technical spearation.  A good example is "Receiveable Account
> #000-00000-000.ods".  I believe it is obvious that this file refers to a
> particular account, but not anything else.

No. It is *not* obvious. "#" in URL is a *point in a document* (like an entry
of Contents you may see on any Wikipedia page, which leads you to a heading
inside this same page); it is not something "technical" - it's something
without which you *cannot* say "Open document X and navigate to chapter Y". So
proper use of # is essential when working with links - and no amount or
reasoning that "average people" should be comfortable with it will change that
fact. When using HYPERLINK spreadsheet function, user *must* learn URLs and
their peculiarities - because those are not separable; and the very existence
of ENCODEURL function is because of those complexities.

> 3. I do not know if it is correct to say so, but the "#" character in the
> URL is inside quotes, not outside.  It looks strange why LibreOffice is not
> interpreting the entire piece as a single string, but doing some
> manipulation prior to relaying the information to somewhere.

Quotes is Calc way to pass strings to functions; and entire URL, including the
fragment will necessarily be inside quotes - it would be a syntax error if #
and fragment were outside. So this argument is incorrect.

However, and having said all that, I repeat that for me, HYPERLINK works as
*you* would expect (i.e., *wrong*) with LO 6.4.0.1 - so possibly you need to
explain better what doesn't work for you, *with a sample file*.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200110/90ac37ae/attachment.htm>