Further to this issue. If the formula cells are protected and sheet
and/or document protection is turned on, the formula will still change.
You don't have to cut and paste to get the effect. Just dragging
referenced cells will change a protected cell.
The way to 'move' data without changing the reference is to cut in the
edit bar and paste into the new location. This can only work on one cell
at a time, though.
tc
Lars D. Noodén wrote:
Much of the time that's a good thing. However, sometimes it will get
in the way and there should be a way to turn it off.
For example, if you have a form that use formulas using input from
what people to fill in, someone using it could mess it up completely
by simple ^X ^V
-Lars
Lars Nooden ([EMAIL PROTECTED])
Software patents endanger the legal certainty of software.
Keep them out of the EU by writing your MEP, keep the market open.
On Sat, 18 Feb 2006, Ross Johnson wrote:
Ah! Sorry, I misunderstood. Yes this is a 'feature' and it is apparently
the same in Excel 2000 and Excel 2003 according to the following issue
reports:
http://qa.openoffice.org/issues/show_bug.cgi?id=29135
http://qa.openoffice.org/issues/show_bug.cgi?id=26929
If you move a cell that formulas refer to then they are changed.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
