Is there a way to still toggle the expand/collapse buttons for Outlines/Groups in SpreadsheetGear even when the sheet has IWorksheet.ProtectContents set to true? Thanks.
Asked
Active
Viewed 339 times
0
-
There are not enough specifics and context to easily or concisely answer this question. Please clarify a couple things. Firstly, by "outlined toggle button" are you referring to a Check Box Form Control, or something else? Secondly, regarding worksheet protection (ProtectContents==true), is not clear what the actual problem is. I have some guesses as to what this might be, but the question needs to be clear on this. Please modify your question to include these details. – Tim Andersen Apr 23 '20 at 13:59
-
Sorry, For the "outlined toggle button" , it's a control that appears on the left or the top of the workbookview when you group some rows or columns, wich allow to expand or collapse this. For the ProtectContents at true, if i use it ,i can't click on this control. – Rachid Benbrik Apr 28 '20 at 07:44
-
Thanks for clarifying. I am going to modify your original post to better reflect this information (feel free to further modify if I'm still missing something), then provide an answer. – Tim Andersen Apr 28 '20 at 17:40
1 Answers
0
Short answer: not today but soon.
As of SpreadsheetGear 2017 / V8, expanding and collapsing of Outlines / Groups while worksheet protection is enabled is not supported. This restricted behavior is actually the default for Excel as well, although they offer a way around it (Worksheet.EnableOutlining / UserInterfaceOnly).
That said, the next major release of SpreadsheetGear (V9) will add support for this. I cannot comment on a release date for V9, but I'll make a note to try to update this answer with a solution once V9 is available (note I work for SpreadsheetGear).
Tim Andersen
- 3,014
- 1
- 15
- 11