java - Locking cells in a JXL-generated Excel document -

Do some cells prevent users from being edited? I have tried the following:

  WritableCellFormat cf = new WritableCellFormat (); Cf.setLocked (true); Sheet.edcl (new number (call, row, value, cf));  

Although this file is opened in Excel, it can still be changed to the cell contents i.e. resulting in no effect on the spreadsheet.

You must give "active" protection for each sheet. I do not know how this should be done. I found method

  sheet .set protected (true);  

But obviously this method has not been recommended anymore. So you probably should try to find something new.

Edit: Sorry, my mistake. Every cell in this lock sheet

Edit 2:. It works for me if you lock entiry sheet and then unlock editable cells

  sheet.getSettings () setProtected. (truth); Writeable sealformat unlock = new writable cellFormat (); Unlocked.setLocked (wrong); Label L = new label (0, 0, "", unlocked); Sheet.addCell (L);