Struct ProtectionOptions 

pub struct ProtectionOptions {
    pub password_hash: Option<String>,
    pub select_locked_cells: bool,
    pub select_unlocked_cells: bool,
    pub format_cells: bool,
    pub format_columns: bool,
    pub format_rows: bool,
    pub insert_columns: bool,
    pub insert_rows: bool,
    pub delete_columns: bool,
    pub delete_rows: bool,
    pub sort: bool,
    pub auto_filter: bool,
}

Worksheet protection options

Fields

password_hash: Option<String>

Password hash (optional) - use set_password() to hash

select_locked_cells: bool

Allow selecting locked cells (default: true)

select_unlocked_cells: bool

Allow selecting unlocked cells (default: true)

format_cells: bool

Allow formatting cells (default: false)

format_columns: bool

Allow formatting columns (default: false)

format_rows: bool

Allow formatting rows (default: false)

insert_columns: bool

Allow inserting columns (default: false)

insert_rows: bool

Allow inserting rows (default: false)

delete_columns: bool

Allow deleting columns (default: false)

delete_rows: bool

Allow deleting rows (default: false)

sort: bool

Allow sorting (default: false)

auto_filter: bool

Allow auto filter (default: false)

Implementations

impl ProtectionOptions

pub fn new() -> Self

Create new protection with default settings (most restrictive)

pub fn with_password(self, password: &str) -> Self

Set password for protection (hashed with Excel’s algorithm)

pub fn allow_select_locked_cells(self, allow: bool) -> Self

Allow users to select locked cells

pub fn allow_select_unlocked_cells(self, allow: bool) -> Self

Allow users to select unlocked cells

pub fn allow_format_cells(self, allow: bool) -> Self

Allow users to format cells

pub fn allow_format_columns(self, allow: bool) -> Self

Allow users to format columns

pub fn allow_format_rows(self, allow: bool) -> Self

Allow users to format rows

pub fn allow_insert_columns(self, allow: bool) -> Self

Allow users to insert columns

pub fn allow_insert_rows(self, allow: bool) -> Self

Allow users to insert rows

pub fn allow_delete_columns(self, allow: bool) -> Self

Allow users to delete columns

pub fn allow_delete_rows(self, allow: bool) -> Self

Allow users to delete rows

pub fn allow_sort(self, allow: bool) -> Self

Allow users to sort

pub fn allow_auto_filter(self, allow: bool) -> Self

Allow users to use auto filter

Trait Implementations

impl Clone for ProtectionOptions

fn clone(&self) -> ProtectionOptions

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for ProtectionOptions

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for ProtectionOptions

fn default() -> Self

Returns the “default value” for a type.