Return-Path: X-Original-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CECB0D674 for ; Wed, 11 Jul 2012 08:42:49 +0000 (UTC) Received: (qmail 4715 invoked by uid 500); 11 Jul 2012 08:42:49 -0000 Delivered-To: apmail-incubator-ooo-issues-archive@incubator.apache.org Received: (qmail 4667 invoked by uid 500); 11 Jul 2012 08:42:48 -0000 Mailing-List: contact ooo-issues-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-issues@incubator.apache.org Delivered-To: mailing list ooo-issues@incubator.apache.org Received: (qmail 4639 invoked by uid 99); 11 Jul 2012 08:42:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2012 08:42:47 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.123] (HELO sif.zones.apache.org) (140.211.11.123) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2012 08:42:45 +0000 Received: by sif.zones.apache.org (Postfix, from userid 80) id 62FC949CD; Wed, 11 Jul 2012 08:42:24 +0000 (UTC) From: bugzilla@apache.org To: ooo-issues@incubator.apache.org Subject: [Bug 120251] New: Undo delete sheets, the referece across sheet can not be restored. Date: Wed, 11 Jul 2012 08:42:22 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: spreadsheet X-Bugzilla-Component: editing X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: shanzhu33@gmail.com X-Bugzilla-Status: CONFIRMED X-Bugzilla-Priority: P3 X-Bugzilla-Assigned-To: ooo-issues@incubator.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: priority bug_id assigned_to short_desc bug_severity cf_bug_type classification op_sys reporter rep_platform bug_status version component product Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://issues.apache.org/ooo/ Auto-Submitted: auto-generated MIME-Version: 1.0 https://issues.apache.org/ooo/show_bug.cgi?id=120251 Priority: P3 Bug ID: 120251 Assignee: ooo-issues@incubator.apache.org Summary: Undo delete sheets, the referece across sheet can not be restored. Severity: normal Issue Type: DEFECT Classification: Application OS: All Reporter: shanzhu33@gmail.com Hardware: All Status: CONFIRMED Version: AOO 3.4.0 Component: editing Product: spreadsheet 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. -- You are receiving this mail because: You are the assignee for the bug.