Apache OpenOffice (AOO) Bugzilla – Issue 14310
hyperlink in calc cell does not work if mozilla browser not already open
Last modified: 2013-08-07 15:15:02 UTC
1. Insert a hyperlink (URL) into a cell in a calc spreadsheet. 2. In OOo Tools->Options->OpenOffice.org->External Programs, set up HTTP input line to point to Mozilla. 3. With Mozilla closed, click on hyperlink in calc cell; nothing happens. 4. Open Mozilla browser, click on hyperlink in calc cell; web brower goes to URL hyperlinked in calc cell. This works ok in 1.0.2. (RedHat version): For step 3, Mozilla opens and goes to URL hyperlinked in calc cell. This was observed in RedHat 9 with Mozilla 1.2.1.
Hi Thorsten, could you please have a look at this.
I believe this is the same problem as in issue 14825.
TM->OBR: As discussed via phone, I sent this one to you.
The problem is probably that OpenOffice.org shipps with mozilla libraries. Even worse, when launching mozilla, it inherits the LD_LIBRARY_PATH set in the OOo start script. This can we worked around bu either unsetting the LD_LIBRARY_PATH in the mozilla start script, or by creating a special oomozilla script that does this job and launches mozilla afterwards. I agree that the mechanism should be changed so that mozilla does no longer inherit the OOo environment. Unfortunatly it is very late in the game (1.1), so I set the target to 2.0.
*** Issue 14825 has been marked as a duplicate of this issue. ***
Installed OOo1.1RC onto same system as original report, with same version of Mozilla running. Now, Hyperlink in spreadsheet will not work at all in 1.1RC, whether Mozilla is open or not. This is true for both URL links and mailto links. Tried both Mozilla Option 1 and Mozilla Option 2 choices in the setup of External Programs in the Tools/Options setttings, and browsed to the Mozilla exe in usr/bin for the Http and mailto input bars. Also installed OOo1.1RC onto another system, with same operating system and same version of Mozilla. URL link pointed to Mozilla will not work there as well. This system uses Ximian for mailto link, and the mailto link works for this setup.
further info of possible interest: konqueror, opera and lynx work. mozilla and galeon do not. all tested on RH9 with 1.1RC.
Created attachment 7886 [details] mozilla wrapper script
I just checked on a RH 9 machine here: I can reproduce your original bug report, but _not_ that it got worse and doesn't work when mozilla is already running. Please make sure you specified mozilla for all url types. I have attached a shell script that should work around the original issue. To use it, make sure it has execute permissions and configure it instead of mozilla as the browser to use.
My workaround for this issue is to open my file in 1.0.2 (RH9 version) if I want a URL or email addr from my spreadsheet file, and that works well for me. Setup in 1.0.2: Send doc as email using Netscape 6.x HTTP: file:///usr/bin/mozilla MAILTO: file:///usr/bin/mozilla I used the browse buttons to point to mozilla in both cases. Setup in 1.1RC: In default email program, I have tried Mozilla 1.x (Option 1), Mozilla 1.x (Option 2), Netscape 6.x-7 (Option 1) and Netscape 6.x-7 (Option 2). For path, I browse to mozilla. When I first hit the browse button, for Mozilla Option 1, I get a message that says /opt/mozilla does not exist, but I can browse to where my mozilla lives, and the path shows as /usr/bin/mozilla. The error box closes and a box to browse to the file pops up. I have tried with this field blank as well. And the other fields set up: HTTP: /usr/bin/mozilla MAILTO: /usr/bin/mozilla I used the browse buttons to point to mozilla in both cases. Note that the file path shows up differently in this version, than in 1.0.2. I removed 1.1Beta, so I cannot see what my settings were there. None of the attempts have worked in 1.1RC so far. Do you see an error in my setup? How is your redhat 9 set up? Maybe I can mimic it here. I am not eager to add the script file; although I very much appreciate your offer to share it to help solve my issue. Thank you.
The setup you describe works pretty well on the machine here - although I didn't get this /opt error message. But the Mozilla installed on that machine seems not to support the mailto protocol, although it lives at the same place as yours (and identifies itself as 1.2.1 as well). So mailto urls don't work for me either - which is not the fault of OOo in thiscase - but http urls do. I don't know of anything special regarding the RH 9 installation. Where did you get OOo from ? Did you download it an install set ?
We downloaded OOo1.1RC from ibiblio.org through a link on the OOo web site.
Fixed in CWS defaultbrowser.
obr->atr: please verify.
ATR: verified in cws befaultbrowser, bug is fixed.
.
ATR: Checked again in the master, bug is fixed.