Hello,
I have trouble with the FILTER-Function.
When I enter the formula {=FILTER(A2:D11;D2:D11=G1)} in F2, only the first result and only one cell is displayed:
I would expect this behavior:
What is going wrong?
I use Onlyoffice via Nextcloud.
Spreadsheet version: 8.1.1.26
Onlyoffice Connector Version: 9.5.0
Nextcloud Hub 8: 29.0.8
Thanks for helping
Papillon
Hello @Papillon,
Please try entering the formula using the following format: =FILTER(A2:D11,D2:D11=G1)
No {} are needed.
If it doesn’t help, the issue does not occur on the most recent 8.2.2 version anyway, please update and check
Hello @DmitriiV,
thank you for replying!
Unfortunately, omitting the brackets did not lead to the desired result.
Since I use Onlyoffice as a Yunohost package, I have to wait until version 8.2.2 is made available there. I will then check it again.