Replied 8 September 2017, 5:22 am EST
We are unable to replicate the issue at our end using ActiveSheet's Protect property set to false even if cells in columnHeader are locked, we are not getting spread's ColumnHeader after being exported to Excel as unprotected and we are able to edit it in Excel.
Please have a look at the code and let us know the steps to replicate the issue along with the version of Spread you are using?
private void Form1_Load(object sender, EventArgs e)
fpSpread1.ActiveSheet.Protect = false;
// even if cells are locked, on setting protection to false.. headers are not locked.
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0, 0, fpSpread1.ActiveSheet.Columns.Count - 1].Locked = true;
fpSpread1.ActiveSheet.Cells[1, 1].Text = "Text in cells";
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].Text = "ColumnHeader";
private void Save_Click(object sender, EventArgs e)