When inserting the COUNTIF function via the function wizard, raw text is surrounded by single quotes, rather than double quotes. This leads to a value of 0, when the value should be some other number.
Could you please give me more information about what you mean with "raw text is surrounded by single quotes".
For numbers, the COUNTIF function should be in the format of =COUNTIF(range,criteria). For expressions and character strings, it should be in the format of =COUNTIF(range,"criteria"). When inserting via the function wizard, it is formatted as =COUNTIF(range,'criteria'). So for instance, if in cells A1-A3, we have Alice, Bob, and Carol, respectively, and we want to find how many times Alice occurs, we'd use =COUNTIF(A1:A3,"Alice"), which would return 1.
If you at any point don't surround a literal text string criteria in the COUNTIF function with double quotes (for instance, if we had just used =COUNTIF(A1:A3,Alice) above), the text string is surrounded by single quotes (so =COUNTIF(A1:A3,'Alice'), which produces the incorrect results. Not sure why it would ever be using single quotes, as numbers don't need to be surrounded by anything, and character strings and expressions need to always be surrounded by double quotes. This seems to also be a problem in documentation; while the help file tells you that you need the double quotes, the function wizard itself does not.
I can reproduce with Version: 126.96.36.199.0+
Build ID: a5fedcf7fe56a56475dea484a78971c504e52272
TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-08-29_10:16:48
Quotes totally lost with Version: 188.8.131.52.0+
Build ID: 5c1b508b172f0047d86e1acde92239ebf3438251
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-08-27_06:11:49
The same problem in functions COUNTIFS, SUMIFS, DCOUNT etc. Probably in all function wizard's search criteria.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.1 or preferably 184.108.40.206 or later)
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2015-10-14
Yeah, not seeing ANY quotes.
Win 7 Pro 64-bit Version: 220.127.116.11.alpha0+
Build ID: 9784ff3d878eaa21491fbd779e57d7d4710f5449
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default;
TinderBox: Win-x86@39, Branch:master, Time: 2016-01-30_01:31:57
Locale: fi-FI (fi_FI)
It happens only if "Automatically find column and row labels" is switched on under Tools -> Options -> Calc -> Calculate, and cell content Alice happens to be at a cell position that can be taken as a label. But that's the same when entering the formula and not related to the Function Wizard. As that Auto-Label thing can be very confusing and doing more harm than benefit the default is switched off in newer installations.
If switched off the content Alice just stays as entered in the formula, unquoted.