单元格格锁定问题

收藏

本帖最后由 dkings 于 2016-9-22 13:24 编辑

this.GcSpreadSheet1.ActiveSheet.DefaultStyle.Locked = false;this.GcSpreadSheet1.ActiveSheet.Cells[0, 0, this.GcSpreadSheet1.ActiveSheet.RowCount - 1, this.GcSpreadSheet1.ActiveSheet.ColumnCount - 1].Locked = false;
this.GcSpreadSheet1.ActiveSheet.Protect = true;
设置后行高列宽无法设置了
试了下面的方式处理还是无法编辑

         this.GcSpreadSheet1.ActiveSheet.RowHeader.DefaultStyle.Locked = false;
         this.GcSpreadSheet1.ActiveSheet.ColumnHeader.DefaultStyle.Locked = false;
         this.GcSpreadSheet1.ActiveSheet.ColumnHeader.Cells[0, 0,  - 1, this.GcSpreadSheet1.ActiveSheet.ColumnCount - 1].Locked = false;
         this.GcSpreadSheet1.ActiveSheet.RowHeader.Cells[0, 0, this.GcSpreadSheet1.ActiveSheet.RowCount - 1, -1].Locked =  false;