| Summary: | COUNTA() returns inconsistent values depending on entering separate cells or a corresponding cell range | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | usack |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | xiscofauli |
| Priority: | medium | Keywords: | regression |
| Version: | 4.1 all versions | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=100620 | ||
| Whiteboard: | target:6.2.0 target:6.1.0.1 target:6.0.5 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Minimum Working Example as described in the report | ||
|
Description
usack
2018-06-14 10:24:52 UTC
Created attachment 142727 [details]
Minimum Working Example as described in the report
It's certainly a bug that both variants return different results, but the result should be 3 in both cases, not 2, because none of the cells in the range are empty. It also doesn't need different sheets, a simple example A1: =COUNTA(A2:A3) A2: =B2 gives 0 instead of 1. Entering any value in B2 yields 1. Apparently the "empty cell inherited" status in A2 is considered as empty. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cfe2e4eb835c06b24adabd60c7a3fddbd3f4dbc9 Resolves: tdf#118161 use ScCellIterator::isEmpty() for COUNTA() It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/55803 for 6-1 https://gerrit.libreoffice.org/55804 for 6-0 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9bec4997fe6bceabf381e07793d2c8ba38ee19da&h=libreoffice-6-1 Resolves: tdf#118161 use ScCellIterator::isEmpty() for COUNTA() It will be available in 6.1.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=32bcda269b07a88cecbb5a2fde10d4b4d7ce7538&h=libreoffice-6-0 Resolves: tdf#118161 use ScCellIterator::isEmpty() for COUNTA() It will be available in 6.0.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. its working with Version: 6.1.0.0.beta2+ Build ID: 9bec4997fe6bceabf381e07793d2c8ba38ee19da CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group threaded Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0-5": http://cgit.freedesktop.org/libreoffice/core/commit/?id=55af68aa8929f984075fd0ae762634cde1ed29d2&h=libreoffice-6-0-5 Resolves: tdf#118161 use ScCellIterator::isEmpty() for COUNTA() It will be available in 6.0.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. The fix for this issue is already covered by sc/qa/unit/data/functions/fods/reference_operators.fods |