Bug 167304 - Deleting a sheet followed by undo doesn't restore the formula's (reference broken)
Summary: Deleting a sheet followed by undo doesn't restore the formula's (reference br...
Status: RESOLVED DUPLICATE of bug 132455
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-06-30 14:56 UTC by Telesto
Modified: 2025-06-30 17:38 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Sample (3.40 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-06-30 14:56 UTC, Telesto 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2025-06-30 14:56:45 UTC 
Description:
Deleting a sheet followed by undo doesn't restore the formula's (reference broken)

Steps to Reproduce:
1. Open the attached file. Downloaded from: https://docs.google.com/spreadsheets/d/1QGrMm6XSGWBVLI8I_DOAeJV5whoCnSdmaR8toQB2Jz8/edit#gid=0 (posted at bug 128329 comment 2)
2. CTRL+SHIFT+F9 (Hard recalculate; everything appears to be fine)
3. Delete the first sheet 
4. Press CTRL+Z (undo)
5. Reference broken


Actual Results:
#REF!

Expected Results:
Value's as before


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 6faa7e6f7bae3e6a613b4f4b7cee4a9c6d2b7aae
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded

and in
Version: 4.3.7.2
Build ID: 8a35821d8636a03b8bf4e15b48f59794652c68ba
Comment 1 Telesto 2025-06-30 14:56:55 UTC 
Created attachment 201563 [details]
Sample
Comment 2 m_a_riosv 2025-06-30 15:11:19 UTC 
Maybe a dup of tdf#132455
Comment 3 Telesto 2025-06-30 17:38:52 UTC 

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