To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56230 Issue #:|56230 Summary:|referring to a file that has changed case of filename |behaves abnormally Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|mmenaz
------- Additional comments from [EMAIL PROTECTED] Tue Oct 18 10:31:27 -0700 2005 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]