Spreadsheet: Block an entire row or column.

Webix JS
#1

Hi,

it would be really useful I think to be able to block a column or a row. There are sheets where several columns must be locked (for example, on a rate sheet, lock columns with references and names, and unlock only rate columns).

I tried to block the cells in a loop ($$(“ssheet”).lockCell(i, 2, true);), but when there are several columns to block and several thousand rows, the page freezes and crashes.

Olivier

#2

Hi,

You can set lock range by providing start and end cells as lockCell arguments:

$$("sheet").lockCell(
   {row:1, column:2}, 
   {row:$$("sheet").config.rowCount, column:2}, 
   true
);

https://snippet.webix.com/4ja4gg8f

In this way, Spreadsheet will be re-painted just once, so performance will not suffer.

#3

Great! Thanks Helga.