[Libreoffice-bugs] [Bug 137488] New: Calc: COUNTIF gives an error if the first parameter is a call to BASE

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137488

            Bug ID: 137488
           Summary: Calc: COUNTIF gives an error if the first parameter is
                    a call to BASE
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dlynch1319 at googlemail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201014/ab08dfc0/attachment.htm>