https://bugs.freedesktop.org/show_bug.cgi?id=63992
Priority: medium
Bug ID: 63992
Assignee: [email protected]
Summary: VLOOKUP fails to maintain proper link when file with
link is re-opened
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Spreadsheet
Product: LibreOffice
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
