This property can be used to allow modification of a cell in a protected
worksheet. In Excel, cell locking is turned on by default for all
cells. However, it only has an effect if the worksheet has been protected
using the worksheet worksheet_protect() function:
@code
format = workbook_add_format(workbook);
format_set_unlocked(format);
// Enable worksheet protection, without password or options.
worksheet_protect(worksheet, NULL, NULL);
// This cell cannot be edited.
worksheet_write_formula(worksheet, 0, 0, "=1+2", NULL);
// This cell can be edited.
worksheet_write_formula(worksheet, 1, 0, "=1+2", format);
@endcode
@brief Set the cell unlocked state.
@param format Pointer to a Format instance.
This property can be used to allow modification of a cell in a protected worksheet. In Excel, cell locking is turned on by default for all cells. However, it only has an effect if the worksheet has been protected using the worksheet worksheet_protect() function:
@code format = workbook_add_format(workbook); format_set_unlocked(format);
// Enable worksheet protection, without password or options. worksheet_protect(worksheet, NULL, NULL);
// This cell cannot be edited. worksheet_write_formula(worksheet, 0, 0, "=1+2", NULL);
// This cell can be edited. worksheet_write_formula(worksheet, 1, 0, "=1+2", format); @endcode