To initialize with HYPERLINK function is not working.

Author: GourdbabyCreated Feb 15, 2022Updated Jan 23, 2024

Describe the bug

I want to initialize a Luckysheet with some values of HYPERLINK, and I got "#NAME?" on the cell that has a HYPERLINK. To Reproduce

  1. The first step:

     celldata: [{
          "r": 0,
          "c": 0,
          "v": {
            ct: {fa: "General", t: "g"},
            m:"abc",
            v:"abc",
            f: '=HYPERLINK("https://www.google.com/", "abc")'
          }
        }]
    calcChain: [{
          "r": 0, //行数
          "c": 0, //列数
          "index": 1, //工作表id
          "func": [true, "", '=HYPERLINK("https://www.google.com/", "abc")'], //公式信息,包含公式计算结果和公式字符串
          "color": "w", //"w":采用深度优先算法 "b":普通计算0
          "parent": null,
          "chidren": {},
          "times": 0
        }]

What is expected?

I expect it show me a right value. I expect the cells show me a "abc" on it, and redirect the current page to "google.com" after click it Screenshots or demo

QQ20220215-105343 QQ20220215-105352

Environment

  • OS: Mac
  • Browser Version: Chrome Version 97.0.4692.99 (Official Build) (x86_64)
  • Luckysheet Version: @2.1.13

Additional context