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

Am 14.10.2011 03:32, Tom Davies wrote:
> 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 :)

Tom, you never test your own suggestions.
*All* spreadsheet applications keep track of *all* moving references, 
named or unnamed.
By now we have 3 formulas to keep frozen references.

--
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