GrapeCity.Documents.Excel.IProtectionSettings.AllowUsingPivotTables

AllowUsingPivotTables Property

AllowUsingPivotTables

Gets or sets whether the user is allowed to use pivot tables on a protected worksheet.

This property indicates whether users can work with pivot tables when worksheet protection is enabled.

Declaration

bool AllowUsingPivotTables { get; set; }

Property AllowUsingPivotTables As Boolean

Examples

worksheet.Protection = true;
IProtectionSettings protectionSettings = worksheet.ProtectionSettings;
protectionSettings.AllowUsingPivotTables = true;
bool allowUsingPivotTables = protectionSettings.AllowUsingPivotTables;