Issue 63151

Summary:

referencing sum in different spreadsheet results in 0 incorrectly

Product:

Calc

Reporter:

lingletcl <cuiling.tong>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues, lars_o_hansen

Version:

OOo 2.0.2

Keywords:

oooqa

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
reference1	none
reference2	none

Description lingletcl 2006-03-14 07:20:34 UTC

1. Open any saved spreadsheet file(extended file name is ods) and then new a  
apreadsheet file "Untitled1";
2.In the "Untitled1" document, Input the function SUM and the reference range 
is any data range such as "A1:A2" in the saved document(A1 has value 1 and A2 
has value 2), find the formula result is correct;
3.Input "12" in the cell A3 and "1" in the cell A4 in the saved document, and 
then input the function SUM (the reference range is "A3:A4" of the saved 
document)in the "Untitled1" document. I find the formula result is 0!

Comment 1 lars 2006-03-14 15:00:49 UTC

peculiar... confirmed with 680_m158 on WinXP Pro SP2

Comment 2 frank 2006-03-14 15:23:20 UTC

And this is correct behaviour. Entering the numbers in A3:A4 does not save them
to the disk and the reference to these cells isn't a DDE Link.

Only DDE links will update directly after entering the data in the source
document. All other references have to be saved and the links in the other
documents have to be updated e.g. by using Edit-Links.

So this Issue is closed invalid.

Frank

Comment 3 frank 2006-03-14 15:23:37 UTC

closed invalid

Comment 4 lingletcl 2006-03-15 01:22:00 UTC

I already saved the file and open it, refer the A3:A4, the formula result is 0, 
I think it's wrong!

Comment 5 frank 2006-03-15 12:55:59 UTC

Hi,

could not reproduce !

So please describe step by step how to repeoduce the problem.

Frank

Comment 6 lingletcl 2006-03-16 02:10:12 UTC

Created attachment 34912 [details]
reference1

Comment 7 lingletcl 2006-03-16 02:11:22 UTC

1. Open any saved spreadsheet file whose name is "ref.ods"(has data: value 1 is 
in the cell A1, value 2 is in the cell A2) and then new a spreadsheet 
file "Untitled1";
2.In the "Untitled1" document, Input the function SUM in the cell A1 whose 
reference range is data range "A1:A2" in the "ref.ods"(seen the image 
reference1.jpg),the formula result is 3, the correct answer;
3.Input value 3 in the cell B1 and value 4 in the cell B2 in the "ref.ods", 
then save it. In the "Untitled1" document, Input the function SUM in the cell 
B1 which reference range is "A3:A4" of the document "ref.ods"(seen the image 
reference2.jpg). The formula result isn't 7, but 0! It's wrong.

Comment 8 lingletcl 2006-03-16 02:12:00 UTC

Created attachment 34913 [details]
reference2

Comment 9 frank 2006-03-27 09:57:12 UTC

Hi,

as I've said before, it's not a bug but an enhancement request. To have the
values from the other file we import a hidden sheet from it. Therefore a
reference on the same sheet and file will show a zero until you manually update
the links by going to Edit-Links.

Frank

Comment 10 niklas.nebel 2006-07-07 19:25:01 UTC

changing target

Comment 11 Marcus 2017-05-20 11:13:43 UTC

Reset assigne to the default "issues@openoffice.apache.org".