Advertisement
Private Profiles - an update on how they will be changing here
We've partnered up with Nixers.com to offer a space where you can talk directly to Peter from Nixers.com and get an exclusive Boards.ie discount code for a free job listing. If you are recruiting or know anyone else who is please check out the forum here.

OpenOffice Calc hyperlinks

  • 08-02-2012 10:06am
    #1
    Registered Users Posts: 1,671 ✭✭✭ kkelly77


    I have a .csv file I need to open with OO Calc. The csv file has hyperlinks to photos included but are in Excel format. Photos are stored locally on the PC.
    =HYPERLINK("images/Desert.jpg","Desert.jpg")
    

    This is not working with OpenOffice Calc. Does anyone know how to change the formula so the images are linked?

    I know I can link to the images myself by inserting the hyperlink myself from Insert>Hyperlink but the whole point of our csv file is that we don't have to do that. Any ideas? Thanks.


Comments

  • Registered Users Posts: 1,931 ✭✭✭ PrzemoF


    What happens if you save it as .ods file?
    It's converted to normal text? What's exaclty the text?
    Is there an inverted comma in front of the text? (--> ' <--)


  • Moderators, Technology & Internet Moderators Posts: 1,325 Mod ✭✭✭✭ croo


    OP says Open Office but might mean Libre Office... I did read there was a reported but related to hyperlink making it unusable
    https://bugs.freedesktop.org/show_bug.cgi?id=50128

    When this bug is addressed the functonality should be as originally described by the OP.


Advertisement