This is an automated email from the ASF dual-hosted git repository. jimjag pushed a commit to branch openformula in repository https://gitbox.apache.org/repos/asf/openoffice.git
commit e46e8a768d9d1b31de35df316fd365e33e79c931 Author: Jim Jagielski <[email protected]> AuthorDate: Fri Nov 13 10:17:13 2026 -0500 odf_docs: DCOUNT without a field skips rows with no content --- odf_docs/openformula-small-group-semantic-audit.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/odf_docs/openformula-small-group-semantic-audit.md b/odf_docs/openformula-small-group-semantic-audit.md index d76b4534ef..38a5f396bd 100644 --- a/odf_docs/openformula-small-group-semantic-audit.md +++ b/odf_docs/openformula-small-group-semantic-audit.md @@ -227,7 +227,7 @@ Name mapping: `main/formula/source/core/resource/core_resource.src:227-228` (`DC ``` This means DCOUNT without a field may undercount when matching records have empty cells in the result column. -**Update:** fixed. DCOUNT and DCOUNTA without a field now test every record of the range against the criteria (`ScDBQueryDataIterator::CountRecords`). Records with an empty cell in a criteria column are counted. With an empty criteria cell the count is now all records (`DB.DCOUNT.nf.nocrit` gives 3, was 0). Covered by the `DB.*` cases in `calcval-cases14.tsv`. +**Update:** fixed. DCOUNT and DCOUNTA without a field now test every row of the range that has content against the criteria (`ScDBQueryDataIterator::CountRecords`); a row with no content is not a record. Records with an empty cell in a criteria column are counted. With an empty criteria cell the count is now all records (`DB.DCOUNT.nf.nocrit` gives 3, was 0). Covered by the `DB.*` cases in `calcval-cases14.tsv`. ### Conformance Classification
