<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WONTFIX - delete referenced cell - raise error" href="https://bugs.documentfoundation.org/show_bug.cgi?id=92419#c22">Comment # 22</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WONTFIX - delete referenced cell - raise error" href="https://bugs.documentfoundation.org/show_bug.cgi?id=92419">bug 92419</a> from <a class="email" href="mailto:libreoffice@chricar.at" title="Ferdinand <libreoffice@chricar.at>"> Ferdinand</a> <pre>(In reply to Cor Nouws from <a href="show_bug.cgi?id=92419#c20">comment #20</a>) > (In reply to Ferdinand from <a href="show_bug.cgi?id=92419#c0">comment #0</a>) > > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>