OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Excel hyperlinks changed to little square blocks in calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
wvbladel
Newbie
Newbie


Joined: 02 Jul 2009
Posts: 2

PostPosted: Thu Jul 02, 2009 6:25 am    Post subject: Excel hyperlinks changed to little square blocks in calc Reply with quote

All my hyperlinks changed to little square blocks.

I have a file that lists a lot of files by naming their description. Every description has a hyperlink to that file, so it will open in the apropriet program.
When I open this file in OO-Calc, everything converted well but not the hyperlinks.

Can anyone point me in the right direction to solve this? I really want to get rid of MS-Office.

Thanks in advance,
Willem.
Back to top
View user's profile Send private message
wvbladel
Newbie
Newbie


Joined: 02 Jul 2009
Posts: 2

PostPosted: Thu Jul 02, 2009 12:52 pm    Post subject: Reply with quote

I think it got something to do with character fonts.
When I edit the hyperlink by opening the hyperlink window and confirm the input again by just hitting enter, the link is now also visible in OpenOffice Calc.

Now I just have to think of a macro to confirm all links.

Anyone have any suggestions?
Back to top
View user's profile Send private message
pendle
General User
General User


Joined: 05 Jul 2009
Posts: 9

PostPosted: Sun Jul 05, 2009 11:11 am    Post subject: Excel hyperlinks problem Reply with quote

May I add two further problems with Excel hyperlinks so we can get an answer to all three in one go!
Converting my Excel sheets, the hyperlinks (1) no longer wrap within the cells and (2) have acquired a nasty grey background. My sheets look atrociously messy as a result.
Spent ages experimenting with fonts and style sheets. Any ideas?
Many thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
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


Powered by phpBB © 2001, 2005 phpBB Group