Issue 112940 - Vlookup in password protected calc files not possible
Summary: Vlookup in password protected calc files not possible
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m18
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-07-05 17:31 UTC by motorparts
Modified: 2013-07-06 18:44 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description motorparts 2010-07-05 17:31:39 UTC
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.
Comment 1 Edwin Sharp 2013-07-06 18:44:19 UTC
Why put zero in sort order of function - data is sorted in ascending order?
Without zero, correct value is returned.

Bug is confirmed because font is Times New Roman 6.8 instead of Arial 10 in File2 column B containing vlookup result.

Rev. 1499775 Win 7