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.
User can not give an exact count of how many cells are circled.
Any convenient way to tell the exact count of cells failing validation.
User Profile Reset: No
Version: 22.214.171.124.alpha0+ (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
Created attachment 156099 [details]
Example file from Calc with lots of cells failing validation
As an enhancement, it makes sense. Moving to NEW