Issue 82772 - Copying cells destroys formula when caculating across two different tables
Summary: Copying cells destroys formula when caculating across two different tables
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.0 RC1
Hardware: All Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 87418 98301 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-10-19 04:07 UTC by wuyan.ooorg
Modified: 2017-05-20 11:15 UTC (History)
3 users (show)

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


Attachments
Before copy (87.58 KB, image/jpeg)
2007-10-19 04:10 UTC, wuyan.ooorg
no flags Details
After copy (94.88 KB, text/plain)
2007-10-19 04:10 UTC, wuyan.ooorg
no flags Details
After copy (94.88 KB, image/jpeg)
2007-10-19 04:11 UTC, wuyan.ooorg
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description wuyan.ooorg 2007-10-19 04:07:42 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.
Comment 1 wuyan.ooorg 2007-10-19 04:10:21 UTC
Created attachment 49018 [details]
Before copy
Comment 2 wuyan.ooorg 2007-10-19 04:10:57 UTC
Created attachment 49019 [details]
After copy
Comment 3 wuyan.ooorg 2007-10-19 04:11:18 UTC
Created attachment 49020 [details]
After copy
Comment 4 michael.ruess 2007-10-19 09:31:46 UTC
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>".
Comment 5 michael.ruess 2008-03-26 11:37:46 UTC
*** Issue 87418 has been marked as a duplicate of this issue. ***
Comment 6 Mathias_Bauer 2008-04-25 11:19:01 UTC
target 3.x
Comment 7 michael.ruess 2009-01-22 11:42:55 UTC
*** Issue 98301 has been marked as a duplicate of this issue. ***
Comment 8 amy2008 2009-01-23 01:17:06 UTC
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 
Comment 9 amy2008 2009-01-23 01:18:16 UTC
CC to Meiying (amy2008)
Comment 10 Marcus 2017-05-20 11:15:58 UTC
Reset assigne to the default "issues@openoffice.apache.org".