Enhancements

• Added support for protecting dropdown cells while keeping other worksheet cells editable.
• Added support for cell formatting on protected worksheets.
• Added support for resizing columns and rows while worksheet protection is enabled.
• Improved Excel template usability when working with dropdown-enabled cells.
• Enhanced worksheet protection configuration for dynamically generated Excel templates.

Notes

When worksheet protection is enabled, users can now format cells and resize rows/columns while the configured dropdown cells remain protected.

New in this version

• Added an option to control cell protection (IsProtectDropdpwnCell) when creating or managing Excel dropdowns.
• Cell protection can now be enabled or disabled based on the configured protection flag.
• When true, the relevant cells are protected according to the component configuration.
• When false, the component maintains the existing behavior without applying cell protection.