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

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