Private Profiles - an update on how they will be changing here
We've partnered up with to offer a space where you can talk directly to Peter from and get an exclusive 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
    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.

    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.


  • 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

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