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+h...@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