Apache OpenOffice (AOO) Bugzilla – Issue 82772
Copying cells destroys formula when caculating across two different tables
Last modified: 2017-05-20 11:15:58 UTC
1.New a Text Document 2.Insert a 3*3 table, named Table1 3.move the cursor to the below of Table1,type some key "Enter" 4.Insert a second 3*3 table, named Table2 5.input a number in Table1:B1,e.g.: 2 6.input a number in Table2:C1,e.g.: 3 7.move the cursor to Table2:A3,press key F2 8.Caculate: Table2:C1 * Table1:B1, click Button "Apply" in the Formula toolbar. 9.select line3 of Table2,CTRL+C 10.move cursor to Table2:A3, the display result above this cell would be <C1>*<A1>,instead of <C1>*<Table1.B1> PS:If I don't copy the table line, the caculate result would be correct.
Created attachment 49018 [details] Before copy
Created attachment 49019 [details] After copy
Created attachment 49020 [details] After copy
MRU->OS: when having a calculation in across two different tables as described, copying the the cell having the calculation will change the formula e.g. from "=<B1>*<Table1.C1>" to "<B1>*<C1>".
*** Issue 87418 has been marked as a duplicate of this issue. ***
target 3.x
*** Issue 98301 has been marked as a duplicate of this issue. ***
Meiying to MRU, I agree with your duplicate. But I should kindly remind you the formula you described is different from what wuy and I described. You: From "=<B1>*<Table1.C1>" to "<B1>*<C1>" wuy and me: From "=<B1>*<Table1.C1>" to "<B1>*<A1>" One is <C1>, another is <A1>, a little difference. Regards Li Meiying
CC to Meiying (amy2008)
Reset assigne to the default "issues@openoffice.apache.org".