Ask Your Question

Revision history [back]

You cannot resize a protected cell; which implies that you cannot resize a column having at least a single protected cell. If your column consists of only unprotected cells, it may be resized (just tested with 5.4.4.2). Which allows you to (re)structure your spreadsheet to have whole unprotected column to get it resizable. Other than that, protecting is protecting, so you have to provide enough space in advance for possible amounts of data at the spreadsheet construction phase. You are the creator of some king of application, and ignoring possible input is bug of yours.