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
