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

Reply via email to