Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Calc is displaying "0" when it can not find linked file | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | mmenaz <marco.menardi> | ||||||
Component: | code | Assignee: | 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: | --- | ||||||||
Attachments: |
|
Description
mmenaz
2005-10-18 18:31:27 UTC
Created attachment 30618 [details]
file that points in a formula to another calc file
Created attachment 30619 [details]
file pinted to by aurora.ods file
Hi, 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. Frank closed invalid 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. Frank, 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. mmenaz, 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. Hi, no need for a new Issue. Re-flagged as enhancement and re-assigned to requirements. Frank Hi, no need for a new Issue. Re-flagged as enhancement and re-assigned to requirements. Frank |