# NextcloudOffice Excel **URL:** \ **Category:** User Support\ **Created:** [May 17, 2024, 6:25am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622 "2024-05-17T06:25:22Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [May 17, 2024, 6:25am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/1 "2024-05-17T06:25:22Z")
Hi, i use Nextcloud with “Nextcloud Office” which is in the Backand a “Collabora” System. i have the Problem, that in Excel i have blocked to filter the entries. In the Online Version i can use the filter, so i can see the entries which are blocked for the user. Can you help me there? My question from german translate to englich by Google: _Hello everyone,_ _We have the “standard” Nextcloud office in Nextcloud._ _In the office we work with Microsoft Office._ _Here I have an Excel table in which I have hidden some things using filters and hide. I have locked individual cells using “Protect Sheet” and prevented hidden areas from being shown._ _This works in Excel._ _In Nextcloud Office I cannot overwrite the blocked fields, but I can show all the specified filters for deleted / hidden content._ _can you deactivate this?_ _Does it work better with “onlyOffice” for example?_ ---
**Author:** ![hub](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/hub/32/883_2.png) [@hub](https://forum.collaboraonline.com/u/hub)\ **Post date:** [May 17, 2024, 7:40pm UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/2 "2024-05-17T19:40:31Z")
The sheet protection feature is only available in 23.05.10 or later. ---
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [May 17, 2024, 8:00pm UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/3 "2024-05-17T20:00:57Z")
Where can i See which Version of Nextcloud Office it is and what collabora Version will used ---
**Author:** ![hub](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/hub/32/883_2.png) [@hub](https://forum.collaboraonline.com/u/hub)\ **Post date:** [May 17, 2024, 9:50pm UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/4 "2024-05-17T21:50:32Z")
Just go to Help \> About It will show the details. ---
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [May 18, 2024, 6:22am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/5 "2024-05-18T06:22:36Z")
i think we have a newer Version. A Field that is locked can‘t overwrite, but the „FilterFunction“ is blocked, in NextcloudOffice it is Not blocked. # Nextcloud Office ---
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [May 19, 2024, 5:08am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/6 "2024-05-19T05:08:22Z")
Sorry last Mail missed some Details COOLWSD-Version: 24.04.1.3 git hash: 89a7742(E) LOKit-Version: built on a great technology base Collabora Office 24.04.1.3git hash: ---
**Author:** ![Tex](https://avatars.discourse-cdn.com/v4/letter/t/eb8c5e/32.png) [@Tex](https://forum.collaboraonline.com/u/Tex)\ **Post date:** [May 22, 2024, 11:47pm UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/7 "2024-05-22T23:47:14Z")
Hey @NicolasGlatz. Welcome to the forum + thanks for the question/info. 🙂 * * * Can you share screenshots too? I’m not that familiar with Calc’s/Excel’s “Sheet Protection”, but it might help if you show: - How it looks in Excel. - How it looks in Nextcloud Office. I think that might help too. 🙂 ---
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [May 23, 2024, 8:09am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/8 "2024-05-23T08:09:01Z")
![Excel](https://europe1.discourse-cdn.com/flex013/uploads/collaboraonline/original/2X/1/1ec21a68692bbca38af0cc49ad40170e0a57e78e.png) in Nextcloud Office i can Filter something in Excel the filter we can few but not chance the filter ---
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [May 23, 2024, 8:09am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/9 "2024-05-23T08:09:47Z")
![image001](https://europe1.discourse-cdn.com/flex013/uploads/collaboraonline/original/2X/5/5f1426f7332dbbed5f5698232eacc43b05ae86d5.png) Nextcloud Office ---
**Author:** ![Tex](https://avatars.discourse-cdn.com/v4/letter/t/eb8c5e/32.png) [@Tex](https://forum.collaboraonline.com/u/Tex)\ **Post date:** [May 30, 2024, 1:41am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/10 "2024-05-30T01:41:04Z")
Fantastic @NicolasGlatz. Thank you for the screenshots. Can you create and share: - A sample ODS or XLSX document with some of this locked away / hidden stuff + a few filters? Also: - Does this same thing happen if you open your spreadsheet in LibreOffice 24.2? * * * **Side Note:** While digging through the LibreOffice Bugzilla, I stumbled across this feature request too: - [Bug #158733: “Add UI Configuration Option To Disable Showing Hidden Filter Elements As Inactive In Autofilter”](https://bugs.documentfoundation.org/show_bug.cgi?id=158733) Seems like AutoFilter has some strange interactions when dealing with MULTIPLE filtered selections too. Perhaps your use of “Protected/Hidden Cells” + “Protect Sheet” + AutoFilters causes some real strange edge-cases here too. ---
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [June 5, 2024, 3:44pm UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/11 "2024-06-05T15:44:35Z")
In Office i can’t install LibreOffice, private i have no WindowsPC, so i can only send you a excel file here. [TestExcel.xlsx](https://forum.collaboraonline.com/uploads/short-url/nQydovW9XM9GPHTy5ot0GNjDcpl.xlsx) (2.69 MB) ---
**Author:** ![Tex](https://avatars.discourse-cdn.com/v4/letter/t/eb8c5e/32.png) [@Tex](https://forum.collaboraonline.com/u/Tex)\ **Post date:** [June 6, 2024, 5:19am UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/12 "2024-06-06T05:19:31Z")
> [@NicolasGlatz](#): > > In Office i can’t install LibreOffice, private i have no WindowsPC, so i can only send you a excel file here. Thanks for sharing the file. I see the XLSX is: - ~1 million rows… - With 10 showing. Rest are hidden. - And then goes all the way to column “GP”. * * * Using your test file… In LO 24.2.3, I was also able to get many more rows of data showing by: 1. Clicking on D5’s “Filter” dropdown. 2. Unchecking the first few options. 3. Pressing “OK” button. 4. Clicking on D5’s “Filter” dropdown again. 5. Clicking “All” checkbox ON. 6. Pressing “OK” button. It went from the initial row 10 showing → row 138. * * * In Excel 365, Version 2405 (Build 17628.20110): - Trying to click on the little “Filter” dropdowns didn’t do anything. - They were showing there, but it was as if they were “disabled”. - (Maybe because of protected sheet?) - You could hover over the Filter to see it was showing only things in column D that started with “150-”. I was not able to get it to do the popup similar to your screenshot above. But there definitely was some different interaction there compared to LO vs. Excel. * * * **Note:** Any chance you could boil this down to a nicer MWE (Minimal Working Example) file? It would probably be a little more helpful with a smaller XLSX with something like: - 100 sample rows - + ability to see inside the hidden/password/Protected Sheet too for easier debugging. 🙂 ---
**Author:** ![NicolasGlatz](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@NicolasGlatz](https://forum.collaboraonline.com/u/NicolasGlatz)\ **Post date:** [June 6, 2024, 1:10pm UTC](https://forum.collaboraonline.com/t/nextcloudoffice-excel/2622/13 "2024-06-06T13:10:14Z")
Thanks, now a new Version. Korrekt, the user only see the 5 entries which begins with „150-„ I wan’t the funktion of excel 365 [TestExcel.xlsx](https://forum.collaboraonline.com/uploads/short-url/6Xq3kaIIUAjTs1UUsyi45dYGg1j.xlsx) (40.2 KB)