Enable Grouping & Outline/Outlining on a Protected Worksheet

Aspose.Cells Product Family
1

hi


i have a problem to open group when the excel sheet is loocked.

i found that you should do

   sheet.EnableOutlining = True

but it doesnt work.

can you assist with that

Thanks
Shemesh

2

Hi,

In MS Excel, if a worksheet is protected, you cannot open/collapse a group clicking its “+” or “-” sign/node, you may confirm it in Ms Excel manually. If you need to perform this action, you need to unprotect worksheet first.

Thank you.

3

Hi,


thanks for the quick reply.

how can i unprotect the *** when it was clicked

is there any event i can rely on?

Thanks




4

Hi,

You can unprotect the worksheet by using either Aspose.Cells API (you might need its protection password) or you may do it in MS Excel manually using Unprotect command/option.

See the topic:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/unprotect-a-worksheet.html


And, Aspose.Cells does not support events.

Thank you.