https://bugs.freedesktop.org/show_bug.cgi?id=72915
Priority: medium Bug ID: 72915 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Other: Error calculating with CONCATENAR and BUSCARV function Severity: normal Classification: Unclassified OS: Windows (All) Reporter: ago...@gmail.com Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 4.1.3.2 release Component: Spreadsheet Product: LibreOffice Created attachment 91040 --> https://bugs.freedesktop.org/attachment.cgi?id=91040&action=edit Spreedsheet with error in formules Using CONCATENAR and BUSCARV function takes and icorrect value There is attached my wirking sheet In E-S sheet, check that formule in F column contatenates values from D and E columns, but in F13 works until E has 5, more value or none, cause a mistake In E15 must begin in 1 but any number you put in there, in F shows a mistake I tried to chenge data from General to Text without solution Current behavior: Takes an icorrecto value without any razon Expected behavior: The formula takes a value and search it in C-I Sheet an return a value from 7 position, but doesn't work in all files Operating System: Windows 7 Version: 4.1.3.2 release -- 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