Bug 162073 - Distroyed references after deleting and restoring of LO calc sheet
Summary: Distroyed references after deleting and restoring of LO calc sheet
Status: RESOLVED DUPLICATE of bug 132455
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Sheet
  Show dependency treegraph
 
Reported: 2024-07-17 14:18 UTC by Friedhelm Krumm
Modified: 2024-07-17 22:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file in order to reproduce the bug (11.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-07-17 14:20 UTC, Friedhelm Krumm
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Friedhelm Krumm 2024-07-17 14:18:00 UTC
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
Comment 1 Friedhelm Krumm 2024-07-17 14:20:04 UTC
Created attachment 195357 [details]
Example file in order to reproduce the bug
Comment 2 ady 2024-07-17 16:38:56 UTC
Repro, but not in LO 3.3 > Regression.
Comment 3 ady 2024-07-17 16:59:42 UTC
LO 4.1.0.4 > OK
LO 4.2.0.4 > KO
Comment 4 m_a_riosv 2024-07-17 22:58:27 UTC

*** This bug has been marked as a duplicate of bug 132455 ***