Bug 137488 - Calc: COUNTIF gives an error if the first parameter is a call to BASE
Summary: Calc: COUNTIF gives an error if the first parameter is a call to BASE
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-14 21:19 UTC by David Lynch
Modified: 2020-10-15 11:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Demonstates bug 137488 (9.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-14 21:21 UTC, David Lynch 		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 David Lynch 2020-10-14 21:19:37 UTC 
Description:
1	        0	                Err:504
=BASE(1,14)	=COUNTIF(A1,"vv")	=COUNTIF(BASE(1,14),"vv")
See attached spreadsheet

Steps to Reproduce:
See attached spreadsheet

Actual Results:
See attached spreadsheet

Expected Results:
A3 should be 0 not Err:504


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.2.2 (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
Comment 1 David Lynch 2020-10-14 21:21:17 UTC 
Created attachment 166372 [details]
Demonstates bug 137488
Comment 2 [REDACTED] 2020-10-15 11:43:19 UTC 
From my perspective not a bug. Function COUNTIF() requires a range [1] as first argument and BASE doesn't provide a range but text [2].

=COUNTIF(A1,"vv") counts occurrences of "vv" in cell *A1*, but where should =COUNTIF(BASE(1,14),"vv") search for?

[1] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060181.html?DbPAR=CALC#bm_id3164897

[2] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html?DbPAR=CALC#bm_id3153072