I have been trying to import vendor supplied excel spreadsheets that have cell by cell protection. I am not supplied the password.
When these spreadsheets are read by excel, the individual entry blocks and form devices work properly.
When these spreadsheets are imported into LibreOffice Calc, the entire sheet is protected, and the cells which are editable in excel are protected in Calc, along with all the cells that are intended to be protected.
This appears to be a sheet by sheet issue, because many of these have several sheets that can be edited, but other sheets are completely protected.
Is there a workaround, assuming that I cannot acquire the passwords?