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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from CSLam <silvermine92 at gmail.com> ---
Appreciate your explanation, which appears to tell why Calc is performing in
such a manner.  Yet, this is ony a technical explanation of the situation, but
the issue remains unresolved.  LibreOffice is designed for the average people,
I guess, who may not be technically inclined.  I am seeing some issues here :-

1. There was not such an issue in the past, and "#" embedded in URL had been
working perfectly, until more recentely; I think trouble begins from version
6.4.  As such, at least in my case, there have been a good volume of
spreadsheets already created with "#" embedded URL.  The change as introduced
more recently is practically asking the public to revise everything, if they
want not to see the error.

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.

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.

Naturally, I still hope LibreOffice can be updated to return to the previous
URL handling.

CSLam

-- 
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/eeadae9f/attachment.htm>