Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
2 tasks done
zhaolixin7 opened this issue Apr 22, 2024 · 1 comment · May be fixed by #2452
Closed
2 tasks done
Assignees
Labels
bug Something isn't working scope:formula

Comments

@zhaolixin7
Copy link

zhaolixin7 commented Apr 22, 2024

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

  • 这真的是个问题吗?
  • 我已经在 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 zhaolixin7 added bug Something isn't working scope:formula labels Apr 22, 2024
@univer-bot univer-bot bot changed the title [Bug] 选择公式结果下拉填充,公式结果计算错误 [Bug] When selecting the formula result drop-down to fill in, the formula result is calculated incorrectly Apr 22, 2024
@univer-bot
Copy link

univer-bot bot commented Apr 22, 2024

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?

  • Is this really a problem?
  • 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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working scope:formula
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants