[libreoffice-users] Filter an array

Hey,

I'd like to create a sheet that is essentially just an array 
reference to another spreadsheet, but filtered by a column. I.e. 
make this sheet list `{=file://./other_sheet.ods.A1:J150}` but only 
rows where the field in column C is TRUE.

I know I can filter the view of such a sheet, but I need to actually 
have only these rows show up, so I can use it in formulae.

Is this possible?

Thanks,

--
@martinkrafft | https://matrix.to/#/#madduck:madduck.net
 
"once ... in the wilds of afghanistan, i lost my corkscrew, and we
 were forced to live on nothing but food and water for days."
                              -- w. c. fields, "my little chickadee"
 
spamtraps: madduck.bogus@madduck.net

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy