If you need to share a spreadsheet which contains specific info that should be shown to some of the users only, you can filter the spreadsheet as you want to hide data and then just share it using the newly added Custom Filter permission. Read on to learn all the details.
Custom Filter allows hiding the data you don’t want to show. In other words, users won’t be able to change the filter you’ve applied before sharing your spreadsheet and will be able to work only with the specified fields.
Besides, Custom Filter lets multiple users apply their own filters while working together in real-time without disturbing co-authors. So, users with the Custom Filter permission are able to edit the spreadsheet, however all their actions with the filters will not be visible to other co-authors and will not be saved to the file, such actions will be displayed only locally.
You should know that:
To share an .xlsx file with the Custom Filter permission, open its sharing settings from the Documents module or do it right in the spreadsheet editor from the Collaboration tab -> Sharing.
We are happy to invite you to ONLYOFFICE WebWeek 2020 — a series of online presentations, workshops, and social media activities to introduce big updates in the ONLYOFFICE product line on October 15 – 22. Learn about the event