Luckysheet icon indicating copy to clipboard operation
Luckysheet copied to clipboard

To initialize with HYPERLINK function is not working.

Open Gourdbaby opened this issue 3 years ago • 1 comments

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

Gourdbaby avatar Feb 15 '22 03:02 Gourdbaby

Hi, any updates with this issue? Have same problem. Thanks.

kimzerokim avatar Jan 23 '24 08:01 kimzerokim