I'm sorry for my google english ;o)
I spent much time with creating a little program but now
I do not know what to do.
The users have to download an Excel file, edit it and finally upload it to my app.
For my laziness
I will not allow users to change
the order of columns. Therefore I protect the sheet with a password.
So far so good.
But now the users can't insert new lines because all cells are locked by default.
I tried to create a template excel file. In this file I unlocked all cells, load it in my app, fill data - But again, all cells locked!
At the alternate excel framework (PEAR - ExcelSpreadsheetWriter) this problem does not appear, but it can't read and write version 2007.
Now my question: how can I set ALL cells unlocked initially?