I have a bigger spreadsheet (a few hundred rows, ~ 30 columns), and I would like to display a cell in the header with the number of errors (number of cells that have errors in them) in this spreadsheet (or in a range).
Rationale: sometimes I make bigger changes in the layout and on these occasions some formulas go south and currently there is no other way for me to test for such errors than to manually run over the spreadsheet to see if I find any errors.
I have searched for this in different ways, there are some solutions for Excel (like using an array function
=SUM(IF(ISERROR(A1:C10),1))) but these do not work in LO.
As I understand the biggest problem is that ISERROR() in LO does not work for ranges.
Is there a compact solution for this problem?
Edit: the LibreOffice version in question is 184.108.40.206