https://bugs.documentfoundation.org/show_bug.cgi?id=89114
Bug ID: 89114
Summary: Contar.si no cuenta cuando la condición es contar si
un rango contiene una cadena de texto
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113117
--> https://bugs.documentfoundation.org/attachment.cgi?id=113117&action=edit
Ejemplo
c1=holas
c2=hola
c3=hhola
c8=CONTAR.SI(C1:C3;"hola*") da como resultado 1 y debería ser 2 (the result is
1 and must be 2)
c9=CONTAR.SI(C1:C3;"*hola*") da como resultado 0 y debería ser 3 (the result is
0 and must be 3)
Esto mismo en Excel funciona correctamente.
In Excel it works fine.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs