请问WPF Spread中能不能像以前版本那样将一列类型设置成按钮

Zoe · Zoe

>>现有的列类型如何限制长度以及录入的类型？
录入类型，通过Formatter来设置，
这个和Excel的使用方法相同。
限制长度，是使用DataValidator 功能实现的，使用方法也和Excel的DataValidator 相同。

double dvalue = 12345.6789;
gcSpreadSheet1.Sheets[0].Cells[0, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardNumericMode, "c");
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = dvalue;
gcSpreadSheet1.Sheets[0].Cells[0, 1].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardDateTimeMode, "M");
gcSpreadSheet1.Sheets[0].SetValue(0, 1, new DateTime(2011, 2, 9));
gcSpreadSheet1.Sheets[0].Cells[0, 2].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter("m");
gcSpreadSheet1.Sheets[0].SetValue(0, 2, new DateTime(2012, 10, 15));
gcSpreadSheet1.Sheets[0].Cells[0, 3].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter();
gcSpreadSheet1.Sheets[0].SetValue(0, 3, new DateTime(2012, 10, 15));
gcSpreadSheet1.Sheets[0].Cells[0, 4].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "#.#%");
gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1);
gcSpreadSheet1.Sheets[0].Cells[1, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;");
gcSpreadSheet1.Sheets[0].SetValue(1, 0, 3);
gcSpreadSheet1.Invalidate();

复制代码

this.gcSpreadSheet1.ActiveSheet.Columns[0].DataValidator = DataValidator.CreateTextLengthValidator(ComparisonOperator.LessThan, 10, null);
this.gcSpreadSheet1.ValidationError += new EventHandler<GrapeCity.Windows.SpreadSheet.UI.ValidationErrorEventArgs>(gcSpreadSheet1_ValidationError);
void gcSpreadSheet1_ValidationError(object sender, GrapeCity.Windows.SpreadSheet.UI.ValidationErrorEventArgs e)
{
MessageBox.Show("The text length is invalid, please try again");
}

复制代码

gaoge00 · gaoge00

回复 10楼Zoe的帖子

/// <summary>
/// WinGCTest.xaml 的交互逻辑
/// </summary>
public partial class WinGCTest : Window
{
      public WinGCTest()
      {
         InitializeComponent();
         this.sheet1.Sheets.Clear();
         //定义一个放置Control的集合
         List<MyControl> listControls = new List<MyControl>();
         //定义一个按钮类型
         Button btn = new Button() { Content = "Click Me" };
         //定义一个事件
         btn.Click += new RoutedEventHandler(btn_Click);
         //生命一个MyControl类型的实体
         MyControl mcontrol = new MyControl() { MyControlName = "Button", MyControlType = btn };
         //添加到listControls中
         listControls.Add(mcontrol);
         this.sheet1.Sheets.Add(new MyWorkSheet() { RowCount = 10, ColumnCount = 1, DefaultColumnWidth = 100, DefaultRowHeight = 28, listControls = listControls });
         var sheet = this.sheet1.ActiveSheet;
         var sheet1 = this.sheet1.ActiveSheet as MyWorkSheet;
         if (sheet != null)
         {
            sheet1.DrawingObjectVisible = true;
            this.sheet1.InvalidateRange(-1, -1, -1, -1);
         }
      }

      void btn_Click(object sender, RoutedEventArgs e)
      {
         MessageBox.Show("这是ButtonClick事件");
      }
}

public class MyControl : Control
{
      public MyControl() : base() { }
      public string MyControlName { get; set; }
      public Control MyControlType { get; set; }
}

public class ControlDrawingObject : CustomDrawingObject
{
      private Control _rootElement;
      public ControlDrawingObject(int row, int col, Control control) : base(row, col) { _rootElement = control; this.ShowDrawingObjectOnly = true; }
      public override FrameworkElement RootElement
      {
         get { _rootElement.Margin = new Thickness(1); return _rootElement; }
      }
}

public class MyWorkSheet : Worksheet
{
      public bool DrawingObjectVisible { get; set; }
      public List<MyControl> listControls { get; set; }


      public override DrawingObject[] GetDrawingObject(int row, int column, int rowCount, int columnCount)
      {
         DrawingObject dobj;

         switch (listControls[column].MyControlName)
         {
            case "Button":
                  //Button btnDelete = new Button() { Content = "Delete" };
                  Button btnDelete = listControls[column].MyControlType as Button;
                  dobj = new ControlDrawingObject(row, column, btnDelete);
                  return new DrawingObject[] { dobj };
            default:
                  return base.GetDrawingObject(row, column, rowCount, columnCount);

         }
      }
}

Zoe · Zoe

回复 12楼gaoge00的帖子

您的代码执行结果只有最后一行才有结果的原因是因为：
同一个实例被添加到多个cell容器里，所以只有最后一个才显示。
我修改了一下您的代码，每次创建新的实例去添加到一个cell 容器中，就可以工作正常了。

this.gcSpreadSheet1.Sheets.Clear();
MyWorkSheet sheet2 = new MyWorkSheet() { RowCount = 10, ColumnCount = 1, DefaultColumnWidth = 100, DefaultRowHeight = 28};
sheet2.Columns[0].Tag = "Button";
this.gcSpreadSheet1.Sheets.Add(sheet2);
var sheet1 = this.gcSpreadSheet1.ActiveSheet as MyWorkSheet;
if (sheet1 != null)
{
sheet1.DrawingObjectVisible = true;
this.gcSpreadSheet1.InvalidateRange(-1, -1, -1, -1);
}
public class ControlDrawingObject : CustomDrawingObject
{
private Control _rootElement;
public ControlDrawingObject(int row, int col, Control control) : base(row, col) { _rootElement = control; this.ShowDrawingObjectOnly = true; }
public override FrameworkElement RootElement
{
get { _rootElement.Margin = new Thickness(1); return _rootElement; }
}
}
public class MyWorkSheet : Worksheet
{
public bool DrawingObjectVisible { get; set; }
public override DrawingObject[] GetDrawingObject(int row, int column, int rowCount, int columnCount)
{
DrawingObject dobj;
switch (this.Columns[column].Tag.ToString())
{
case "Button":
Button btnDelete = CreateCustomControl("Button") as Button;
dobj = new ControlDrawingObject(row, column, btnDelete);
return new DrawingObject[] { dobj };
default:
return base.GetDrawingObject(row, column, rowCount, columnCount);
}
}
private Control CreateCustomControl(string name)
{
switch (name)
{
case "Button":
Button btnDelete = new Button() { Content = "Delete" };
btnDelete.Click += delegate(object sender, RoutedEventArgs e)
{
MessageBox.Show("这是ButtonClick事件");
};
return btnDelete;
default:
return new TextBox();
}
}
}

复制代码

gaoge00 · gaoge00

回复 13楼Zoe的帖子

是这样的，是想写一个共通的类，这样大家把自己的类型，事件，属性，数据绑定都写好之后通过一个List传进来，然后我读取这个List中的Control ，主要就是想重用这些代码。。。。现在看来好像不行，谢谢你。先这样用着吧，谢谢您。。。

gaoge00 · gaoge00

回复 13楼Zoe的帖子

您好，今天在用您的方法改写的时候，发现一些问题，比如说，我自定义的一些控件是不受原Spread的控制的，比如设置Spread 列的水平，垂直对齐，比如说列锁定，锁定后文本框，下拉列表等都是可以使用的。。。请问有没有办法解决？

gaoge00 · gaoge00

回复 13楼Zoe的帖子

这样设置自定义列类型以后如何绑定数据呢？比如我将一个DataTable绑定到该Sheet中，Sheet中有DatePicker，CheckBox等

Zoe · Zoe

回复 15楼gaoge00的帖子

这些都要自定义控件支持这些属性，并且自己去写代码实现的。目前产品没有支持这个功能。

Zoe · Zoe

回复 16楼gaoge00的帖子

这个可以在数据绑定后，参考我给出的第一例子里面的GetValue 和SetValue 去实现。

//CheckBox
bool value = false;
object obj = this.GetValue(row, column);
if (obj != null)
{
if (obj is bool) value = (bool)obj;
else
{
bool.TryParse(obj.ToString(), out value);
}
}
CheckBox control = new CheckBox() { IsChecked = value, Content = "Check Me" };
control.Checked += delegate(object sender, RoutedEventArgs e)
{
this.SetValue(row, column, control.IsChecked);
};
control.Unchecked += delegate(object sender, RoutedEventArgs e)
{
this.SetValue(row, column, control.IsChecked);
};
dobj = new ControlDrawingObject(row, column, control);
//DateTimePicker
DateTime? value = null;
object obj = this.GetValue(row, column);
if (obj != null)
{
if (obj is DateTime) value = (DateTime)obj;
else
{
DateTime date;
if (DateTime.TryParse(obj.ToString(), out date))
{
value = date;
}
}
}
DatePicker control = new DatePicker() { SelectedDate = value };
control.LostFocus += delegate(object sender, RoutedEventArgs e)
{
this.SetValue(row, column, control.SelectedDate);
};
dobj = new ControlDrawingObject(row, column, control);

复制代码

qd98zhq · qd98zhq

请问以上的这个继承的类 CustomDrawingObject 命名空间是哪个呀，我引用不进来，找不到这个类，谢谢解答。

qd98zhq · qd98zhq

哦，明白了，是要自己自定义扩展的。不好意思，没注意看呢

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

[已处理] 请问WPF Spread中能不能像以前版本那样将一列类型设置成按钮

活字格认证