https://issues.apache.org/ooo/show_bug.cgi?id=111250
Rob Weir <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |IRREPRODUCIBLE --- Comment #8 from Rob Weir <[email protected]> --- Cannot reproduce. Tried with AOO 3.4.1 on Windows 7. 1) Detached files from ZIP in first attachment (Pls see my comment) 2) Verified operation of VLOOKUP in sample1.ods, the file with local VLOOKUP 3) Loaded ssample2.ods. Changed value of cell from 1 to 2 to 3. It worked for 1 and 2, but not 3. Then noticed that the formula was not specify the same range as sample1.ods, so updated it to: =VLOOKUP(A1;'file:///C:/testkit/sample1.ods'#$Sheet1.D2:E101;2) 4) At that point the formula calculated correctly. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
