search

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.78k stars 1.08k forks source link

Grouped columns/rows in a protected sheet are not protected #2736

Open eylenburg opened 4 months ago

eylenburg commented 4 months ago

This issue is unique.

Operating System of DocumentServer

Docker

Version information

8.0.1.31

Expected Behavior

When you create a new file in Excel and group some columns or rows (in Data -> Group), then collapse the group, then protect the sheet for editing with a password, the result is that the user won't be able to show (un-collapse) or ungroup the grouped columns/rows. A dialogue will open saying that it is protected and you may need to enter a password if you want to unprotect the sheet.

Actual Behavior

Opening the same file in OnlyOffice, you can un-collapse the group (clicking on the "+" to view the hidden cells) without password, which is different from the behaviour in Excel. Un-grouping (removing the group) is not possible without the password.

It's possible that this is intended behaviour but if not and you want to have the same behaviour as in Excel, then it would be an oversight.

Reproduction Steps

No response

Additional information

No response

rsnegirev commented 4 months ago

Hi @eylenburg

I can confirm, this is the bug number 68182. When some fixes will be done we'll text you here in this issue.

Thank you for the report!