Excel hyperlinks changed to little square blocks in calc

wvbladel · Newbie Joined: 02 Jul 2009 Posts: 2

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.

wvbladel · Newbie Joined: 02 Jul 2009 Posts: 2

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?

pendle · General User Joined: 05 Jul 2009 Posts: 9

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