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.
Alright, waiting for further details after the check on the recent version.
Also, please make sure that you go to the cell with formula and press Enter key after you, for example, enter “IT” value in G1 cell