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] If a cell with a formula has been set and another CV value is entered, the formula will not be cleared. #3347

Closed
2 tasks done
caijiamin opened this issue Sep 6, 2024 · 3 comments
Assignees
Labels
bug Something isn't working Priority:P1 scope:formula

Comments

@caijiamin
Copy link

Before you submit this issue, have you checked the following

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

^0.2.11

Reproduction link

3af0c1d937905552c09f216e82de85c

Expected behavior

1、步骤一:单元格1,输入公式=SUM(1,2);
2、步骤二:单元格2,输入字符串“cccc”;

Actual behavior

3、步骤三:将单元格2的“cccc",复制粘贴到单元格1,单元格1的值改变了,公式还在。

System information

No response

@caijiamin caijiamin added the bug Something isn't working label Sep 6, 2024
@univer-bot univer-bot bot changed the title [Bug] 设置过公式的单元格,再cv别的值进来,公式不会清空 [Bug] If a cell with a formula has been set and another CV value is entered, the formula will not be cleared. Sep 6, 2024
@univer-bot
Copy link

univer-bot bot commented Sep 6, 2024

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

Origin Title: [Bug] 设置过公式的单元格,再cv别的值进来,公式不会清空

Title: [Bug] If a cell with a formula has been set and another CV value is entered, the formula will not be cleared.


Before you submit this issue, have you checked the following

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

^0.2.11

Reproduction link

3af0c1d937905552c09f216e82de85c

Expected behavior

  1. Step 1: In cell 1, enter the formula =SUM(1,2);
  2. Step 2: In cell 2, enter the string "cccc";

Actual behavior

  1. Step 3: Copy and paste "cccc" in cell 2 to cell 1. The value of cell 1 has changed, but the formula is still there.

System information

No response

@wpxp123456
Copy link
Contributor

#3257 @caijiamin 最新版本已经修复了

@univer-bot
Copy link

univer-bot bot commented Sep 10, 2024

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

#3257 @caijiamin The latest version has been fixed

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

No branches or pull requests

4 participants