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

Formula reference issue - cut and paste - resubmitted with corrected example #519

Open
visualbasik opened this issue Mar 18, 2024 · 1 comment

Comments

@visualbasik
Copy link

If you cut a cell which contains a parameter for a function, and paste it into another cell, the formula reference does not update.

For example:
put: 1 in cell A1
put: 2 in cell A2
put =if(1>0,A1,A2) in cell A3
If you cut cell A1 and paste it to B1, the expected result would be for the formula to update to: =IF(1>0,B1,A2)

@sanchit3008
Copy link
Collaborator

Thanks for submitting this issue. This seems like a common problem for any formulae, that if a cell currently present in the calcChain is cut, then the corresponding entries in the sheet are not updated. Would you be willing to potentially submit a PR for this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants