[libreoffice-users] Calc cell reference unexpected behavior.

Hi.
Noticed an unexpected behavior in calc in regards cell references 
changing when data is cut and pasted. Not what I expected but others may 
consider it normal. Goes from LO3.4.1 back to OOO3.2.1

In a new sheet, column A, from A1 enter p,f,p,f,p,f.
In column B1 enter formula =if(A1="p","pass","fail") and copy down.

If there is a "p" in A there is a "pass" in B as expected.

Highlight A1:A6 and drag down 1 row. The "p" and "pass" no longer line 
up. An expected result as the cells are effectively moved.

Highlight A1:A6, cut and paste down 1 row. The "p" and "pass" no longer 
line up. An unexpected result. I am cutting the data to remove it and 
pasting the data to enter it.

Highlight A1:A6, copy and paste down 1 row. The "p" and "pass" still 
line up. An expected result.

What should be the result of a cut then subsequent paste. The above 
seems prone to cause problems without a warning that cut and paste will 
modify all formulae referencing cut cells.

If I am analysing some entered data and think to myself "I will just cut 
and past this data over there while I type in some new numbers" then I 
have just unknowingly wrecked my analysis.

steve

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