On Fri, 17 Feb 2006, Anthony Chilco wrote:
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.
Yes there are many work arounds and spreadsheets have certainly become
more flexible and powerful since the first version of Visicalc.
On Sat, 18 Feb 2006, Barrie Backhurst wrote:
Could this not be added to the "Paste Special"(ctl+shift+v) dialog, so
that it is an option when pasting and therefore not automatically
implemented?
That would be another work around, but you still would have a situation
where a novice user or some fool in a hurry (yo!) can mess up a form by
moving content around. Say you typed the mobile number into the slot for
the work phone and cut-n-paste it to the right cell, the spreadsheet's
formulas would still think that it's the work phone. Or if you have a
form with travel or per-diem calculations and move cells around while
intending to move the data.
On Fri, 17 Feb 2006, Eike Rathke wrote:
Could also mess it up if your feature was turned on and he just wanted
to move a cell..
That argument would also apply to cell protection, which OOo already has.
The request for enhancement is not a suggestion to change the way the
whole spreadsheet behaves, simply a suggestion to make it an option to
distinguish between moving data (which happens to be in a particular cell
at the moment) and the cell itself (including all references to it in
formulas).
Think about how you would implement a tax form as a table or two in Calc.
If someone puts the wrong number in a cell and then moves it, the whole
table gets screwed up unless there is a way to guard specificed cells by
making ^X default to moving just the data and not the cell.
-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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
