Hyperlinks from Excel and Word
Moderators: Developer, Contributor
Hyperlinks from Excel and Word
Hello.
Hyperlinks to Mantis issues from MS Excel and Word are not working correctly. For example if I have the following link inside a Word document or a Excel cell:
http://mantis/view.php?id=1824
For some reason clicking the link will redirect to http://mantis/my_view_page.php which is the default view when logging in to Mantis.
The strange thing here is that if I have the same hyperlink for example in my Outlook email editor, it works fine. Also if I click the link from this forum site it works perfectly. So I know there is nothing wrong with the link url itself. I have tested this behaviour with IE8, IE9, Mozilla Firefox -browsers and Office 2003, 2010 -products. This happens in both of my two Mantis versions: 1.2.1 and 1.1.1. So apparently this is a problem with Excel and Word.
Other users claim that this worked in our very old Mantis version 0.19.4 but I really don't know if that's true...
Have anyone experinced the same problem and is there possibly someone who could help? Any help much appreciated!
Thanks.
Hyperlinks to Mantis issues from MS Excel and Word are not working correctly. For example if I have the following link inside a Word document or a Excel cell:
http://mantis/view.php?id=1824
For some reason clicking the link will redirect to http://mantis/my_view_page.php which is the default view when logging in to Mantis.
The strange thing here is that if I have the same hyperlink for example in my Outlook email editor, it works fine. Also if I click the link from this forum site it works perfectly. So I know there is nothing wrong with the link url itself. I have tested this behaviour with IE8, IE9, Mozilla Firefox -browsers and Office 2003, 2010 -products. This happens in both of my two Mantis versions: 1.2.1 and 1.1.1. So apparently this is a problem with Excel and Word.
Other users claim that this worked in our very old Mantis version 0.19.4 but I really don't know if that's true...
Have anyone experinced the same problem and is there possibly someone who could help? Any help much appreciated!
Thanks.
Re: Hyperlinks from Excel and Word
Ok, thanks. Here's what I see:
Apache access log - a successfull attempt (from outlook mail editor):
[28/Oct/2010:13:46:24 +0300] "GET /view.php?id=1824 HTTP/1.1" 200 14104 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"
Apache access log - an unsuccessful attempt (from excel cell):
[28/Oct/2010:13:44:21 +0300] "GET /view.php?id=1824 HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0; ms-office)"
[28/Oct/2010:13:44:21 +0300] "GET /login_page.php?return=view.php%3Fid%3D1824 HTTP/1.1" 200 3758 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0; ms-office)"
[28/Oct/2010:13:44:22 +0300] "GET /login_page.php?return=view.php%3Fid%3D1824 HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"
[28/Oct/2010:13:44:22 +0300] "GET /my_view_page.php HTTP/1.1" 200 33489 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"
So there is some differences in the get-command. Does someone know how to fix this? Thanks.
Apache access log - a successfull attempt (from outlook mail editor):
[28/Oct/2010:13:46:24 +0300] "GET /view.php?id=1824 HTTP/1.1" 200 14104 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"
Apache access log - an unsuccessful attempt (from excel cell):
[28/Oct/2010:13:44:21 +0300] "GET /view.php?id=1824 HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0; ms-office)"
[28/Oct/2010:13:44:21 +0300] "GET /login_page.php?return=view.php%3Fid%3D1824 HTTP/1.1" 200 3758 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0; ms-office)"
[28/Oct/2010:13:44:22 +0300] "GET /login_page.php?return=view.php%3Fid%3D1824 HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"
[28/Oct/2010:13:44:22 +0300] "GET /my_view_page.php HTTP/1.1" 200 33489 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"
So there is some differences in the get-command. Does someone know how to fix this? Thanks.
Re: Hyperlinks from Excel and Word
Still banging my head with this one... Help anyone?
-
- Posts: 408
- Joined: 28 Jan 2011, 18:47
- Location: France
- Contact:
Re: Hyperlinks from Excel and Word
Hello
Sherlock Holmes is here !
Mantis uses cookies for authentication (to know if user is authenticated or not, mantis look a cookie)
When you click on a link in an office document, office try to open link instead of just giving the link to the web-browser
if IE (
) is the default browser, at each link you will have to login and link will works
else, first time you will have to login and link will works, but after, mantis will not prompt you to login and will redirect you to my_view_page.php
http://support.microsoft.com/kb/899927
Sherlock Holmes is here !

Mantis uses cookies for authentication (to know if user is authenticated or not, mantis look a cookie)
When you click on a link in an office document, office try to open link instead of just giving the link to the web-browser
if IE (

else, first time you will have to login and link will works, but after, mantis will not prompt you to login and will redirect you to my_view_page.php
http://support.microsoft.com/kb/899927
Lapinkiller,
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
Re: Hyperlinks from Excel and Word
Ok, that seems to be the problem here. So i guess we just have to live with it...
Thanks!
Thanks!
-
- Posts: 408
- Joined: 28 Jan 2011, 18:47
- Location: France
- Contact:
Re: Hyperlinks from Excel and Word
I have corrected this bug !
Patch attached on bug : http://www.mantisbt.org/bugs/view.php?id=13060
related to : http://www.mantisbt.org/bugs/view.php?id=13065
Patch attached on bug : http://www.mantisbt.org/bugs/view.php?id=13060
related to : http://www.mantisbt.org/bugs/view.php?id=13065
Lapinkiller,
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
Re: Hyperlinks from Excel and Word
Thanks a ton! Hope this is fixed in the next version of Mantis.
Re: Hyperlinks from Excel and Word
@Lapinkiller
I installed your patch to mantis 1.2.8, but unfortunately it does not resolve the issue.
Now all links clicked in an external application (excel, word, desktop shortcut etc) got to this url:
http://mantis.my.domain.com/mantis//man ... php?id=123
instead to
http://mantis.my.domain.com/mantis/view.php?id=123
I installed your patch to mantis 1.2.8, but unfortunately it does not resolve the issue.
Now all links clicked in an external application (excel, word, desktop shortcut etc) got to this url:
http://mantis.my.domain.com/mantis//man ... php?id=123
instead to
http://mantis.my.domain.com/mantis/view.php?id=123
-
- Posts: 408
- Joined: 28 Jan 2011, 18:47
- Location: France
- Contact:
Re: Hyperlinks from Excel and Word
take a look a my response on the bugtracker 

Lapinkiller,
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
Re: Hyperlinks from Excel and Word
I have just committed LapinKiller's patch.