https://bz.apache.org/ooo/show_bug.cgi?id=126162
Issue ID: 126162
Issue Type: DEFECT
Summary: unrelated formulae corrupted when moving cells between
documents
Product: Calc
Version: 4.1.0
Hardware: All
OS: Linux64
Status: UNCONFIRMED
Severity: major
Priority: P5
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: richardbrucebax...@hotmail.com
Created attachment 84571
--> https://bz.apache.org/ooo/attachment.cgi?id=84571&action=edit
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
--
You are receiving this mail because:
You are the assignee for the issue.
