Issue 120251 - Undo delete sheets, the referece across sheet can not be restored.
Summary: Undo delete sheets, the referece across sheet can not be restored.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-11 08:42 UTC by Shan Zhu
Modified: 2012-07-11 08:42 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Shan Zhu 2012-07-11 08:42:22 UTC 
Build info: AOO3.4.1_r1354891

Steps to reproduce:
1. Create a new file in Spreadsheet.
2. Input a formula in A1 which reference a cell in another sheet. Say, "=Sheet2.a1"
3. Select Sheet1 and Sheet2 together. (Press Shift, click the tab of Sheet2)
4. Right click sheet tab -> Delete Sheet...
5. Press Ctrl+Z to undo the delete.

Issue:
The sheet name in reference string can not be restored. Formula will return a error.

Notes: Delete Sheet2 first, then Sheet1. Undo 2 times, it works.