https://bugs.freedesktop.org/show_bug.cgi?id=87973
Bug ID: 87973
Summary: vlookup formula changed in path to external csv file
after saved and re-opened
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 111659
--> https://bugs.freedesktop.org/attachment.cgi?id=111659&action=edit
the file that contains the changed formulae
In "test2.xlsx", there are formulae fetching data from a csv file "data2.csv"
located in a different folder.
After the file was saved and re-opened, the formulae changed to something like
those reported in an already reported bug
(https://bugs.freedesktop.org/show_bug.cgi?id=63992).
Then, I tried to correct the formulae by deleting the extra parts. After the
file was saved and re-opened again, the formulae changed to something like
this:
VLOOKUP(A2,[3]data2!a$1:B$20,2,0)
That is, the path to the referenced file (data2.csv) has changed to [3].
--
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