Spread for Windows Forms快速入门(8)---单元格中用户动作触发的事件

这篇文章概括介绍了单元格的哪些事件是由控件的用户动作触发的。虽然它没有全面地列出的用户可能执行的每一个动作，但是它详细地描述了用户所使用的大部分普通操作所引发的事件。

因为某些动作一直出现，或者某些动作反复出现， 我们就在列表中放弃了这部分动作。举例来说，这些列表并不包括MouseMove， MouseHover， MouseEnter， MouseLeave， Invalidated和CursorChanged事件。

如果你想在此基础上做进一步的研究，我们提供了一个示例以便你与Spread控件进行交互并且可以在列表框中查看 它们触发的相应事件。这个示例叫做fpspreadevents，位于产品安装目录的samples\examples文件夹中。

一般情况下，如果你寻找一种方法来拦截单元格中发生的每一个改变，可以考虑EditChange事件； 当用户往单元格中输入数据时，用户的每一次按键就会触发EditChange事件。

Spread中多种点击，双击，以及右键点击动作会触发这些事件：

用户动作

事件列表

点击一个普通的单元格

MouseDown

Enter

GotFocus

CellClick

LeaveCell

EnterCell

Paint

MouseUp

MouseCaptureChanged

SelectionChanged

点击一个组合框单元格并选择一项

ComboDropDown

ComboSelChange

EditChange

ComboCloseUp

点击一个多选单元格并选择一项

EditModeStarting

ControlAdded

EditModeOn

LostFocus

ButtonClicked

双击一个普通单元格（进入编辑模式）

CellDoubleClick

Layout

在Spread中，处理选择单元格操作以及使用选择区域的各种动作会导致如下事件：

选择一个单元格 - 点击一个普通（默认）的单元格

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassMouseDownMSHelpTopic.html">MouseDown</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassEnterMSHelpTopic.html">Enter</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassGotFocusMSHelpTopic.html">GotFocus</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~CellClick_EV.html">CellClick</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassMouseUpMSHelpTopic.html">MouseUp</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassMouseCaptureChangedMSHelpTopic.html">MouseCaptureChanged</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~SelectionChanged_EV.html">SelectionChanged</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassPaintMSHelpTopic.html">Paint</a>

选择一个区域的单元格 - 点击一个普通（默认）的单元格并拖到另一个单元格

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~LeaveCell_EV.html">LeaveCell</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~EnterCell_EV.html">EnterCell</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~SelectionChanging_EV.html">SelectionChanging</a>

选中一行（或一列） - 点击表头单元格

在Spread中，与输入数据相关的各种动作会触发如下事件。这仅仅是一部分。你也可以查看当输入公式时，会发生什么事件。 以下是输入一个值时引发的事件：

在单元格中输入一个值

（查看“点击单元格”所引发的事件）

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~EditChange_EV.html">EditChange</a>

（每一次按键引发重复的EditChange事件）

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~EditModeOff_EV.html">EditModeOff</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassLayoutMSHelpTopic.html">Layout</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassControlRemovedMSHelpTopic.html">ControlRemoved</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~Change_EV.html">Change</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassLostFocusMSHelpTopic.html">LostFocus</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassLeaveMSHelpTopic.html">Leave</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassValidatingMSHelpTopic.html">Validating</a>

<a href="http://www.cnblogs.com/powertoolsteam/admin/ms-its:C:%5CProgram%20Files%5CGrapeCity%5CSpread.WinForms.5.CN%5CDocs%5CFarPoint.Win.Spread.5.0.chm::/SystemWindowsFormsControlClassValidatedMSHelpTopic.html">Validated</a>

附：Spread for Windows Forms快速入门系列文章

<a href="http://www.cnblogs.com/powertoolsteam/archive/2011/08/01/2123957.html">Spread for Windows Forms快速入门(1)---开始使用Spread</a>

<a href="http://www.cnblogs.com/powertoolsteam/archive/2011/08/02/2124512.html">Spread for Windows Forms快速入门(2)---设置Spread表单</a>

<a href="http://www.cnblogs.com/powertoolsteam/archive/2011/08/02/2125325.html">Spread for Windows Forms快速入门(3)---行列操作</a>

<a href="http://www.cnblogs.com/powertoolsteam/archive/2011/08/04/2127038.html">Spread for Windows Forms快速入门(4)---常用的单元格类型（上）</a>

<a href="http://www.cnblogs.com/powertoolsteam/archive/2011/08/05/2128501.html">Spread for Windows Forms快速入门(5)---常用的单元格类型（下）</a>

<a href="http://www.cnblogs.com/powertoolsteam/archive/2011/08/08/2130786.html">Spread for Windows Forms快速入门(6)---定义单元格的外观</a>

<a href="http://www.cnblogs.com/powertoolsteam/archive/2011/08/08/2130997.html">Spread for Windows Forms快速入门(7)---单元格的交互操作</a>

相关阅读：

<a href="http://www.cnblogs.com/powertoolsteam/archive/2013/05/27/3101816.html" target="_blank">Spread for Windows Forms 7新功能使用指南</a>

<a href="http://blog.gcpowertools.com.cn/post/Spread-Studio-101-Release.aspx" target="_blank">Spread Studio 10.0v1 发布</a>

<a href="http://blog.gcpowertools.com.cn/post/Spread-JS-101-Release.aspx" target="_blank">SpreadJS 10.0v1 发布</a>