FILTER

Unsupported (not recognized)

Category: Lookup and reference · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	Yes	Not yet	n/a
LibreOffice Calc	No	Yes (24.2.7.2, 2026-07-04)	Unsupported (not recognized)

=FILTER(A1:A5,B1:B5>2) on LibreOffice Calc returned #NAME?, but the documented/expected result is {c, d, e}. MISMATCH vs expected: value mismatch: expected 'c', got '#NAME?'
=FILTER(A1:A3,B1:B3>100,"none") on LibreOffice Calc returned #NAME?, but the documented/expected result is none. MISMATCH vs expected: expected 'none', got '#NAME?'
=FILTER(A1:A3,B1:B3>100) on LibreOffice Calc returned #NAME?, but the documented/expected result is #CALC!. MISMATCH vs expected: expected '#CALC!', got '#NAME?'
=FILTER(A1:B3,A1:A3>1) on LibreOffice Calc returned #NAME?, but the documented/expected result is {{2, y}, {3, z}}. MISMATCH vs expected: value mismatch: expected 2, got '#NAME?'
=FILTER({1,2,3,4},{1,0,1,0}) on LibreOffice Calc returned #NAME?, but the documented/expected result is {1, 3}. MISMATCH vs expected: value mismatch: expected 1, got '#NAME?'

Formula	Description	Result	Expected	Verdict
=FILTER(A1:A5,B1:B5>2)	Spill the subset of A1:A5 where the paired B value is >2	{#NAME?, #NAME?, #NAME?}	{c, d, e}	Mismatch
=FILTER(A1:A3,B1:B3>100,"none")	if_empty argument is returned when no rows match	#NAME?	none	Mismatch
=FILTER(A1:A3,B1:B3>100)	No if_empty and no matches raises #CALC!	#NAME?	#CALC!	Mismatch
=FILTER(A1:B3,A1:A3>1)	Filtering a 2-column range by a condition on the first column	{#NAME?, #NAME?, #NAME?, #NAME?}	{{2, y}, {3, z}}	Mismatch
=FILTER({1,2,3,4},{1,0,1,0})	Filtering an inline array literal by an inline boolean/number mask	{#NAME?, #NAME?}	{1, 3}	Mismatch