New Hyperlink (Excel import) function not working

  • Resolved Troy Rutter

    (@trutter)


    1 year, 6 months ago

    Hey Tobias,

    I am importing a table with ~800 rows and 2 of the fields are using the Hyperlink function. I was excited to hear this was now supported, but my plugin is up to date and it is still not working (the tables have =HYPERLINK(E2,D2) in them in the resulting tablepress table)

    running the latest WP and Tablepress 2.1.7. Also tried saving as both xls and xlsx same result.

    I believe we are running the older PHP 7.4 but i tried it on 8.2 as well, same thing. I even tried with only 2 rows.

    Was the HYPERLINK function only in premium? Thanks.

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    No, the HYPERLINK function is not related to the Premium versions, i.e. it should be working in the free version as well.

    Now, it’s correct that you see the formula =HYPERLINK(E2,D2) in the cell, after the file import. The formula is imported in “raw” and the evaluated by TablePress (to HTML code for a link).

    So, for the cells that have a HYPERLINK formula, what do you see when showing that table in a post/page?

    As for PHP requirements: The PHP version does indeed play a role here, but only in the sense that at least version 7.2 is required. In addition though, the mbstring PHP module must be installed on the server. (You can check that on the Site Health page of your WordPress admin dashboard, or in a phpinfo.php file that calls phpinfo().)

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘New Hyperlink (Excel import) function not working’ is closed to new replies.