Skip to content
This repository has been archived by the owner on Mar 28, 2024. It is now read-only.

[BUG] setRangeValue 第一个公式无法显示格式 #1420

Open
alexandershir opened this issue Sep 26, 2023 · 0 comments
Open

[BUG] setRangeValue 第一个公式无法显示格式 #1420

alexandershir opened this issue Sep 26, 2023 · 0 comments

Comments

@alexandershir
Copy link

alexandershir commented Sep 26, 2023

描述错误
调用setRangeValue批量更新数据,两种情况:
(1)如果数据都是公式数据且带格式,则第一个公式只显示公式而无格式,后续公式正常显示也带格式;
(2)如果数据中前几个是值数据,后面是公式数据,则值数据不显示也无格式,第一个公式只显示公式而无格式,后续公式正常显示也带格式;

重现

  1. 数据: const data = [[{bg:'#ffff00',v:100}, {bg:'#ffff00',f:'=SUM(A1:C1)'}, {bg:'#ffff00',f:'=SUM(A2:C2)'}]]
  2. 调用setRangeValue函数: luckysheet.setRangeValue(data, {range:{row:[0, 0], column: [0, 2]}})
  3. 更新公式: luckysheet.refreshFormula()
  4. 看到了错误: 如上错误描述

期望的结果
正常显示值和格式。

屏幕截图或演示
企业微信截图_20230926120806

环境:

  • 操作系统:Windows
  • 浏览器 版本号:Chrome
  • Luckysheet版本:最新
@alexandershir alexandershir changed the title [BUG] setRangeValue [BUG] setRangeValue 第一个公式无法显示格式 Sep 26, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant