https://bugs.documentfoundation.org/show_bug.cgi?id=171994
--- Comment #2 from [email protected] <[email protected]> --- Sorry I've made a mistake in giving the sample formula. The real used that has this behavior is : ASSEMBV( SIERREUR(FILTRE($'Résultats P6'.$B$6:$Z$23;($'Résultats P6'.$Z$6:$Z$23<>"")*($'Résultats P6'.$Z$6:$Z$23>0));{}); SIERREUR(FILTRE($'Résultats P5'.$B$6:$Z$23;($'Résultats P5'.$Z$6:$Z$23<>"")*($'Résultats P5'.$Z$6:$Z$23>0));{}); SIERREUR(FILTRE($'Résultats P4'.$B$6:$Z$23;($'Résultats P4'.$Z$6:$Z$23<>"")*($'Résultats P4'.$Z$6:$Z$23>0));{}); SIERREUR(FILTRE($'Résultats P3'.$B$6:$Z$23;($'Résultats P3'.$Z$6:$Z$23<>"")*($'Résultats P3'.$Z$6:$Z$23>0));{}); SIERREUR(FILTRE($'Résultats P2'.$B$6:$Z$23;($'Résultats P2'.$Z$6:$Z$23<>"")*($'Résultats P2'.$Z$6:$Z$23>0));{}); SIERREUR(FILTRE($'Résultats P1'.$B$6:$Z$23;($'Résultats P1'.$Z$6:$Z$23<>"")*($'Résultats P1'.$Z$6:$Z$23>0));{})) It's a little bit complex and involves eight sheets to stack filters, that may be empty. The only way I found to achieve this was to try to create each filter, and if in error, return an empty matrix for that filter, and then stack them in the result matrix. What I would report is the fact that the {} expression that I used in the IFERROR statement is automatically replaced by {#N/D} after validating (ctrl+enter). If I used "" in place I got ERR539 a. At the time it seems to work, but if I save, close and reload the file, i get ERR539 in the resulting matrix cells. To make it work again, I need to go thru the formula to take all the #N/D statements away. -- You are receiving this mail because: You are the assignee for the bug.
