Issue 114003

Summary:

trace dependents between different sheets, hangs Calc

Product:

Calc

Reporter:

amy2008 <amy2008>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues, ooo.redflag

Version:

OOO330m4

Target Milestone:

---

Hardware:

OS:

Linux, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Issue Depends on:

Issue Blocks:

84292

Attachments:

Description	Flags
Trace dependents	none

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