关于spread StyleName

spread cell的StyleName=“Locked”和cell的Locked属性="True"有什么区别？StyleName有什么作用？请高手帮忙解答一下，谢谢

回复 1楼yrpting的帖子

StyleName 用户设置单元格的样式，StyleName=“Locked” 中的 Locked 只是 NameStyle 的名称。参考代码：

1. 
   
2. FarPoint.Win.Spread.NamedStyle ns = new FarPoint.Win.Spread.NamedStyle("StyleData", "DataAreaDefault");
   
3. ns.BackColor = Color.LightBlue;
   
4. ns.Border = new FarPoint.Win.LineBorder(Color.DarkBlue, 2);
   
5. ns.CellType = new FarPoint.Win.Spread.CellType.TextCellType();
   
6. ns.Editor = new FarPoint.Win.Spread.CellType.TextCellType();
   
7. ns.Font = new Font("Comic Sans Serif", 12);
   
8. ns.ForeColor = Color.Red;
   
9. ns.Formatter = new FarPoint.Win.Spread.CellType.TextCellType();
   
10. ns.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
    
11. ns.Name = "StyleData";
    
12. ns.Parent = "DataAreaDefault";
    
13. ns.Renderer = new FarPoint.Win.Spread.CellType.TextCellType();
    
14. ns.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom;
    
15. fpSpread1.NamedStyles.Add(ns);
    
16. fpSpread1.ActiveSheet.Cells[0, 0].StyleName = "StyleData";
    
17. fpSpread1.ActiveSheet.SetText(0, 0, "NamedStyle");
    
18. fpSpread1.ActiveSheet.Columns[0].Width = 120;
    
19. fpSpread1.ActiveSheet.Rows[0].Height = 80;
    

复制代码

Cell 的 Locked 属性用于设置是否锁定单元格禁止用户编辑。

1. 
   
2. 
   
3. fpSpread1.Sheets[0].Cells[0, 0].Locked = true;
   

复制代码

谢谢

回复 3楼yrpting的帖子

不客气