Bug 89114 - Contar.si no cuenta cuando la condición es contar si un rango contiene una cadena de texto
Summary: Contar.si no cuenta cuando la condición es contar si un rango contiene una c...
Status: RESOLVED DUPLICATE of bug 60345
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-04 10:43 UTC by sgv
Modified: 2015-02-04 13:19 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Ejemplo (14.00 KB, application/vnd.ms-excel)
2015-02-04 10:43 UTC, sgv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description sgv 2015-02-04 10:43:22 UTC 
Created attachment 113117 [details]
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.
Comment 1 Urmas 2015-02-04 13:19:33 UTC 

*** This bug has been marked as a duplicate of bug 60345 ***