I want to create a XLSX file using Apache POI with structure protection, like this:
XSSFWorkbook wb = new XSSFWorkbook();
wb.lockStructure();
wb.setWorkbookPassword(PASSWORD, null);
When I open the file generated in Excel, I check that it is correctly protected. However, when opening it in LibreOffice, the file is not protected, allowing editing of the structure.
Is it a bug in POI or in LibreOffice? Or I’m missing something?