Struct FormControlConfig 

pub struct FormControlConfig {

    pub control_type: FormControlType,
    pub cell: String,
    pub width: Option<f64>,
    pub height: Option<f64>,
    pub text: Option<String>,
    pub macro_name: Option<String>,
    pub cell_link: Option<String>,
    pub checked: Option<bool>,
    pub min_value: Option<u32>,
    pub max_value: Option<u32>,
    pub increment: Option<u32>,
    pub page_increment: Option<u32>,
    pub current_value: Option<u32>,
    pub three_d: Option<bool>,
}

Configuration for adding a form control to a worksheet.

Fields

control_type: FormControlType

The type of form control.

cell: String

Anchor cell (top-left corner), e.g. “B2”.

width: Option<f64>

Width in points. Uses a sensible default per control type if None.

height: Option<f64>

Height in points. Uses a sensible default per control type if None.

text: Option<String>

Display text (Button, CheckBox, OptionButton, GroupBox, Label).

macro_name: Option<String>

VBA macro name (Button only).

cell_link: Option<String>

Linked cell reference for value binding (CheckBox, OptionButton, SpinButton, ScrollBar).

checked: Option<bool>

Initial checked state (CheckBox, OptionButton).

min_value: Option<u32>

Minimum value (SpinButton, ScrollBar).

max_value: Option<u32>

Maximum value (SpinButton, ScrollBar).

increment: Option<u32>

Step increment (SpinButton, ScrollBar).

page_increment: Option<u32>

Page increment (ScrollBar only).

current_value: Option<u32>

Current value (SpinButton, ScrollBar).

three_d: Option<bool>

Enable 3D shading (default true for most controls).

Implementations

impl FormControlConfig

pub fn button(cell: &str, text: &str) -> Self

Create a Button configuration.

pub fn checkbox(cell: &str, text: &str) -> Self

Create a CheckBox configuration.

pub fn spin_button(cell: &str, min: u32, max: u32) -> Self

Create a SpinButton configuration.

pub fn scroll_bar(cell: &str, min: u32, max: u32) -> Self

Create a ScrollBar configuration.

pub fn validate(&self) -> Result<()>

Validate the configuration for correctness.

Trait Implementations

impl Clone for FormControlConfig

fn clone(&self) -> FormControlConfig

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for FormControlConfig

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

Formats the value using the given formatter.