Issue 56230

Summary: Calc is displaying "0" when it can not find linked file
Product: Calc Reporter: mmenaz <marco.menardi>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kpalagin
Version: OOo 2.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
file that points in a formula to another calc file
file pinted to by aurora.ods file none

Description mmenaz 2005-10-18 18:31:27 UTC
Hi, I had a.ods with a cell what referrd to BIG.ods.
Then, swithching from Windows clients and samba to a native OOo under linux, I
changed BIG.ods to big.ods, leaving the sheet name uppercase.
So in a.ods cell A1 I substitute:
but the value was 0 (instead of the correct value of that cell, 22)
I noticed that as soon as I entered the corrected filename, Calc uppercased it
(from big.ods to BIG.ods).
Then I noticed that in Edit -> Links there was:
Using "Modify" and picking up the lowercase file solved the problem.
So there are 2 issues, OMHO:
a) with case sensitive filesystem, if I have BIG.ods and big.ods, they should be
managed as 2 different files, so a new linkg to "big.ods" should be created in
the Edit -> Links list and the filename in the formula should be preserved
b) since BIG.ods does not exist anymore, Calc should complain and not return "0"

In the attached files, you have aurora.ods that is the a.ods in the above
example, and pieni.ods that was PIENI.ods and is the BIG.ods of the above example.
If in B11 you try to convert:
you will fail as described
Comment 1 mmenaz 2005-10-18 18:34:36 UTC
Created attachment 30618 [details]
file that points in a formula to another calc file
Comment 2 mmenaz 2005-10-18 18:35:26 UTC
Created attachment 30619 [details]
file pinted to by aurora.ods file
Comment 3 frank 2005-11-07 14:38:36 UTC

this is not a bug.

Changing the file name in the formula does not effect the former linking. This
*must* be done via Edit Links as the linking itself creates a hidden sheet with
the filename. To avoid accidents a change in the formula does not update this link. 

Comment 4 frank 2005-11-07 14:43:11 UTC
closed invalid
Comment 5 mmenaz 2005-11-08 18:13:24 UTC
Frank, you are telling me what the code does. I'm telling you what should do,
what the user expects to do. If you change the filename in the formula, it
should tell you that the filename is invalid. Implement it however you like, but
don't let the sheet have a value that seems ok (0) while is not (the link is not
working). As I tell you, you can rename the file, and if you can, someone sooner
or later will do. Not having Calc report the issue is a problem. In addition, if
BIG.ods is different file thatn big.ods, and the "shadow sheet" has been
automatically created when I entered BIG.ods, it should do again when I enter
big.ods, this is a consistent behaviour. At least some explicative error message
should be issued. If you don't want to consider it a bug, classify it as
"improvement", don't simpli close it please :)
In any case, the implementatino of the "shadow sheet" is really bad to me, even
if (or expecially because) is as Excell works.
Comment 6 kpalagin 2006-09-13 09:58:50 UTC
showing "0" instead of what is in the source cell is just plain wrong. It will 
badly bite somebody.
Please see if this behaviuor can be revised so that user is sufficiently 
warned that data not to be trusted. If Calc can not find linked file then user 
should be told so AND saved (pre-update) data should be displayed (instead of 
silently displaying zero). Offering to run "Edit Links" would be nice bonus.

I think it is not about the case, but about displaying "0" when Calc can not 
update link so I am changing Summary. Please file separate issue describing 
the problem with case, if you see fit.
Comment 7 frank 2006-09-13 11:10:08 UTC

no need for a new Issue. Re-flagged as enhancement and re-assigned to requirements.

Comment 8 frank 2006-09-13 11:10:15 UTC

no need for a new Issue. Re-flagged as enhancement and re-assigned to requirements.