Securtiy in apache open office

Copper Contributor

our business has multiple branches using an excel workbook. When a sheet is protected in Excel and then opened in Apache open office, the password protection is lost. How do I prevent Open Office from stripping the password protection?

1 Reply
I'm afraid there is no way you can do that. Hunch: what happens if you save the file in .xls format (not very convenient, but who knows...)?