My problem is that whenever I make a hyperlink to a cell in my openoffice calc spreadsheet, the hyperlink displays as either a long directory address C:\Users\Kentax\Desktop\Jeopardy.ods#$Sheet1.$A2 or as a custom label that I assign in the Further Settings section of the Hyperlink settings.
Make Hyperlink Text and Target in Calc Share the Same Value
-
Warlord Kentax
- Posts: 3
- Joined: Wed Dec 31, 2008 10:12 pm
Make Hyperlink Text and Target in Calc Share the Same Value
I'm attempting to use Impress to do a Jeopardy game. It works fairly well, but entering each question each answer and each category into Impress is a pain. I'd rather just enter all of these items into openoffice calc.
My problem is that whenever I make a hyperlink to a cell in my openoffice calc spreadsheet, the hyperlink displays as either a long directory address C:\Users\Kentax\Desktop\Jeopardy.ods#$Sheet1.$A2 or as a custom label that I assign in the Further Settings section of the Hyperlink settings.
I want to make the value of the targeted cell in calc display as the text on the slide in impress.
My problem is that whenever I make a hyperlink to a cell in my openoffice calc spreadsheet, the hyperlink displays as either a long directory address C:\Users\Kentax\Desktop\Jeopardy.ods#$Sheet1.$A2 or as a custom label that I assign in the Further Settings section of the Hyperlink settings.
I want to make the value of the targeted cell in calc display as the text on the slide in impress.
OOo 3.0.X on MS Windows Vista