You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
The text was updated successfully, but these errors were encountered:
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?
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)
The text was updated successfully, but these errors were encountered: