Puppy Linux Discussion Forum

firak · Joined: 14 Apr 2008 Posts: 172

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 )

russoodle · Posted: Fri 16 Dec 2011, 07:57 Post subject:

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.

firak · Joined: 14 Apr 2008 Posts: 172

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

Flash · Posted: Fri 16 Dec 2011, 16:05 Post subject:

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. Smile

firak · Joined: 14 Apr 2008 Posts: 172

Hi flash, here a Scrreenshot,