Issue 126162 - unrelated formulae corrupted when moving cells between documents
Summary: unrelated formulae corrupted when moving cells between documents
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.0
Hardware: All Linux 64-bit
: P5 (lowest) Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-06 09:53 UTC by richardbaxter
Modified: 2015-03-18 01:56 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document2beforeCorruption.ods (28.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-06 09:53 UTC, richardbaxter
no flags Details
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document2afterCorruption.ods (28.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-06 09:53 UTC, richardbaxter
no flags Details
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document1.ods (7.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-06 09:54 UTC, richardbaxter
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description richardbaxter 2015-03-06 09:53:07 UTC
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
Comment 1 richardbaxter 2015-03-06 09:53:57 UTC
Created attachment 84572 [details]
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document2afterCorruption.ods
Comment 2 richardbaxter 2015-03-06 09:54:27 UTC
Created attachment 84573 [details]
AAObug-corruptFormulaeWhenMoveCellsBetweenDocs-document1.ods
Comment 3 richardbaxter 2015-03-18 01:56:20 UTC
I have confirmed this issue occurs on both Linux UB14.04 x86_64 (AAO 4.1.0) and MS Win8 x86_64 (AAO 4.1.1).