Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Fri 25 Jul 2014, 13:43
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Business
Spreadsheets won't open hyperlink (Solved)
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [5 Posts]  
Author Message
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: 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
View user's profile Send private message 
russoodle


Joined: 12 Sep 2008
Posts: 654
Location: Down-Under in South Oz

PostPosted: 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.

_________________
This aging business really bugs me - it didn't bother me years ago, so why is it happening now??
meownplanet - puppylinuxstuff
Back to top
View user's profile Send private message 
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: 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
View user's profile Send private message 
Flash
Official Dog Handler


Joined: 04 May 2005
Posts: 10930
Location: Arizona USA

PostPosted: 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
Back to top
View user's profile Send private message 
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: Sat 17 Dec 2011, 01:27    Post subject:  

Hi flash, here a Scrreenshot,
hhiper.jpg
 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   611 Time(s)

hhiper.jpg

Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 1 [5 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Business
Jump to:  

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
[ Time: 0.0445s ][ Queries: 12 (0.0032s) ][ GZIP on ]