srry i.a. if similar already exists.
main idea: when calc adapts formulas in other cells than touched by the user - 'indirect changes' - those changes should be made visible to the user with a 'mark' on the changed cells, giving him a chance to check the changes and correct unwanted results in time. the marks can be removed after an 'accept changes' action of the user.
long: when e.g. moving cells calc adapts the formulas in other cells which reference towards these cells.
a.) when a referenced range is moved in total the formula is changed to point to the new position,
b.) when a part of a referenced range is moved the formula is kept 'as is', thus loosing part of it's arguments,
becoming complex latest when a.) and b.) are mixed in one move.
(include nested formulas and similar, and you easily reach the border of my skills)
for an SMU - 'simple minded user' - it's difficult to understand and follow these changes, just think of complex sheets you didn't create yourself.
above enhancement could clear this situation.
coloured triangle in upper left corner of the cell, light green: unchanged, light yellow: changes in referenced ranges, formula kept, light red: formula adapted reg. changes in referenced ranges.
Steps to Reproduce:
A1:'2', B1:'3', A2:'4', B2:'5',
move A2:B3 to A4:B5,
observe formula in C1 unchanged, formula in C2 changed to point to the new position of the moved content,
(despite taking long time to show the result - ver.2019-03-30_02:16:13 - the formula is changed at once)
two similar formulas are handeled differently
these changes should be 'noticeable' to the user,
User Profile Reset: No
Version: 188.8.131.52.alpha0+ (x64)
Build ID: b4698a2241ec26d796c66da3a814f7cc693785b6
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win;
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-30_02:16:13
Locale: de-DE (de_DE); UI-Language: en-US
it make sense. it could be an optional option in config...