https://bugs.freedesktop.org/show_bug.cgi?id=72915
--- Comment #2 from Antonio Gonzalez F <ago...@gmail.com> --- Thanks for your quick answer I tried many things, but doesn't work The search works fine in most rows, but some of them is not right, thats why a thing is a bug or something cause the logic is fine and works with some data. This problem maybe in inherited from prior design, becouse in Excel occurs the same mistake, working with TEXT or NUMBER. The main difference in Excel is the Warning Icon shown in the cell with the problem. The main need is to look into other table to chaeck is the information is the same (self data integrity check) Did you tried changing the numbers I said? If this is not a bug, please tell me why works in some rows and other doesn't. Thanks a lot for you help. *** Si escribes a mas de uno, usa CCO (con copia oculta) *** Antonio González Fayad - *Asesor Informático* Proveedor de Soluciones en Hardware y Software Cel.300 8112330 "Si no te muestras como eres, el mundo no sabrá darte lo que quieres" 2013/12/20 <bugzilla-dae...@freedesktop.org> > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=72915#c1> on > bug 72915 <https://bugs.freedesktop.org/show_bug.cgi?id=72915> from mariosv > <mari...@miguelangel.mobi> * > > Created attachment 91061 > <https://bugs.freedesktop.org/attachment.cgi?id=91061> [details] > <https://bugs.freedesktop.org/attachment.cgi?id=91061&action=edit> > Sample file modified. > > Hi Antonio, thanks for reporting. > > The table where to look is unsorted, this is why you need to put the fourth > parameter in BUSCARV() - VLOOKUP() to zero. > > Maybe you need create the text to search and the searched column with > something > like: > TEXT(D15;"00-")&TEXT(E15;"00") so CI_ES keeps sorted. So you can avoid the > fourth parameter. > > Please take a look to your sample file modified. > > I can't see a bug there. > Changed to NOTABUG, please if you are not agree reopen it. > > ------------------------------ > You are receiving this mail because: > > - You reported the bug. > > -- 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
