Spread JS程序发布后不起作用

收藏

在源代码调试模式下JS是有效的，23列单元格填写价格失去焦点会计算得出总价，写在24列里面。程序发布后，23列填写价格失去焦点后，JS不执行连alert("TE")都不会弹出信息。请问是什么原因引起的呢？

<script language="javascript" type="text/javascript" id="FpSpread1_Script0">
   function FpSpread1_EditStopped(event) {
      //Add code to handle your event here.
      alert(" TE ");
      var spread = this.document.getElementById("FpSpreadGV");
      var activecol = spread.GetActiveCol();
      var activeRow = spread.GetActiveRow();
      if (activecol == 23 && spread.GetValue(activeRow, 23).length > 0) {
         var usage = parseFloat(spread.GetValue(activeRow, 5));
         var price = parseFloat(spread.GetValue(activeRow, 23));
         if (usage > 0) {
               spread.SetValue(activeRow, 24, usage * price, true);
         }
         else {
               var itemNo = parseFloat(spread.GetValue(activeRow, 0));
               var rc = spread.GetRowCount();
               for (var i = 0; i < rc - 1; i++) {
                  var value = parseFloat(spread.GetValue(i, 0));
                  usage = parseFloat(spread.GetValue(i, 5));
                  if (value == itemNo && usage > 0) {
                     spread.SetValue(activeRow, 24, usage * price, true);
                     break;
                  }
               }
         }
      }
   }
</script>

dexteryao · dexteryao

您用的是aspnet 吧
FpSpreadGV 的 ClientID有可能会变，所以建议下面的写法
var spread = this.document.getElementById("<%=FpSpreadGV.ClientID %>");

一萧一剑 · 一萧一剑

dexteryao 发表于 2016-11-15 15:25
您用的是aspnet 吧
FpSpreadGV 的 ClientID有可能会变，所以建议下面的写法
var spread = this.docume ...

你说的对的，我明天测试一下，应该可以解决了，Thanks.

dexteryao · dexteryao

不客气

一萧一剑 · 一萧一剑

dexteryao 发表于 2016-11-15 15:25
您用的是aspnet 吧
FpSpreadGV 的 ClientID有可能会变，所以建议下面的写法
var spread = this.docume ...

还是不行啊， function FpSpread1_EditStopped(event)这个事件都不进来(源代码调试会进来)，
事件进来至少会先弹出 "TE" 显示
function FpSpread1_EditStopped(event) {
      //Add code to handle your event here.
      alert(" TE ");
}

<FarPoint:FpSpread ID="FpSpreadGV" runat="server" BorderColor="Black" BorderStyle="Solid"
         BorderWidth="1px" Height="510px" Width="100%" ActiveSheetViewIndex="0"
         currentPageIndex="0"

         DesignString="<?xml version="1.0" encoding="utf-8"?><Spread />"
         onbuttoncommand="FpSpreadGV_ButtonCommand"
         oncreatebutton="FpSpreadGV_CreateButton" EnableAjaxCall="False">
<TitleInfo BackColor="#E7EFF7" ForeColor="" HorizontalAlign="Center" VerticalAlign="NotSet"
            Font-Size="X-Large" Font-Bold="False" Font-Italic="False" Font-Overline="False"
            Font-Strikeout="False" Font-Underline="False"></TitleInfo>

         <Pager Font-Bold="False" Font-Italic="False" Font-Overline="False"
            Font-Strikeout="False" Font-Underline="False" />

         <CommandBar BackColor="Control" ButtonFaceColor="Control" ButtonHighlightColor="ControlLightLight"
            ButtonShadowColor="ControlDark">
<Background BackgroundImageUrl="SPREADCLIENTPATH:/img/cbbg.gif"></Background>
         </CommandBar>
                  <ClientEvents EditStopped="FpSpread1_EditStopped" />
         <Sheets>

                  DataAutoCellTypes="False" AutoGenerateColumns="False"
                  ColumnHeaderHeight="30" AllowSort="True">
                  <ColumnHeader Height="30" />
            </FarPoint:SheetView>
         </Sheets>
         <HierBar Font-Bold="False" Font-Italic="False" Font-Overline="False"
            Font-Strikeout="False" Font-Underline="False" />
      </FarPoint:FpSpread>

dexteryao · dexteryao

您试试下面的方式

<script lang="javascript" type="text/javascript">
window.onload = function () {
var spread1 = document.getElementById("<%=FpSpread1.ClientID %>");
if (document.all) {
// IE
if (spread1.addEventListener) {
// IE9
spread1.addEventListener("EditStopped", cellChanged, false);
} else {
// Other versions of IE and IE9 quirks mode (no doctype set)
spread1.onEditStopped = cellChanged;
}
}
else {
// Firefox
spread1.addEventListener("EditStopped ", cellChanged, false);
}
}
function cellChanged(event) {
alert("r"+event.row+",c"+event.col);
}
</script>

复制代码

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

[已处理] Spread JS程序发布后不起作用

5 个回复

评分

活字格认证

微信认证勋章

元老葡萄

讲师达人

悬赏达人

SpreadJS 认证

SpreadJS 高级认证