Bug 165821 - COUNTA on a true »empty range« returns 1
Summary: COUNTA on a true »empty range« returns 1
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-19 12:53 UTC by Werner Tietz
Modified: 2025-03-19 17:14 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
COUNTA on empty ranges (2.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-03-19 17:14 UTC, Mike Kaganski 		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 Werner Tietz 2025-03-19 12:53:30 UTC 
Description:
Open a new spreadsheet-Document and enter into A1 the Formula:
```=COUNTA(K:K)```
it returns 1 instead expected 0

Steps to Reproduce:
see descriptio

Actual Results:
the Formula returns »1«

Expected Results:
the observed Range is empty, so I would expect »0« as result


Reproducible: Always


User Profile Reset: No

Additional Info:
Happens with:
```
Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 6.6; UI render: Skia/Vulkan; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Debian package version: 4:7.4.7-1+deb12u7
Calc: threaded
```

also with:

```
Version: 25.2.1.2 (AARCH64) / LibreOffice Community
Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded
```
and Develop-Built from Source:

```
Version: 25.8.0.0.alpha0+ (AARCH64) / LibreOffice Community
Build ID: c10dbe07b7def2eebd8eed3874c3df9b9d37fa41
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
```
Comment 1 Vladimir Sokolinskiy 2025-03-19 13:25:42 UTC 
Repro.

Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: fddf2685c70b461e7832239a0162a77216259f22
CPU threads: 6; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL threaded
Comment 2 m_a_riosv 2025-03-19 15:20:31 UTC 
Reproducible.
Moving the cell to column L and back to column A, works fine, seems like initially it is counting column A not column K.

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: e1c7923596f39bac8ce926b56a2450911ffde4d8
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-GB
Calc: CL threaded
Comment 3 Mike Kaganski 2025-03-19 17:14:16 UTC 
Created attachment 199906 [details]
COUNTA on empty ranges

The attachment opens with 0,0,0 in A1:A3 in v.7.3.0; but it has 1,2,3 in v.7.4.0.

Regression after 9e2d48b9e04f7ea895fb095699c32ed8a44eb129