I create an ods spreadsheet (in Libre office) that links to another ods file. The link works properly and looks like this: =VLOOKUP(C20,'file:///home/Rob/Documents/truck/quotes.ods'#$Sheet1.A1:B15,2,0) I save and close the file. Seconds later I open it again look at the same cell and it looks like this and obviously stops working: =VLOOKUP(C20,'file:///home/Rob/Documents/truck/home/Rob/Documents/truck/quotes.ods'#$Sheet1.A1:B15,2,0) Note that it recursed part of the link address. Here's how the data file looks: BLDP 0.94 4/26/2013 3:59pm 0.02 0.95 0.96 0.9225 198878 This should be a very simple vlookup that finds BLDP moves over one column and picks up 0.94 when working correctly.
Same core cause - this one seems to be affecting quite a few users *** This bug has been marked as a duplicate of bug 57738 ***
Hi, I read a blog somewhere that solved the problem. I was saving it as an xls. When I instead saved it as an ods it worked fine. Thanks, Rob On 05/29/2013 06:15 PM, bugzilla-daemon@freedesktop.org wrote: > Joel Madero <mailto:jmadero.dev@gmail.com> changed bug 63992 > <https://bugs.freedesktop.org/show_bug.cgi?id=63992> > What Removed Added > Status UNCONFIRMED RESOLVED > Resolution --- DUPLICATE > CC jmadero.dev@gmail.com > > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=63992#c1> > on bug 63992 <https://bugs.freedesktop.org/show_bug.cgi?id=63992> from > Joel Madero <mailto:jmadero.dev@gmail.com> * > Same core cause - this one seems to be affecting quite a few users > > *** This bug has been marked as a duplicate ofbug 57738 <show_bug.cgi?id=57738> *** > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. >
*** This bug has been marked as a duplicate of bug 60835 ***