https://bugs.documentfoundation.org/show_bug.cgi?id=170865
--- Comment #16 from Telesto <[email protected]> --- Case A 1. Open Calc 2. Insert a couple of sheets 3. Select one (or more) sheets -> No warning dialog at all Case B 1. Open Calc 2. Insert a couple of sheets (say 4) 3. Insert a reference. Sheet2 pointing to a cell in Sheet 1 4. Try to delete Sheet2 -> Warning: Are you sure you... (Press cancel) 5. Try to delete Sheet 1 -> Warning: Are you sure you (Press cancel) 6. Try to delete Sheet4 -> Also a warning (but no no sheet referencing to it) Case C 1. Open Calc 2. Insert a couple of sheets (say 4) 3. Insert a reference. Cell A1 in sheet2 pointing to a cell in Sheet 1 4. Delete the reference in Sheet2 5. Try to delete any sheet: Warning: Are you sure you... How can "Are you sure you want to delete the selected sheet?" be interpreted A) Information dialog for unintended deletion Does not appear to be the case: see case A B) Expression of permanent - unrecoverable - action Partly true. Undo doesn't restore references. If not restoring references on undo being bug or not bit kind of open question. Excel isn't capable doing this (probably for a reason). Calc was able to do this at some point (bug 132455) C) Expression of permanent - unrecoverable - action, specially triggered by presence of "references" It appears some kind of flag is set, when the first reference got inserted. At this point: "Are you sure you want to delete the selected sheet?" keeps popping up for all sheets. And regardless if the specific sheet within in spreadsheet actually being referenced too. Or if any reference existing any longer (the might got removed) It appears the intention of genetic warning of possible breaking a reference somewhere. Without the end-user knowing if a sheet truly being referenced somewhere in a different sheet (and even which sheet). The author supposed to know it, apparently. The end-result is quite some 'scaremongering' effect, with genetic message (why do I get the dialog: Are you sure you want to delete the selected sheet?" in some scenarios and not in others; Case A versus Case B) and often being a spurious warning after all (for example case C) -- You are receiving this mail because: You are the assignee for the bug.
