URLs in formula corrupted on edit

  • Resolved pauldotmac

    (@pauldotmac)


    4 months, 2 weeks ago

    Hi, I have a simple excel spreadsheet, 20 rows and 5 columns. Col3 includes a website URL (stored as text, not as a hyperlink), which is turned into a html <a> tag using a formula in col5. 

    ="<a href="&CHAR(39)&C2&CHAR(39)&" target="&CHAR(39)&"_blank"&CHAR(39)&" >"&A2&"</a>"

    If I edit the table structure – move rows around for example, once it has been imported then the results in column 5 get corrupted.

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 months, 2 weeks ago

    Hi @pauldotmac,

    Thanks for your post and sorry for the trouble!

    I’m not really sure that I understand. Can you please clarify what exactly is coming out as corrupted? What output are you getting and what are you expecting instead?

    The formula itself looks and works fine for me?

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.