Description: 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: 6.5.0.0.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 Calc: CL
Created attachment 156099 [details] Example file from Calc with lots of cells failing validation
As an enhancement, it makes sense. Moving to NEW