Bug 129455 - Wildcards not working for COUNTIF in Calc
Summary: Wildcards not working for COUNTIF in Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-12-17 18:49 UTC by Jack
Modified: 2019-12-17 20:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
countif wildcard example (9.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-17 19:33 UTC, Oliver Brinzing 		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 Jack 2019-12-17 18:49:20 UTC 
Description:
Wildcards not working for COUNTIF in Calc

Steps to Reproduce:
1.Put "United	States	Treasury  Note" across A1-D1, one word per column.
2. Do: =COUNTIF(A1:D1,"*Treas*")


Actual Results:
It results in FALSE. 

Expected Results:
It should result in TRUE. In Excel it does result in TRUE.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Oliver Brinzing 2019-12-17 19:33:32 UTC 
Created attachment 156633 [details]
countif wildcard example
Comment 2 Oliver Brinzing 2019-12-17 19:37:01 UTC 
> It results in FALSE. 

I can not confirm this, attached example results to 1.

Can you please check Tools/Options/LibreOffice Calc/Calculate

[x] Enable Wildcards in formulas
[ ] Enable regular expressions in formulas
[ ] No wildcards or regular expression in formulas

I have set the bug's status to 'NEEDINFO'. 
Please change it back to 'UNCONFIRMED' once the requested info is provided.
Comment 3 Jack 2019-12-17 20:21:38 UTC 
I've found that the error doesn't happen when I copy and paste the data and formula from the old sheet to a new sheet, but only on the old sheet.  So I guess no easy way to recreate it.
Comment 4 Jack 2019-12-17 20:22:31 UTC 
Enabling wildcards worked.

Thank you!