Automatic actualisation of Filter function in FramaCalc

[AnaisLAP]

Describe the Bug

We defined a Filter function to see only selected cells value on a line. (=FILTER($E$1:$G$1;E2:G2=1;"N/A")) When we change where the "1" values are, we have to go the cell where the function is and refresh it to see the modification appear.

EXAMPLE, when adding 1 to Name2 and Name3:
Date | Function Column 1 |  Function Column 2 | Function Column 3  | Name1 | Name2 | Name3 |
YY/MM/DD | =FILTER... | | | | 1 | 1 |
We would like the function cells to actualise immediately to:
Date | Function Column 1 |  Function Column 2 | Function Column 3  | Name1 | Name2 | Name3 |
YY/MM/DD | Name2 | Name3 | | | 1 | 1 |

Steps to Reproduce

Currently we:

• Introduce the filter function as written in the description in the cell. Press Enter.
• Add "1" when we want the person the be on schedule, press Enter.
• Nothing appears in the function cell.
  -Click on the function cell
  -Click in the function bar itself, press Enter.
  -Name2 and Name3 appear where should be.

Expected Behavior

Actualise manually works but when having numerous line to work with, it makes it impossible and users won't be able to see the changes without our intervention.
We would like our file to actualise automatically when one of the user changes his column so that everyone can see the changes without our intervention to refresh the filter function.

Desktop

(Please complete the following information)

• Collabora version: [e.g. 23.05.5.3] FramaCalc on Framasoft Drive version?
• Apple Ventura 13.4
• Safari 16.5

Additional Context

We are developing a planning for our organisation and are 30+ users working on it and 3 admin of the file. The users give us there disponibilities with a "1" and then we organise a meeting the day when we have the greater number of presents.