https://issues.apache.org/ooo/show_bug.cgi?id=107634

Rob Weir <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
             Latest|---                         |AOO 3.4.1
    Confirmation on|                            |
         Resolution|---                         |INVALID

--- Comment #2 from Rob Weir <[email protected]> ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

Reply via email to