Regarding the following, written by "martin f krafft" on 2021-03-10 at 09:32
Uhr +1300:
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.
So I found that
```
{=IF('./other_sheed.ods'#Sheet1.C1:C150 = TRUE;
'./other_sheed.ods'#Sheet1.A1:J150; "")}
```
kinda works, but it includes empty rows for the rows not matching
the condition, which is kind of obvious.
Short of writing a script to could be used to (re-)generate such a
sheet in question at certain times, is there another way to avoid
the empty rows?
--
@martinkrafft | https://matrix.to/#/#madduck:madduck.net
a common mistake that people make
when trying to design something completely foolproof
was to underestimate the ingenuity of complete fools.
-- douglas adams, "mostly harmless"
spamtraps: madduck.bo...@madduck.net
--
To unsubscribe e-mail to: users+unsubscr...@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