To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112940 Issue #|112940 Summary|Vlookup in password protected calc files not possible Component|Spreadsheet Version|OOO320m18 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P2 Subcomponent|editing Assigned to|spreadsheet Reported by|motorparts
------- Additional comments from motorpa...@openoffice.org Mon Jul 5 16:31:39 +0000 2010 ------- Scenario: File1.ods is password protected. It does contain one Sheet called Sheet1 with 2 columns A and B with the value 1 in cell A2, value 2 in cell A3, and 3 in cell A4. We also have the value 11 in cell B2, the value 12 in cell B3 and the value 13 en cell B4. File2.ods is not password protected. It does contain one column A with the value 1 in cell A2, value 2 in cell A3, and 3 in cell A4. In the cell B2, we put the following formula: VLOOKUP(A2;'file:///PathOfMyFile/File1.ods'#$Sheet1.A2:B4;2;0) in order to get the values from the B column from the password protected File1.ods. -> We get #N/D as a reply of the Vlookup in the cell B2 of our File2.ods because File1.ods is password protected. Doing the same with two MS excel files, working with MS Excel, MS Excel will simply ask for the password and will get the external values. The same behevior occur even we first open File1.ods and type the password before opening File2.ods. I know a workaround could be a copy/paste with link (DDE) of the password protected file in a new sheet of File2.ods but it's not "day to day" workable for users. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org