如果有兩個farpoint, 綁定DateCalendar 到列裡會出錯

收藏

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test2.aspx.cs" Inherits="test2" %>

<%@ Register assembly="FarPoint.Web.Spread, Version=6.0.3505.2008, Culture=neutral, PublicKeyToken=327c3516b1b18457" namespace="FarPoint.Web.Spread" tagprefix="FarPoint" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
      <asp:ScriptManager runat="Server" ID="ScriptManager1"></asp:ScriptManager>
      <FarPoint:FpSpread ID="FpSpread1" runat="server" BorderColor="Black"
         BorderStyle="Solid" BorderWidth="1px" Height="200" Width="400">
         <commandbar backcolor="Control" buttonfacecolor="Control"
            buttonhighlightcolor="ControlLightLight" buttonshadowcolor="ControlDark">
         </commandbar>
         <sheets>
            <FarPoint:SheetView SheetName="Sheet1">
            </FarPoint:SheetView>
         </sheets>
      </FarPoint:FpSpread>

</div>
<FarPoint:FpSpread ID="FpSpread2" runat="server" BorderColor="Black"
      BorderStyle="Solid" BorderWidth="1px" Height="200" Width="400">
      <commandbar backcolor="Control" buttonfacecolor="Control"
         buttonhighlightcolor="ControlLightLight" buttonshadowcolor="ControlDark">
      </commandbar>
      <sheets>
         <FarPoint:SheetView SheetName="Sheet1">
         </FarPoint:SheetView>
      </sheets>
</FarPoint:FpSpread>
</form>
</body>
</html>

//後台
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class test2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
      FarPoint.Web.Spread.Extender.DateCalendarCellType dc = new FarPoint.Web.Spread.Extender.DateCalendarCellType();

      //dc.Animated = true;

      dc.DateFormat = "yyyy-MM-dd";

      //dc.EnableOnClient = true;

      //dc.ShowEditor = true;

      //dc.OnClientDateSelectionChanged = "datechange";

      FpSpread1.ActiveSheetView.Columns[0].CellType = dc;
}
}

iceman · iceman

回复 17楼dongpowudi的帖子

:share:
欢迎欢迎～
期待 dongpowudi 有好的使用经验也和大家分享

dongpowudi · dongpowudi

学习学习，正遇到相似情况！

iceman · iceman

回复 15楼wlp5402的帖子

正则表达式如下："(19|20)?[0-9]{2}[- /.](0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])"

wlp5402 · wlp5402

還有輸入2010-22-02不會提示?

wlp5402 · wlp5402

還有一個問題就是我想輸入2001-1-1或2001-01-01都是可以的表達式要怎麼寫?

wlp5402 · wlp5402

回复 12楼iceman的帖子

360截图20120731173721343.jpg (21.68 KB, 下载次数: 31)

iceman · iceman

回复 11楼wlp5402的帖子

感谢你的理解，有解决方案我会尽快通知楼主。

wlp5402 · wlp5402

回复 10楼iceman的帖子

好的,謝謝,不過上面的問題希望能盡快解決.

iceman · iceman

回复 9楼wlp5402的帖子

测试代码如下：

if (IsPostBack)
return;
FarPoint.Web.Spread.RegExpCellType regex = new FarPoint.Web.Spread.RegExpCellType();
System.Globalization.DateTimeFormatInfo timeInfo=new System.Globalization.DateTimeFormatInfo();
timeInfo.DateSeparator="-";
regex.DateTimeFormat = timeInfo;
regex.ErrorMessage = "输入格式错误。正确格式为：yyyy-MM-dd";
regex.ValidationExpression = @"\d{4}-\d{2}-\d{2}";
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = regex;

复制代码

效果如

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

[已处理] 如果有兩個farpoint, 綁定DateCalendar 到列裡會出錯

17 个回复

活字格认证

微信认证勋章

元老葡萄