OOo linux 3.1.0 (both standard OOo and Ubuntu OOo).
I'm trying to help someone troubleshoot a vlookup issue:
> I am working ubuntu 9.04 and OOo3.0.1
>
> While working on vlookup (two different files) I found the final
> result with #NAME? error after many combination I could not get the
> right output.
> Incidentaly, I logout and login as different user, and I found that
> vlookup is working perfectly.
>
> I again login as earlier user and do the simple formula like link to
> another file (='point to cell in another file') it give the same error
> i.e. #NAME?
> where as if I use the formula in the same file it works perfectly, if
> I use the another file it give the error #NAME? (which is not the case
> with the second user)
>
> I concluded that there is some configuration changes made by the user
> either in Openoffice or Ubuntu which doesn't make the proper links
> between files.
> can anybody point me out where could be the problem is ??
>
So he sent me both files. Problem is that the vlookup spreadsheet has a
hardcoded link to the user directory and instead of #NAME error, I get a
Error:501 (Invalid character). I did manage to change the working
directory links but still get the 501. The funtion looks like this:
=VLOOKUP(B2,'file:///home/<myusernamefolder>/<folderwithbothfiles>/file1g.ods'#sheet1.$a$2:[.$I$25],8,0)
file2.ods has headers/info like this:
A B C D E F
S.No. E_Code E_Name Department Shift R_Time
5555555555 Mr. xyx HRD Err:501
file1.ods (the one this uses for vlookup has headers/info like this:
A B C D E F G
E_Code Employee Name DateIn Timein DateOut Timeout Department
H I
Shift Reg
A2
5555555555
B2
5555555555 xyz
C2
Dev
D2
27-Jun-09
E2
9:32 AM
F2
27-Jun-09
G2
5:55 PM
H2
HRD
I2
General 8:23
Value of A2 is '5555555555 and formated as a general number.
I've not used vlookup in quite a long time, so appreciate it if anyone
can help me figure out what I'm doing wrong. Note: I've changed the
system permissions on both files to allow read/write for anyone.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
