按钮单元格问题

收藏

请问如何实现图片中的单元格效果。
目前尝试两种办法
1.

fpSpread1_Sheet1.Cells[1,1].CellType = new GcTextBoxCellType()
         {
            SideButtons = new SideButtonCollectionInfo()
            {
                  new SideButtonInfo()
                  {
                     Enabled = true,
                     Interval = 1,
                     Text = "选",
                     ButtonWidth = 25
                  }
            }
         };

这种方式找不到接口响应Click事件

2.自定义单元格类型
public class ContentCellButton : FarPoint.Win.Spread.CellType.ButtonCellType
{
      public override void PaintCell(System.Drawing.Graphics g, System.Drawing.Rectangle r,
         FarPoint.Win.Spread.Appearance appearance, object value, bool isSelected, bool isLocked, float zoomFactor)
      {
         Rectangle _rectangle = new Rectangle(r.Right - 25, r.Y, 25, r.Height);

         base.PaintCell(g, _rectangle, appearance, value, isSelected, isLocked, zoomFactor);
      }
}

这种方式实现，当单元格选中时，按钮还是会覆盖整个单元格

dexteryao · dexteryao

在EditModeOn事件中给sidebutton 挂click事件

fpSpread1_Sheet1.Cells[1, 1].CellType = new GcTextBoxCellType()
{
SideButtons = new SideButtonCollectionInfo()
{
new SideButtonInfo()
{
Enabled = true,
Interval = 1,
Text = "选",
ButtonWidth = 25,
Name = "testbutton"
},
},
};
fpSpread1.EditModeOn += FpSpread1_EditModeOn;

复制代码

private void FpSpread1_EditModeOn(object sender, EventArgs e)
{
int iRow = fpSpread1.ActiveSheet.ActiveRowIndex;
int iCol = fpSpread1.ActiveSheet.ActiveColumnIndex;
if (fpSpread1.ActiveSheet.GetCellType(iRow, iCol) is GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType)
{
(fpSpread1.EditingControl as GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxEditingControl).SideButtons["testbutton"].Click -= new EventHandler(sideButtonClick);
(fpSpread1.EditingControl as GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxEditingControl).SideButtons["testbutton"].Click += new EventHandler(sideButtonClick);
}
}

复制代码

lkxtracy · lkxtracy

多谢大神！

dexteryao · dexteryao

		自动登录	找回密码
密码			立即注册

[已处理] 按钮单元格问题

3 个回复

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章