Bug 124453 - enhancement: mark cells after indirect changes by the program when editing a sheet
Summary: enhancement: mark cells after indirect changes by the program when editing a ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
Reported: 2019-03-31 14:29 UTC by b.
Modified: 2023-05-07 16:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description b. 2019-03-31 14:29:47 UTC
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) 

Actual Results:
two similar formulas are handeled differently

Expected Results:
these changes should be 'noticeable' to the user, 

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (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
Comment 1 Xisco Faulí 2019-05-02 11:37:12 UTC
it make sense. it could be an optional option in config...