The time now is Thu 26 Apr 2018, 15:32
All times are UTC - 4 |
Author |
Message |
firak
Joined: 14 Apr 2008 Posts: 174
|
Posted: Fri 16 Dec 2011, 04:43 Post subject:
Spreadsheets won't open hyperlink (Solved) Subject description: I try in Gnumeric and OpenOffice. |
|
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 )
|
Back to top
|
|
 |
russoodle

Joined: 12 Sep 2008 Posts: 716 Location: Down-Under in South Oz
|
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.
_________________ The mud-elephant, wading thru the sea, leaves no tracks..
|
Back to top
|
|
 |
firak
Joined: 14 Apr 2008 Posts: 174
|
Posted: Fri 16 Dec 2011, 10:36 Post subject:
Solved Subject description: is not a linux problem |
|
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
|
Back to top
|
|
 |
Flash
Official Dog Handler

Joined: 04 May 2005 Posts: 12825 Location: Arizona USA
|
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.
|
Back to top
|
|
 |
firak
Joined: 14 Apr 2008 Posts: 174
|
Posted: Sat 17 Dec 2011, 01:27 Post subject:
|
|
Hi flash, here a Scrreenshot,
Description |
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 |
Filesize |
78.97 KB |
Viewed |
2003 Time(s) |

|
|
Back to top
|
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|