Bug 73035 - Other: Invalid countif result on Named range
Summary: Other: Invalid countif result on Named range
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.4.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-26 06:14 UTC by suradetj
Modified: 2020-11-26 04:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
The sample of wrong behavior of countif (112.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-26 06:14 UTC, suradetj 		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 suradetj 2013-12-26 06:14:32 UTC 
Created attachment 91190 [details]
The sample of wrong behavior of countif

Problem description: 
Wrong countif result

Steps to reproduce:
1. Enter C in Cell Midterm.F1 

Current behavior:
Countif will show 1 count as C+ (Cell AN11) and C (Cell AN12)

Expected behavior:
Countif will show only count as C+ (Cell AN11) and C (Cell AN12)
              
Operating System: Windows 8
Version: 4.1.4.2 release
Comment 1 GerardF 2013-12-26 07:46:12 UTC 
Hi,

The COUNTIF Help says: "The search supports regular expressions"

+ finds one or more of the characters in front of the "+", so COUNTIF(range;C+) will find C, CC, CCC, ...etc

"You can switch the automatic evaluation of regular expression on and off in Tools - Options - LibreOffice Calc - Calculate."

Closed as "Not a bug".
Comment 2 markwell 2019-11-30 04:40:10 UTC 
Thanks for sharing the post and nice to see this here. Get the details about pets here. https://dogsfud.com/can-dogs-have-tylenol/
Comment 3 pourvan 2020-11-26 04:12:28 UTC 
LiteBlue.usps.gov online portal site is specially designed for liteblue usps gov worker. Liteblue is the official portal for United Stated Postal Service employees. Use liteblue.usps.gov to log in to your Liteblue to man age work. https://liteblue.fun