Page 1 of 1

Calc, hyperlink between sheets using a linked cell

Posted: Thu Jun 05, 2008 2:13 pm
by Rod_G
Welcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using? V 2.4
What Operating System (version) are you using? Vista
What is your question or comment? I opened a spreadsheet in OO (calc) that was created in excel 2003, the hyperlinks that were words like "Go to" or "Summary" still work but hyperlinks that are a linked cell(number) from a different sheet do not work ???

Re: Calc, hyperlink between sheets using a linked cell

Posted: Tue Jun 17, 2008 7:06 pm
by TerryE
Sorry but I don't understand your explanation. Why not upload a short example of what you mean.

Re: Calc, hyperlink between sheets using a linked cell

Posted: Sat Jun 21, 2008 7:56 am
by easwar
I opened a spreadsheet in OO (calc) that was created in excel 2003, there are hyperlinks which open certain Intranet sites and html files. However these are not opening in OO. How can open these hyperlink in OO.

Please help
Thanks Easwar
 Edit: Text tidied by TerryE 

Re: Calc, hyperlink between sheets using a linked cell

Posted: Sat Jun 21, 2008 12:33 pm
by TerryE
One topic. Two possibly (not) related issues.

Guys, I can't replicate either and with you providing more details or an example then we can't help you. I've attached a little test that I did. Two XLS files both with a hyperlink in; one with a link to the other. Both created in Excel 2003 and open fine in OOo 2.4.1. Now you tell me why your issues are different.