Skip to content

spreadsheet_unlock_method.md

Latest commit

 

History

History
49 lines (33 loc) · 1.08 KB

spreadsheet_unlock_method.md

File metadata and controls

49 lines (33 loc) · 1.08 KB
sidebar_label unlock()
title unlock method
description You can learn about the unlock method in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet.

unlock()

Description

@short: Unlocks a locked cell(s)

Usage

unlock(cell: string): void;

Parameters

  • cell - (required) the id(s) of a cell(s) or a range of cells

Example

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {});
spreadsheet.parse(data);

// unlocks a cell
spreadsheet.unlock("A1");

// unlocks a range of cells
spreadsheet.unlock("A1:C1");

// unlocks specified cells
spreadsheet.unlock("A1,B5,B7,D4:D6");

:::info Starting with v4.1, the reference to a cell or a range of cells can be specified in the following format:

spreadsheet.unlock("sheet1!A2");

where sheet1 is the name of the tab.

In case the name of the tab isn't specified, the method will unlock the cell(s) of the active tab. :::