univer icon indicating copy to clipboard operation
univer copied to clipboard

[Bug] When selecting the formula result drop-down to fill in, the formula result is calculated incorrectly

Open zhaolixin7 opened this issue 10 months ago • 1 comments

在您提交此问题之前,您是否检查了以下内容?

  • [X] 这真的是个问题吗?
  • [X] 我已经在 Github Issues 中搜索过了,但没有找到类似的问题。

受影响的包和版本

dev

复现链接

1、新建空子表,公式c1=sum(A1+b1),选中C1向右填充到O1单元格 2、选中c1:O1拖拽向下填充

预期行为

向下拖拽的单元格结果为0

实际行为

11、21、31行计算结果错误 2024_4_22 19_43_32 video.webm

运行环境

No response

系统信息

No response

zhaolixin7 avatar Apr 22 '24 11:04 zhaolixin7

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Origin Title: [Bug] 选择公式结果下拉填充,公式结果计算错误

Title: [Bug] When selecting the formula result drop-down to fill in, the formula result is calculated incorrectly


Before you submitted this question, did you check the following?

  • [X] Is this really a problem?
  • [X] I've searched Github Issues but haven't found any similar issues.

Affected packages and versions

dev

Recurrence link

  1. Create a new empty subtable with the formula c1=sum(A1+b1). Select C1 and fill it to the right to cell O1.
  2. Select c1:O1 and drag it down to fill it.

Expected behavior

The result of the cell dragged down is 0

Actual behavior

The calculation results of lines 11, 21, and 31 are wrong. 2024_4_22 19_43_32 video.webm

Running environment

No response

system message

No response

univer-bot[bot] avatar Apr 22 '24 11:04 univer-bot[bot]