Apache OpenOffice (AOO) Bugzilla – Issue 56230
Calc is displaying "0" when it can not find linked file
Last modified: 2013-08-07 15:12: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: ='file:///z/zzz_calc_test/BIG.ods'#$BIG.F8 with ='file:///z/zzz_calc_test/big.ods'#$BIG.F8 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: =file:///z/zzz_calc_test/BIG.ods 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: ='file:///z/zzz_calc_test/zip/PIENI.ods'#$PIENI.F8 to ='file:///z/zzz_calc_test/zip/pieni.ods'#$PIENI.F8 you will fail as described
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