>From Help:
"Formulas, however, are always adjusted accordingly."
Since you do not want this to happen, I suggest that you enter an
Request for Enhancement (RFE) into Issue
Tracker as this is the best way to have requests such as this evaluated.
If you haven't already registered, do the following:
1. To file an issue you must register with OOo by clicking the
My Pages tab and selecting the Register link
http://www.openoffice.org/servlets/Join
2. Fill in your information
3. Reply to the confirmation email that will be sent to the address
you provided.
4. Once you have confirmed, go to www.openoffice.org again
5. And click on the "My Pages" tab from which you can file and find
issues.
Thanks for bringing this to our attention. It is important that you file
any examples with the issue to ensure your need is understood.
On Fri, 2006-02-17 at 09:34 -0500, Lars D. Noodén wrote:
> Thanks. I'm aware of those work around and should have mentioned them in
> the original message. I'd still need a way, either simple or complex, to
> get it to work with ctrl-X (cut).
>
> There should be a way to protect the cell or something to be able to
> cut-n-paste the contents from a cell in a formula, to a cell outside of a
> formula. e.g. ^X ^V cell A2 to cell A3 and leave the formula =A1+A2
> unchanged and not =A1+A3 as is currently the case.
>
> -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 Fri, 17 Feb 2006, Johnny Andersson wrote:
>
> > Like you said, cut and paste (ctrl+x - highlight another cell - ctrl+v)
> > changes the formula in, let's say B1 if B1=A1+A2. I also tried to move the
> > cell (a2 in this case) with the mouse. Same result.
> >
> > However, try this: Highlight A2 - ctrl+c - backspace - highlight another
> > cell
> > - ctrl+v.
> >
> > So just press ctrl+c backspace instead of ctrl+x.
> > Or, if you prefer working with the mouse: Instead of Cut, click copy and
> > then
> > delete (or erase or whatever, I use Swedish version so I am not sure about
> > exactly what it says).
> >
> >
> >
> > Johnny
> >
> >
> >
> > Den 2006-02-17 13:28:00 skrev Lars D. Noodén <[EMAIL PROTECTED]>:
> >
> >> If I have a formula (say, =A1+A2) in Calc, and cut-n-paste one of the
> >> cells
> >> to a new location (say, cut from A2 and paste into A3) , the formula
> >> changes (and would now be =A1+A3).
> >>
> >> How do I stop that for specific formulas so that a normal cut-n-paste
> >> action will leave the formula unchanged?
> >>
> >> I've tried absolute references, but that doesn't help in this case, nor
> >> does turning on cell protection for the cells containing the formula.
> >> Normally this effect is a very helpful feature, but right now not in this
> >> particular instance.
> >>
> >> -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]
> >
> > ---------------------------------------------------------------------
> > 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]
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
