Puppy Linux Discussion Forum

[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 )

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

[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

[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]

Hi flash, here a Scrreenshot,