Description: I have an LO calc file with 5 sheets (W1,W2,W3,Sheet1,Sheet3), where W1,W2 and W3 depend on Sheet1 and Sheet3. When I accidentally delete Sheet1, but immediatly undo the deletion, the references are not reestablished. The entries in e.g. W1 show #REF!. Steps to Reproduce: 1. Create an LO calc file with 5 sheets, named e.g. W1,W2,W3,Sheet1,Sheet3 (in exactly that order) 2. Put data in Sheet1 and Sheet3 3. Establish references in W1 and W3 wrt. Sheet1 and references in W2 wrt. Sheet3 4. Delete Sheet1 5. Undo deletion Actual Results: The data in W1 and W3 are gone, #REF! is shown. Expected Results: The data in W1 and W3 are restored Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded
Created attachment 195357 [details] Example file in order to reproduce the bug
Repro, but not in LO 3.3 > Regression.
LO 4.1.0.4 > OK LO 4.2.0.4 > KO
*** This bug has been marked as a duplicate of bug 132455 ***