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 Thu 02 Oct 2014, 08:29
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 Posts_count  
Author Message
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: Fri 16 Dec 2011, 04:43    Post_subject:  Spreadsheets won't open hyperlink (Solved)
Sub_title: 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: 665
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
Sub_title: 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: 11083
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   647 Time(s)

hhiper.jpg

Back to top
View user's profile Send_private_message 
Display_posts:   Sort by:   
Page 1 of 1 Posts_count  
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Business
Jump to:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0542s ][ Queries: 13 (0.0127s) ][ GZIP on ]