Issue 107634 - Formulas can be changed also in documented documents/sheets
Summary: Formulas can be changed also in documented documents/sheets
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1.1
Hardware: Unknown All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
: 113806 (view as issue list)
Depends on:
Blocks: 121425
  Show dependency tree
 
Reported: 2009-12-12 09:50 UTC by timi_openoffice
Modified: 2012-12-06 11:11 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
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 timi_openoffice 2009-12-12 09:50:15 UTC 
Steps to reproduce:

1.) Open a new document.
2.) At field B2, enter the formula "=A2" ("0" is displayed)
3.) Select field B2; Format->Field->Field protection->Protected should be
activated (default)
4.) Select fields A2 and A3; Format->Field->Field protection->Protected should
be deactivated
3.) Activate Tools->Protect Document->Document
3.) Activate Tools->Protect Document->Sheet
4.) Save the document
5.) Enter "5" in A2 ("5" is now also displayed in B2)
6.) Select A2
7.) Edit->Cut
8.) Select A3
9.) Edit->Paste

The result is that in the field B2 the formula has changed from "=A2" to "=A3".
Exactly this should not happen with a protected field!
Comment 1 Rob Weir 2012-11-11 20:47:55 UTC 
*** Issue 113806 has been marked as a duplicate of this issue. ***
Comment 2 Rob Weir 2012-11-11 20:57:12 UTC 
Checked with AOO 3.4.1 as well as Excel 2010.  Behavior is the same in Excel. 

I don't think this is a bug.  You could argue that by preserving the integrity of the formula we did the right thing.  Imagine a case where the user inserted a new row above row 2.  That would also cause the formulas to be rewritten.  That's just how a spreadsheet works.  The behaviors related to cell references don't change just because cell protection is enabled.  In other words, referential integrity is one of the things we need to protect.
Comment 3 binguo 2012-12-06 11:10:19 UTC 
Verified on Aoo_Trunk_20121203.1303 Rev.1413470, follow the steps of this bug, The result is that in the field B2 the formula has changed from "=A2" to "=A3".
which is the same as that in Ms Excel, so I agree it is not a bug.
Comment 4 binguo 2012-12-06 11:11:12 UTC 
close it.