when using the writer::xlsx::write(&book, file_path.as_ref()) it is not preserving the protections already placed in the file.
For example, a workbook has a sheet (say 'A') where some of the range is protected. When writing to other sheets(say 'B'), the sheet 'A' is losing its protections placed.
when using the
writer::xlsx::write(&book, file_path.as_ref())
it is not preserving the protections already placed in the file.For example, a workbook has a sheet (say 'A') where some of the range is protected. When writing to other sheets(say 'B'), the sheet 'A' is losing its protections placed.