LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop
User Name
Password
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.

Notices

Reply
 
LinkBack Search this Thread
Old 11-01-2011, 02:29 PM   #1
Myrlin
Member
 
Registered: Mar 2006
Distribution: Archlinux
Posts: 42

Rep: Reputation: 15
Libreoffice Calc - Hyperlink Problems


I have a large collection of photographs, which are documented in a spreadsheet which I originally produced in OpenOffice. Each entry is hyperlinked to the image. Most of the image filenames contain spaces.

I have just tried to use the spreadsheet, and discovered that Libreoffice will not link to a file (or folder) with a name containing spaces (e.g. /path/to/imagename with spaces.jpg).

It is a long time since I have used this document, so I am not sure whether it has ever worked in Libreoffice, but it worked perfectly in Openoffice.

I am using Archlinux, LXDE, and pcmanfm.

This is a real problem. I really do not want to have to rename hundreds of files just for the benefit of Libreoffice (and in any case some other applications use the names as they are, so they would fail).

I would be very grateful for any advice.

Thanks in advance.


P.S. I've just discovered that Libroffice Writer has the same problem, so it looks like it's package-wide.

Last edited by Myrlin; 11-01-2011 at 03:23 PM.
 
Old 11-01-2011, 07:13 PM   #2
frankbell
Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Debian, Mageia, Mint
Posts: 6,907

Rep: Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285
This is just a shot in the dark.

Try replacing the spaces in one item with %20 or one of the other HTML codes for a space and testing.

If it works, you can use LO search/replace to do all the links.
 
Old 11-02-2011, 05:51 AM   #3
Myrlin
Member
 
Registered: Mar 2006
Distribution: Archlinux
Posts: 42

Original Poster
Rep: Reputation: 15
Many thanks for you fast reply, Frank.

The original spreadsheet does, in fact, replace spaces with %20.

I have tried just using a space, and I have tried a variety of types of file, but all fail. Writer and Calc always perform in exactly the same way.
 
Old 11-02-2011, 08:13 PM   #4
frankbell
Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Debian, Mageia, Mint
Posts: 6,907

Rep: Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285
Another thought would be to replaces the spaces with underscores in the file names; that would be easy enough in the spreadsheet.

You could write a script or try using midnight commander to do a bulk rename of the picture files.

I don't have enough scripting experience to dash one off without about three hours research, but there are folks here who can.

I would make copies of everything, then try making the changes on the copies.
 
Old 11-03-2011, 02:38 PM   #5
Myrlin
Member
 
Registered: Mar 2006
Distribution: Archlinux
Posts: 42

Original Poster
Rep: Reputation: 15
Thanks Frank.

Yes, I know I could do this as a workaround (and I may have to eventually), but that's not really the point. I just want the package to work as it should (and as it used to). If Gnucash/Viewnior etc can cope with spaces, Libreoffice really should!!

Many thanks again for your help.
 
Old 11-03-2011, 07:00 PM   #6
frankbell
Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Debian, Mageia, Mint
Posts: 6,907

Rep: Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285Reputation: 1285
Please let us know how this turns out.
 
Old 11-04-2011, 06:16 AM   #7
Myrlin
Member
 
Registered: Mar 2006
Distribution: Archlinux
Posts: 42

Original Poster
Rep: Reputation: 15
I've done a lot more analysis, and discovered that the fault appears to lie somewhere within LXDE itself.

I installed XFCE out of frustration, and everything worked perfectly using both Thunar and pcmanfm as filemanagers, so Libreoffice, Thunar and Pcmanfm seem to be innocent.

I don't really want to abandon LXDE in favour of XFCE, but I don't really know here to go from here.

In the short term, I suppose I could boot into XFCE to work in Libreoffice, and LXDE for other applications, but that's messy and not a long term option.

I would be very grateful for anyone's thoughts and ideas.

*** Edit *****

Openbox/pcmanfm works fine too.

Last edited by Myrlin; 11-04-2011 at 01:11 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
protect/lock a cell in libreoffice calc knobby67 Linux - Software 4 07-14-2011 04:29 PM
[SOLVED] Some problems with LibreOffice in Slackware64-crrent bdahz Slackware 3 04-19-2011 10:37 AM
Problems with Kate and OpenOffice.org Calc opening text files in openSUSE 11.0 rosco136 Linux - Software 0 01-19-2010 05:28 AM
putting a hyperlink into a image in Calc jturnbul Linux - Software 2 03-07-2005 12:46 PM
OpenOffice.org Calc printing problems Eultza Linux - Newbie 0 09-06-2003 11:33 AM


All times are GMT -5. The time now is 01:18 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration