https://bugs.documentfoundation.org/show_bug.cgi?id=93706
Bug ID: 93706 Summary: MATCH don't work correctly with external file Product: LibreOffice Version: 5.0.0.5 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: major Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: kristofer...@poczta.fm Hi All, Function MATCH don't work correctly with external file. I have two formula: point 1. =MATCH(D3;$A$1:$A$100;0) point 2. =MATCH(D3;'file:///C:/Users/Kris/Desktop/OPTIMA MAGAZYN.xls'#$Lista_zasobów.$A$1:$A$1000;0) IF I understand MATCH looking some string on cell. On colum A i hafe for example in one cell= bla bla 871-03-1215 526E I'm looking D3= 871-03-1215. If I have column A and column D in one sheet everything is ok. Problem is if i have column A in external file. MATCH don't work (give me #N/D) when I change manualy in external file cell= bla bla 871-03-1215 526E to cell= 871-03-1215 formula from point 2 works. I think it is major problem. Somebody check tis on Libre 4.4.5 and this is the same. Best regards Christopher -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs