Spreadsheet setActiveSheetProtected("") method not working as expected

[vaadin-bot]

Originally by [email protected]

---

Hi there,

We are using Vaadin 7.6.5 on Tomcat v7.0.55 and while testing Spreadsheet 1.2.2 before purchasing, we have noticed an issue while testing the sheet.setActiveSheetProtected("") method.

When we create a Spreadsheet based on a InputStream coming from a Google Sheet published as a .xlsx Excel file, it is still possible to edit and fill empty cells though you can't change cells already populated.

It is strange as when we use the same procedure but using an Excel file in a DropBox folder, the setActiveSheetProtected("") method really works as expected.

The use case of the Google Sheet is really import for us, and we would need a fix for this before proceeding with the purchase. We intend to buy a perpetual license so we would need the solution in the same major version.

Many thanks in advance, Luis

---

Imported from https://dev.vaadin.com/ issue #20382