[Libreoffice-bugs] [Bug 72915] Other: Error calculating with CONCATENAR and BUSCARV function
https://bugs.freedesktop.org/show_bug.cgi?id=72915 --- Comment #4 from Antonio Gonzalez F ago...@gmail.com --- Ok, now I know you are taking about With the fourth parameter in 0 works fine. Thanks a LOT and apologize for any inconvenience about my comment. Now is appropiate to close this issue with NOT A 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
[Libreoffice-bugs] [Bug 72915] Other: Error calculating with CONCATENAR and BUSCARV function
https://bugs.freedesktop.org/show_bug.cgi?id=72915 --- Comment #1 from mariosv mari...@miguelangel.mobi --- Created attachment 91061 -- https://bugs.freedesktop.org/attachment.cgi?id=91061action=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 are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 72915] Other: Error calculating with CONCATENAR and BUSCARV function
https://bugs.freedesktop.org/show_bug.cgi?id=72915 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC||mari...@miguelangel.mobi -- 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
[Libreoffice-bugs] [Bug 72915] Other: Error calculating with CONCATENAR and BUSCARV function
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=91061action=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
[Libreoffice-bugs] [Bug 72915] Other: Error calculating with CONCATENAR and BUSCARV function
https://bugs.freedesktop.org/show_bug.cgi?id=72915 --- Comment #3 from mariosv mari...@miguelangel.mobi --- Please Antonio don't reproduce the comment, only copy the paragraphs for comment about. Please what it exactly what not works for you? In CI_ES there are not pairs for 31-6 or higher. I you want an exact match add the fourth parameter with 0 in BUSCARV() when non exist result is #N/A. (Please take a look to the function help). But if you want verify several conditions there are other options to do it: E-S.F1: =SUMPRODUCT($D2='C-I'.$A$2:$A$288;$E2='C-I'.$B$2:$B$288) or E-S.F1: =COUNTIFS('C-I'.$A$2:$A$288;$D2;'C-I'.$B$2:$B$288;$E2) the result is 1 if exist or 0 for not, what you can format as TRUE/FALSE. -- 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