Hi everyone,
is there a way to enable protection of a worksheet?
Right now what I'm trying to do is setting a cell to protected like so:
ws.cell("D4").protection(xlnt::protection::locked_and_visible());
However it doesn't take effect. When I open the so created xlsx file in Excel I can still edit the protected cell and under cell/formatting Excel also informs me that cell protection is only effective after I enabled sheet protection.
Hi everyone,
is there a way to enable protection of a worksheet?
Right now what I'm trying to do is setting a cell to protected like so:
However it doesn't take effect. When I open the so created xlsx file in Excel I can still edit the protected cell and under cell/formatting Excel also informs me that cell protection is only effective after I enabled sheet protection.