[Libreoffice-bugs] [Bug 127624] New: COUNTIF irregular result

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Sep 18 13:52:28 UTC 2019


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

            Bug ID: 127624
           Summary: COUNTIF irregular result
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: alain.touret at free.fr

Description:
=COUNTIF(<absolute range in E column>;<E column in currentline>)
gives different counts for the same criteria

First column's formula is : =COUNTIF(E$3:E$1168;E266) where the criteria E266
is in the current line

4       leclerc carrelage       VOLUME  238051  3011932003301
2       post-optimisation       VOLUME  238051  3011932003301
2       post-optimisation       VOLUME  238051  3011932003301
4       Produits restants       VOLUME  238051  3011932003301


Steps to Reproduce:
1.fill a range column with repeated words
2.insert a column on the left
3.type =COUNTIF(<absolute range>;<criteria>) example : range=E$3:E$1168
criteria E3 on line 3
4. drag last cell to fill the whole formula column for the data range
5. on the data header line, do an autofilter
6. select a value in the formula column. 

Actual Results:
The bugged behavior shows different COUNTIF values for the same criteria

Expected Results:
The normal behavior should always show the same COUNTIF values for the same
criteria


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.9
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: x11; 
Locale: fr-FR (fr_FR.UTF-8); Calc: group

-- 
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/20190918/ad13d55b/attachment.html>


More information about the Libreoffice-bugs mailing list