https://bugs.documentfoundation.org/show_bug.cgi?id=132455
--- Comment #7 from Tex2002ans <[email protected]> --- Created attachment 192552 --> https://bugs.documentfoundation.org/attachment.cgi?id=192552&action=edit Sheet2 with text from Sheet1 0. Open attached ODS file. All it is: Sheet1: A1: "TextfromSheet1" Sheet2: A1: "Here is:" Sheet2: B1: =$Sheet1.A1 - - - 1. Delete Sheet1. 2. Edit > Undo (Ctrl+Z) 3. Go back to Sheet2. - - - In Sheet2, Cell B1... For values, you'll see: Step 0: "TextfromSheet1" Step 1: #REF! Step 2: #REF! For formulas, you'll see: Step 0: =$Sheet1.A1 Step 1: =$#REF!.A1 Step 2: =$#REF!.A1 After Step 2, there is no amount of Undos you can do to return to the original state. -- You are receiving this mail because: You are the assignee for the bug.
