<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - hyperlink() not working" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129899#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - hyperlink() not working" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129899">bug 129899</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>(In reply to CSLam from <a href="show_bug.cgi?id=129899#c3">comment #3</a>) > 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*.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>