Hi everyone, we’re currently trialing Aspose.Excel for an Excel
import/export process and we’re concerned about its support for
protecting individual cells.
What we’d like to achieve is to be able to set individual cells as
‘readonly’ without effecting the overall usability of the spreadsheet.
eg. using the Style.IsLocked property requires the worksheet to
be protected. Fair enough, but when the worksheet protection is
set to ProtectionType.All or Content, then also:
- cell grouping becomes locked
- resizing columns becomes locked
- all cells default to IsLocked = true
This is not the behaviour we want. We must be able to prevent a
user from modifying the values of certain cells while preserving the
ability to group cells, resize columns, without every cell defaulting
to ‘IsLocked = true’.
Any ideas? I was thinking that perhaps there may be a way to use validation instead of worksheet protection…