[Libreoffice-bugs] [Bug 124453] New: enhancement: mark cells after indirect changes by the program when editing a sheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124453

            Bug ID: 124453
           Summary: enhancement: mark cells after indirect changes by the
                    program when editing a sheet
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
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, 

right? 

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. 

suggestion: 

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', 
C1:'=SUM(A1:B2)', 
C2:'=SUM(A2:B3)', 
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: 6.3.0.0.alpha0+ (x64)
Build ID: b4698a2241ec26d796c66da3a814f7cc693785b6
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86_64 at 42, Branch:master, Time: 2019-03-30_02:16:13
Locale: de-DE (de_DE); UI-Language: en-US
Calc:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190331/10a4787f/attachment.html>