Cut and Paste a Formula with Relative References

When you Cut and Paste a cell that contains a relative reference, the relative reference should not change (unlike copy/paste). I’m reporting this as a bug because this is how Cut and Paste works in other spreadsheet applications, so it would be expected to work that way here as well.

Example:
a) A1 =15 and A2 =10
b) B1 =A1
c) Cut cell B1 and Paste in B2
d) B2 should still be =A1

Agree and thanks for the example to illustrate the point. We are tracking this internally as issue # 002276

This issue has now been addressed as of today’s updates.

1 Like