Re: [libreoffice-users] Re: Calc: cut/paste removes and renames protected field references - is this a bug?

Hi :)
Can you name a cell?  In Excel you could define a name for a cell by just typing it in on the 
formula bar just before the f(x)Sigma bit.  Normally the drop-down there contains the cell's 
address, such as A!, but you can just type something else into there to rename it.  Try calling it 
"fred" and then in cell B6 or somewhere try writing
=fred
Now you can move A1 around by drag&drop or cut&paste and B6 will keep referrign to that same cell 
even tho it's not A1 anymore.  
Regards from
Tom :)

--- On Fri, 14/10/11, Steve Edmonds <steve.edmonds@ptglobal.com> wrote:

From: Steve Edmonds <steve.edmonds@ptglobal.com>
Subject: Re: [libreoffice-users] Re: Calc: cut/paste removes and renames protected field references 
- is this a bug?
To: users@global.libreoffice.org
Date: Friday, 14 October, 2011, 2:04

Hi.
What about trying
=INDIRECT("sheet1.a1")

If my understanding of your requirement is correct, this seems to work.
steve

On 14/10/11 13:49, Brian J. wrote:
> Andreas Säger-2 wrote:
>    
> > You mean: How can I refer to one particular cell address?
> >
> > =OFFSET($SheetX.$A$1;2;3;4;5)
> >
> >      
> No, I mean how can I refer to a particular cell address no matter what a
> user does to that cell.  Moving, cutting, pasting, overwriting, anything.  I
> always want to point to, say Sheet1.A1.
>
> If you think the use case would be helpful I'd be happy to elaborate.
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Calc-cut-paste-removes-and-renames-protected-field-references-is-this-a-bug-tp3417657p3420361.html
> Sent from the Users mailing list archive at Nabble.com.
>
>    

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted