Make Hyperlink Text and Target in Calc Share the Same Value

Discuss the presentation application

Make Hyperlink Text and Target in Calc Share the Same Value

Postby Warlord Kentax » Thu Mar 29, 2018 7:44 am

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.

cYYJ4ym.png

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
Warlord Kentax
 
Posts: 3
Joined: Wed Dec 31, 2008 10:12 pm

Return to Impress

Who is online

Users browsing this forum: No registered users and 2 guests