We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Enable Grouping & Outline/Outlining on a Protected Worksheet

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

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.

Hi,


thanks for the quick reply.

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

is there any event i can rely on?

Thanks




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.