[Libreoffice-bugs] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #22 from Ferdinand <libreoffice at chricar.at> ---
(In reply to Cor Nouws from comment #20)
> (In reply to Ferdinand from comment #0)
> > if a referenced cell is deleted (delete row/column) the referencing cells
> > show #REF
> > if this cell is on a different table or out of view it will not be
> > recognized by the user IN TIME !
> 
> A user deleting data in a spreadsheet should know what he/she is doing.
> I expect more situations can be found to 'help' users. I wouldn't start
> along this path.

I a agree partly with "a user deleting data", the problem is often "another
user is deleting .. "

in general I doubt that the majority - especially beginners - know what they
are doing. and even myself. after a few years not working in a specific
spreadsheet I can't remember some references and I am surprised to find a REF
error in another sheet.

the function "trace dependents" is available and could be used.
example 
sheet 1 cell a1=1, cell a2=2, 
sheet 2, cell a1=+$sheet1.A1+$sheet1.A2
clicking trace dependents in sheet 1 cell a2 creates a blue line with a dot in
cell a2 and a square - undefined.
at least the user would know that deleting the row/column with cell a2 will
create REF Error
Again, the performance argument is a weak one as the test needs to be fired
only on "delete", especially compared with the time needed to repair the error.
Sometimes the repair process is almost impossible, if for example the original
users has left the company. Checking all backups (if available) is extremely
time consuming.

-- 
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/20190116/20353700/attachment.html>