Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

OpenOffice Calc hyperlinks

  • 08-02-2012 11:06AM
    #1
    kkelly77
    Registered Users, Registered Users 2 Posts: 1,673 ✭✭✭


    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

  • #2
    PrzemoF
    Registered Users, Registered Users 2 Posts: 1,929 ✭✭✭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? (--> ' <--)


  • #3
    croo
    Moderators, Technology & Internet Moderators Posts: 1,338 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