Spreadsheets won't open hyperlink (Solved)

Business software, financial software, etc.
Post Reply
Message
Author
firak
Posts: 175
Joined: Mon 14 Apr 2008, 14:07

Spreadsheets won't open hyperlink (Solved)

#1 Post by firak »

Spreadsheet – don't open hyperlink

I try in gnumeric and OpenOffice.
In both -function non supported – or check desktop config – errors.
In both I did not find a setting config that points to this setting.
I have a list of 3000 links, and I'm creating a kind of database of this documents with a Spreadsheet.
Would be very useful to open this docs from the sheet itself, calling the default browser.
Is somebody kows how ?
(macpup 528 + OpenOfc-3.3.0_en-US_sfs4.sfs )

User avatar
russoodle
Posts: 707
Joined: Fri 12 Sep 2008, 17:36
Location: Down-Under in South Oz

#2 Post by russoodle »

Hello firak,

I don't know the answer to this as i don't use spreadsheets, but Macpup 528 is based on Lupu 528, so you might find some helpful information in the thread for Lupu here: http://www.murga-linux.com/puppy/viewtopic.php?t=70855.

It's a very long thread, but you might find the answers you're looking for if you read through it. If you don't find what you want, you could post there and ask, but please read the thread first.
[i][color=Green][size=92]The mud-elephant, wading thru the sea, leaves no tracks..[/size][/color][/i]

firak
Posts: 175
Joined: Mon 14 Apr 2008, 14:07

Solved

#3 Post by firak »

It was a problem of writing a good formula in spreadsheet,
Was not a problem of Linux.
The way I solved:
so if column A as a link list,
column B has now this formula:
=HYPERLINK("file://"&$A1)
stretched down, so A1 become A2,A3,etc..

It was an XL issue,

Sorry

User avatar
Flash
Official Dog Handler
Posts: 13071
Joined: Wed 04 May 2005, 16:04
Location: Arizona USA

#4 Post by Flash »

Firak, could you post an example? Perhaps a screenshot of a small spreadsheet with links done as you describe? (You can use mtPaint to crop out everything but the relevant parts.) Thanks. :)

firak
Posts: 175
Joined: Mon 14 Apr 2008, 14:07

#5 Post by firak »

Hi flash, here a Scrreenshot,
Attachments
hhiper.jpg
Screenshot of a list of files(culumn A), and a hiperlinkn of it in columunm B . In the selected cell, the formula that make the hipelink
(78.97 KiB) Downloaded 2262 times

Post Reply