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: [email protected]
--
To unsubscribe e-mail to: [email protected]
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
