theorchard / openpyxl

Other
54 stars 21 forks source link

IMP : Openpyxl by default making all the cells protected for a protected worksheet while reading an existing worksheet #54

Open Mtushar22 opened 5 months ago

Mtushar22 commented 5 months ago

Steps to replicate :

  1. Create a workbook with a protected sheet .
  2. Make only certain cells of the worksheet protected .
  3. Load this worksheet using openpyxl load_workbook .
  4. Write data to the protected sheet and save it as a new file .
  5. Once you open the new file , in the protected sheet you will observe all cells have now become protected and you can't edit the cells which were unprotected earlier