facebooktwittermenuarrow-up

GemBox Support Forum

Using outline in a protected worksheet

Hi.
I use the outline and the protection function in a worksheet.
But I can’t expand the grouped area because it is protected.

There is way in vba to use it:
Sheets(1).Protect userinterfaceonly:=True
Sheets(1).EnableOutlining = True

How can I do this with the spreadsheet library?

Hi,

Can you send us the XLSX file which has the desired protection options?

I’ll investigate the file and let you know how to recreate those options with GemBox.Spreadsheet.

Regards,
Mario

Hi. yes of course. But how can I do this? Is the reply box i can only upload images.

Hi,

You can send us an email or submit a support ticket.
Please check our Contact page.

Or you can upload it somewhere temporarily (like your Google Drive, OneDrive, etc.) and send us the download link.

Regards,
Mario