Bug 129018 - Count number of cells failing validation
Summary: Count number of cells failing validation
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2019-11-25 14:58 UTC by NISZ LibreOffice Team
Modified: 2020-04-27 21:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

Example file from Calc with lots of cells failing validation (10.89 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-11-25 14:59 UTC, NISZ LibreOffice Team

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-11-25 14:58:36 UTC
A user asked whether Calc has a feature that makes it possible to count the number of cells in a range that fail cell validation, i. e. they would be circled with the Tools – Detective – Mark Invalid Data command. 
While red circles are useful, a cell with a function or a small window indicating the exact number would give more peace of mind, especially with large spreadsheets.

Steps to Reproduce:
1.	Open attached file. It contains some characters and numbers in column A with validation set for whole numbers > 0.
2.	Choose Tools – Detective – Mark Invalid Data
3.	A lot of cells are circled in column A.

Actual Results:
User can not give an exact count of how many cells are circled.

Expected Results:
Any convenient way to tell the exact count of cells failing validation.

Reproducible: Always

User Profile Reset: No

Additional Info:
LibreOffice details:
Version: (x64)
Build ID: 7e09d08807b5ba2fd8b9831557752a415bdad562
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: en-US (hu_HU); UI-Language: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2019-11-25 14:59:06 UTC
Created attachment 156099 [details]
Example file from Calc with lots of cells failing validation
Comment 2 Xisco Faulí 2019-11-26 10:29:30 UTC
As an enhancement, it makes sense. Moving to NEW