Created attachment 84571 [details]
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document2beforeCorruption.ods

unrelated formulae corrupted when moving cells between documents

Unrelated formulae can be become corrupted when moving cells between two Calc documents.

I have recorded one instance of this bug in detail;

document1.ods;

	colA		colB		colC
1	214		214	
2	214		214
3	214		214
4	214		214
5	214		214
6	214		214
7	214		214
8	214		214
9	214		214
10	214		214
11

moving (cut and paste) cells A1:C11 from Calc document1.ods to Calc document2.ods cell FT2 (ie FT2:FV12) results in a) successful move of cell data, and b) an additional change (corruption) of a set of cells in Calc document2.ods:

from original form (document2.ods);
	colBA						colBB
r1	_ip (study 2) !unique				_ip (study 3) !unique
r2	=IF(NOT(ISNA(MATCH(B2;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C2;S$2:S$301;0)));1;0)	
r3	=IF(NOT(ISNA(MATCH(B3;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C3;S$2:S$301;0)));1;0)	
r4	=IF(NOT(ISNA(MATCH(B4;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C4;S$2:S$301;0)));1;0)	
r5	=IF(NOT(ISNA(MATCH(B4;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C5;S$2:S$301;0)));1;0)	
r6	=IF(NOT(ISNA(MATCH(B6;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C6;S$2:S$301;0)));1;0)	
r7	=IF(NOT(ISNA(MATCH(B7;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C7;S$2:S$301;0)));1;0)	
r8	=IF(NOT(ISNA(MATCH(B8;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C8;S$2:S$301;0)));1;0)	
r9	=IF(NOT(ISNA(MATCH(B9;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C9;S$2:S$301;0)));1;0)	
r10	=IF(NOT(ISNA(MATCH(B10;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C10;S$2:S$301;0)));1;0)	
r11	=IF(NOT(ISNA(MATCH(B11;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C11;S$2:S$301;0)));1;0)	
r12	=IF(NOT(ISNA(MATCH(B12;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C12;S$2:S$301;0)));1;0)	
r13	=IF(NOT(ISNA(MATCH(B13;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C13;S$2:S$301;0)));1;0)	
etc etc			

to corrupted form (document2.ods);
	colBA						colBB
r1	_ip (study 2) !unique				_ip (study 3) !unique
r2	=IF(NOT(ISNA(MATCH(FU3;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV3;S$2:S$301;0)));1;0)	[CORRUPTED]
r3	=IF(NOT(ISNA(MATCH(FU4;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV4;S$2:S$301;0)));1;0)	[CORRUPTED]
r4	=IF(NOT(ISNA(MATCH(FU5;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV5;S$2:S$301;0)));1;0)	[CORRUPTED]
r5	=IF(NOT(ISNA(MATCH(FU6;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV6;S$2:S$301;0)));1;0)	[CORRUPTED]
r6	=IF(NOT(ISNA(MATCH(FU7;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV7;S$2:S$301;0)));1;0)	[CORRUPTED]
r7	=IF(NOT(ISNA(MATCH(FU8;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV8;S$2:S$301;0)));1;0)	[CORRUPTED]
r8	=IF(NOT(ISNA(MATCH(FU9;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV9;S$2:S$301;0)));1;0)	[CORRUPTED]
r9	=IF(NOT(ISNA(MATCH(FU10;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV10;S$2:S$301;0)));1;0)	[CORRUPTED]
r10	=IF(NOT(ISNA(MATCH(FU11;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV11;S$2:S$301;0)));1;0)	[CORRUPTED]
r11	=IF(NOT(ISNA(MATCH(FU12;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(FV12;S$2:S$301;0)));1;0)	[CORRUPTED]
r12	=IF(NOT(ISNA(MATCH(B12;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C12;S$2:S$301;0)));1;0)	[CORRECT]
r13	=IF(NOT(ISNA(MATCH(B13;R$2:R$151;0)));1;0)	=IF(NOT(ISNA(MATCH(C13;S$2:S$301;0)));1;0)	[CORRECT]
etc etc		[CORRECT]


I have attached 3 documents that can be used to replicate the issue (by following the above instructions).

AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document1.ods ("document1.ods")
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document2beforeCorruption.ods ("document2.ods")
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document2afterCorruption.ods <- this is what it should look like after the formulae have been corrupted