Bug 170557 - undo delete sheet does not restore cells with #REF! error in other sheet
Summary: undo delete sheet does not restore cells with #REF! error in other sheet
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.4.2 release
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-02-01 08:18 UTC by Ferdinand
Modified: 2026-02-03 03:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
sample with 2 sheets used to test the UNDO of delete sheet (9.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2026-02-01 08:19 UTC, Ferdinand 		Details
very simple sample file (7.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2026-02-01 15:14 UTC, Ferdinand 		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 Ferdinand 2026-02-01 08:18:54 UTC 
Description:
UNDO NOT working correctly if a sheet with a referenced cells is deleted.



Steps to Reproduce:
on Macbook AIR M1

1.delete sheet 1 in the sample file  - sheet 2 shows the cell with #REF!
2. click undo - sheet 1 is displayed 
3 goto sheet 2 -  still shows the cell with #REF! 
UNDO not Working correctly


Actual Results:
the reference is not restored  #REF! remains in the cell

Expected Results:
restore the formula in the #REF! cell as it does for #REF! in the same sheet


Reproducible: Always


User Profile Reset: No

Additional Info:
same error is reproducible in

1. collabora on Macbook air M1
COOLWSD version: 25.04.8.1
git hash:  57401feb64
LOKit version: built on  a great technology base
Collabora Office 25.04.9.0
git hash: a5f1e0aab3

2. CODE - on Hetzner server
COOLWSD version:
25.04.8.1 (git hash: 278cb3481b(E))
LOKit version:
built on agreat technology base
Collabora Office 25.04.8.1 (git hash: 489cb5d73b)
Comment 1 Ferdinand 2026-02-01 08:19:50 UTC 
Created attachment 205300 [details]
sample with 2 sheets used to test the UNDO of delete sheet
Comment 2 Telesto 2026-02-01 13:51:40 UTC 
The example file doesn't contain a working reference in sheet2. So it can't be broken by undo. But yes a proper reference will break at undo. Reported before in bug 132455
Comment 3 Ferdinand 2026-02-01 14:22:44 UTC 
(In reply to Telesto from comment #2)
> The example file doesn't contain a working reference in sheet2. So it can't
> be broken by undo. But yes a proper reference will break at undo. Reported
> before in bug 132455

please prepare a similar one for yourself
I get this problem with every new file with all libreoffice, collabora and code
Comment 4 Ferdinand 2026-02-01 15:14:29 UTC 
Created attachment 205301 [details]
very simple sample file

look at sheet 2 - A1 references Sheet 1 A1
delete sheet 1
Undo
sheet 2 shows error
Comment 5 Telesto 2026-02-02 18:57:09 UTC 
(In reply to Ferdinand from comment #4)
> Created attachment 205301 [details]
> very simple sample file
> 
> look at sheet 2 - A1 references Sheet 1 A1
> delete sheet 1
> Undo
> sheet 2 shows error

I can confirm the problem exists.. It's probably the same issue as in bug 132455
Comment 6 Ferdinand 2026-02-03 03:57:04 UTC 
(In reply to Telesto from comment #5)
> (In reply to Ferdinand from comment #4)
> > Created attachment 205301 [details]
> > very simple sample file
> > 
> > look at sheet 2 - A1 references Sheet 1 A1
> > delete sheet 1
> > Undo
> > sheet 2 shows error
> 
> I can confirm the problem exists.. It's probably the same issue as in bug
> 132455

yes