https://bugs.freedesktop.org/show_bug.cgi?id=41390

           Summary: EDITING - Formula is including the path file
                    information
           Product: LibreOffice
           Version: LibO 3.4.2 release
          Platform: Other
        OS/Version: Windows (All)
            Status: NEW
          Severity: critical
          Priority: medium
         Component: Spreadsheet
        AssignedTo: [email protected]
        ReportedBy: [email protected]


I am working on a Calc spreadsheet file (OS: Windows 7) contained in the
following folder:
D:\Usr\Projects\Statistical Work\Farhad\Nasofrontal Angle

I tried to paste the following formula to a cell:
=IF(B4<>"",VLOOKUP(B4,$'Median sorted by image-before'.$A$4:$D$67,4,0),"")

Once I press <Enter> what I get is:
=IF(B4<>"",VLOOKUP(B4,'file:///D:/Usr/Projects/Statistical
Work/Farhad/Nasofrontal Angle/Median sorted by image-before'#$'Median sorted by
image-before'.$A$4:$D$67,4,0),"")

Thanks

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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