Hi, i use Nextcloud with “Nextcloud Office” which is in the Backand a “Collabora” System.
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?
hub
May 17, 2024, 7:40pm
2
The sheet protection feature is only available in 23.05.10 or later.
1 Like
Where can i See which Version of Nextcloud Office it is and what collabora Version will used
hub
May 17, 2024, 9:50pm
4
Just go to Help > About
It will show the details.
1 Like
i think we have a newer Version.
Sorry last Mail missed some Details
COOLWSD-Version:
24.04.1.3 git hash: 89a7742(E)
LOKit-Version:
Collabora Office 24.04.1.3git hash:
Tex
May 22, 2024, 11:47pm
7
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.
in Nextcloud Office i can Filter something
1 Like
Tex
May 30, 2024, 1:41am
10
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:
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.
In Office i can’t install LibreOffice, private i have no WindowsPC, so i can only send you a excel file here.
TestExcel.xlsx (2.69 MB)
Tex
June 6, 2024, 5:19am
12
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:
Clicking on D5’s “Filter” dropdown.
Unchecking the first few options.
Pressing “OK” button.
Clicking on D5’s “Filter” dropdown again.
Clicking “All” checkbox ON.
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.
1 Like
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 (40.2 KB)
1 Like
