GEtValue spread for winform

GEtValue spread for winform 返回对象
怎么前台单元格怎么获取 对象内容，怎么解析

getValue return的值会 自动写入单元格，这个需要return一个string 或者int 等spread单元格可以接受的类型。

我看您retrun一个list。不知道您的需求是什么。

你可以参考下 文档中的Demo

1. public class mySubEd : Form, FarPoint.Win.Spread.CellType.ISubEditor
   
2. {
   
3. public event EventHandler ValueChanged;
   
4. public event EventHandler CloseUp;
   
5. private TextBox txt = null;
   
6. private Button BtnOk = null;
   
7. private Button BtnCancel = null;
   
8. 
   
9. public mySubEd()
   
10. {
    
11. FormBorderStyle = FormBorderStyle.FixedSingle;
    
12. MaximizeBox = false;
    
13. MinimizeBox = false;
    
14. ControlBox = false;
    
15. txt = new TextBox();
    
16. BtnOk = new Button();
    
17. BtnCancel = new Button();
    
18. txt.Location = new Point(0, 0);
    
19. txt.Size = new Size(110, 200);
    
20. txt.ForeColor = Color.Red;
    
21. BtnOk.Location = new Point(3, 75);
    
22. BtnOk.Size = new Size(50, 25);
    
23. BtnOk.Text = "OK";
    
24. BtnOk.ForeColor = Color.Red;
    
25. BtnCancel.Location = new Point(57, 75);
    
26. BtnCancel.Size = new Size(50, 25);
    
27. BtnCancel.Text = "Cancel";
    
28. BtnCancel.ForeColor = Color.Red;
    
29. Controls.Add(txt);
    
30. Controls.Add(BtnOk);
    
31. Controls.Add(BtnCancel);
    
32. Text = "Editor";
    
33. BtnOk.Click += new EventHandler(OKClicked);
    
34. BtnCancel.Click += new EventHandler(CancelClicked);
    
35. txt.TextChanged += new EventHandler(txtTextChanged);
    
36. }
    
37. 
    
38. private void OKClicked(object sender, EventArgs e)
    
39. {
    
40. if (ValueChanged != null)
    
41. ValueChanged(this, EventArgs.Empty);
    
42. if (CloseUp != null)
    
43. CloseUp(this, EventArgs.Empty);
    
44. }
    
45. 
    
46. private void CancelClicked(object sender, EventArgs e)
    
47. {
    
48. if (CloseUp != null)
    
49. CloseUp(this, EventArgs.Empty);
    
50. }
    
51. 
    
52. private void txtTextChanged(object sender, EventArgs e)
    
53. {
    
54. Text = txt.Text;
    
55. }
    
56. 
    
57. public Point GetLocation(Rectangle rect)
    
58. {
    
59. Point pt = new Point(0);
    
60. Size sz = GetPreferredSize();
    
61. pt.Y = (Screen.PrimaryScreen.WorkingArea.Height/2) - (sz.Height/2);
    
62. pt.X = (Screen.PrimaryScreen.WorkingArea.Width/2) - (sz.Width/2);
    
63. return pt;
    
64. }
    
65. public Control GetSubEditorControl()
    
66. {
    
67. return this;
    
68. }
    
69. public object GetValue()
    
70. {
    
71. return txt.Text;
    
72. }
    
73. public void SetValue(object value)
    
74. {
    
75. value = txt.Text;
    
76. }
    
77. public Size GetPreferredSize()
    
78. {
    
79. return new Size(115, 130);
    
80. }
    
81. }
    
82. 
    
83. private void Form1Load(object sender, System.EventArgs e)
    
84. {
    
85. FarPoint.Win.Spread.CellType.TextCellType t = new FarPoint.Win.Spread.CellType.TextCellType();
    
86. t.SubEditor = new mySubEd();
    
87. fpSpread1.ActiveSheet.Cells[0, 0].CellType = t;
    
88. }
    
89. 
    
90. private void fpSpread1SubEditorClose(object sender, FarPoint.Win.Spread.SubEditorClosedEventArgs e)
    
91. {
    
92. textBox1.Text = e.SubEditor.ToString();
    
93. }
    

复制代码