dhatim / fastexcel

Generate and read big Excel files quickly
Other
672 stars 122 forks source link

Excel error when protect sheet #199

Closed hacherey closed 1 year ago

hacherey commented 2 years ago

When I protect a Sheet:

Worksheet ws = wb.newWorksheet("Resumen");
writeSheet(ws);  //Method that write some data in the sheet
ws.protect("Some pasword");

Then, I can´t open the File:

Error: We found a problem with some content in 'informacion_programa-2.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

If I comment the ws.protect line, work great

Compared Files:

compare