Luckysheet
Luckysheet copied to clipboard
To initialize with HYPERLINK function is not working.
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
-
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
Environment
- OS: Mac
- Browser Version: Chrome Version 97.0.4692.99 (Official Build) (x86_64)
- Luckysheet Version: @2.1.13
Additional context
Hi, any updates with this issue? Have same problem. Thanks.