Issue 114003 - trace dependents between different sheets, hangs Calc
Summary: trace dependents between different sheets, hangs Calc
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO330m4
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks: 84292
  Show dependency tree
 
Reported: 2010-08-20 03:52 UTC by amy2008
Modified: 2013-01-29 21:53 UTC (History)
2 users (show)

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

Attachments
Trace dependents (8.52 KB, application/vnd.sun.xml.calc)
2010-08-20 04:10 UTC, amy2008 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description amy2008 2010-08-20 03:52:46 UTC 
Can reproduce it in OOo330m4 on Ubuntu.

How to reproduce it
1 Create a new Calc doc
2 In sheet1, enter some data, more than 10 rows * 3 columns, like A1:C10
3 Enter the same data with sheet1.A1:A10 in sheet2.A1:A10
4 Enter "=VLOOKUP(A1;sheet1.$A$1:$B$10;2)" without qutations in sheet2.B1:B10,
  Enter "=VLOOKUP(A1;工作表1.$A$1:$C$10;3)" without qutations in sheet2.C1:C10
5 Switch to sheet1, select any cell in sheet1.B1:B10, like B5, Choose Tools -
  Detective - Trace Dependents;
  select any cell in sheet1.C1:C10, like C5, Choose Tools -
  Detective - Trace Dependents;

Result
OOo hangs.

Expectation
Trace dependents works well.

See attachment

Regards
Li Meiying
Comment 1 amy2008 2010-08-20 04:10:44 UTC 
Created attachment 71213 [details]
Trace dependents
Comment 2 amy2008 2010-08-23 02:55:12 UTC 
Update this issue.

How to reproduce it
1 Create a new Calc doc
2 In sheet1, enter some data, more than 10 rows * 3 columns, like A1:C10
3 Enter the same data with sheet1.A1:A10 in sheet2.A1:A10
4 Enter "=VLOOKUP(A1;sheet1.$A$1:$B$10;2)" without qutations in sheet2.B1:B10,
  Enter "=VLOOKUP(A1;工作表1.$A$1:$C$10;3)" without qutations in sheet2.C1:C10
5 Switch to sheet1, select any cell in sheet1.B1:B10, like B5, Choose Tools -
  Detective - Trace Dependents;
  select any cell in sheet1.C1:C10, like C5, Choose Tools -
  Detective - Trace Dependents;

Result
OOo hangs.

Expectation
Trace dependents works well.

See attachment

Regards
Li Meiying
Comment 3 amy2008 2010-08-23 02:56:21 UTC 
Sorry, update this issue.

How to reproduce it
1 Create a new Calc doc
2 In sheet1, enter some data, more than 10 rows * 3 columns, like A1:C10
3 Enter the same data with sheet1.A1:A10 in sheet2.A1:A10
4 Enter "=VLOOKUP(A1;sheet1.$A$1:$B$10;2)" without qutations in sheet2.B1:B10,
  Enter "=VLOOKUP(A1;sheet1.$A$1:$C$10;3)" without qutations in sheet2.C1:C10
5 Switch to sheet1, select any cell in sheet1.B1:B10, like B5, Choose Tools -
  Detective - Trace Dependents;
  select any cell in sheet1.C1:C10, like C5, Choose Tools -
  Detective - Trace Dependents;

Result
OOo hangs.

Expectation
Trace dependents works well.

See attachment

Regards
Li Meiying