To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108404 Issue #|108404 Summary|value return 0 from link of calc file with password Component|Spreadsheet Version|OOO320m8 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|formatting Assigned to|spreadsheet Reported by|yohan14
------- Additional comments from [email protected] Mon Jan 18 09:06:43 +0000 2010 ------- 1. create ODS (i.e "transaction.ods")and save as with password "abc" 2. create another ODS file (i.e "master.ods")and save as with password "xyz" 3. put value in cell A1, B1, C1 = 1, 2, 3 in "master.ods" 4. link A1, B1, C1 in "transaction.ods" to A1, B1, C1 in "master.ods" (cell A1 in "transaction.ods" will contain like this "='file:///C:/master.ods'#Sheet1.A1") [in normal case, value of A1, B1, C1 in "transaction.ods" should be the same as value of A1, B1, C1 in "master.ods"] close the file and save the changes. 5. open file "transaction.ods", enter the password. A dialog box will appear. click "Yes" to update the file with the link contained. 6. Cell A1, B1, and C1 will be "0" (Zero) If you remove password of file "master.ods", cell A1, B1, C1 of "transaction.ods" will return the value of A1,B1, C1 of "master.ods" correctly. --------------------------------------------------------------------- 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]
