validationproperties.html

永中OFFICE二次开发帮助文档

 Range range = worksheet.getRange("B3:E5");
 ValidationProperties validation = new ValidationProperties();
 validation.setType(DataValidationConstants.TYPE_DEC);
 validation.setOperator(DataValidationConstants.OPR_BETWEEN);
 validation.setFirstParameter("0.3");
 validation.setSecondParameter("0.6");
 validation.setIgnoreBlank(true);
 validation.setDropDown(true);
 validation.setShowInput(true);
 validation.setInputTitle("Input");
 validation.setInputMessage("mmmmmmm");
 range.setValidation(validation);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setOperator(int)"><!-- --></A><H3>
setOperator</H3>
<PRE>
public void <B>setOperator</B>(int&nbsp;operator)</PRE>
<DL>
<DD>设置比较操作符。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>operator</CODE> - 比较操作符的类型：operator取下列值：
 <pre>
 OPR_BETWEEN － 介于
 OPR_NOT_BETWEEN － 不介于
 OPR_EQUALS － 等于
 OPR_NOT_EQUALS － 不等于
 OPR_GREATER_THAN － 大于
 OPR_LESS_TAHN － 小于
 OPR_GREATER_AND_EQUALS － 大于等于
 OPR_LESS_AND_EQUALS － 小于等于
 </pre>
 <p>
 <b>例子：</b>
 <pre>
 //此例设置比较操作符为介于。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = worksheet.getRange("B3:E5");
 ValidationProperties validation = new ValidationProperties();
 validation.setType(DataValidationConstants.TYPE_DEC);
 validation.setOperator(DataValidationConstants.OPR_BETWEEN);
 validation.setFirstParameter("0.3");
 validation.setSecondParameter("0.6");
 validation.setShowError(true);
 validation.setAlertStyle(DataValidationConstants.ALERT_STOP);
 validation.setErrorTitle("ERRER");
 validation.setErrorMessage("EEEEEEE");
 range.setValidation(validation);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界<DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/DataValidationConstants.html" title="application.constants 中的接口"><CODE>DataValidationConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setSecondParameter(java.lang.String)"><!-- --></A><H3>
setSecondParameter</H3>
<PRE>
public void <B>setSecondParameter</B>(java.lang.String&nbsp;secondPara)</PRE>
<DL>
<DD>设置比较的第二个值或公式。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>secondPara</CODE> - 比较的第二个值或公式
 <p>
 <b>例子：</b>
 <pre>
 //此例设置比较的第二个值为0.6。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = worksheet.getRange("B3:E5");
 ValidationProperties validation = new ValidationProperties();
 validation.setType(DataValidationConstants.TYPE_DEC);
 validation.setOperator(DataValidationConstants.OPR_BETWEEN);
 validation.setFirstParameter("0.3");
 validation.setSecondParameter("0.6");
 validation.setShowError(true);
 validation.setAlertStyle(DataValidationConstants.ALERT_STOP);
 validation.setErrorTitle("ERRER");
 validation.setErrorMessage("EEEEEEE");
 range.setValidation(validation);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setShowError(boolean)"><!-- --></A><H3>
setShowError</H3>
<PRE>
public void <B>setShowError</B>(boolean&nbsp;showError)</PRE>
<DL>
<DD>设置是否显示警告信息。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>showError</CODE> - 布尔型，如为true，当输入内容不符合校验时，弹出警告对话框；否则，不弹出警告对话框
 <p>
 <b>例子：</b>
 <pre>
 //此例设置显示警告信息。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = worksheet.getRange("B3:E5");
 ValidationProperties validation = new ValidationProperties();
 validation.setType(DataValidationConstants.TYPE_DEC);
 validation.setOperator(DataValidationConstants.OPR_BETWEEN);
 validation.setFirstParameter("0.3");
 validation.setSecondParameter("0.6");
 validation.setShowError(true);
 validation.setAlertStyle(DataValidationConstants.ALERT_STOP);
 validation.setErrorTitle("ERRER");
 validation.setErrorMessage("EEEEEEE");
 range.setValidation(validation);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setShowInput(boolean)"><!-- --></A><H3>
setShowInput</H3>
<PRE>
public void <B>setShowInput</B>(boolean&nbsp;showInput)</PRE>
<DL>
<DD>设置是否显示提示信息。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>showInput</CODE> - 布尔型，如为true，设置显示提示信息；否则不显示提示信息
 <p>
 <b>例子：</b>
 <pre>
 //此例设置显示提示信息。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = worksheet.getRange("B3:E5");
 ValidationProperties validation = new ValidationProperties();
 validation.setType(DataValidationConstants.TYPE_DEC);
 validation.setOperator(DataValidationConstants.OPR_BETWEEN);
 validation.setFirstParameter("0.3");
 validation.setSecondParameter("0.6");
 validation.setIgnoreBlank(true);
 validation.setDropDown(true);
 validation.setShowInput(true);
 validation.setInputTitle("Input");
 validation.setInputMessage("mmmmmmm");
 range.setValidation(validation);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setType(int)"><!-- --></A><H3>
setType</H3>
<PRE>
public void <B>setType</B>(int&nbsp;type)</PRE>
<DL>
<DD>设置校验的类型。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>type</CODE> - 校验的类型，type可取下列值：
 <pre>
 TYPE_ANY － 任何类型
 TYPE_INT － 整数
 TYPE_DEC － 小数
 TYPE_LIST － 列表
 TYPE_DATE － 日期
 TYPE_TIME － 时间
 TYPE_LENGTH － 文本长度
 TYPE_CUSTOM － 用户自定义
 </pre>
 <p>
 <b>例子：</b>
 <pre>
 //此例设置校验类型为小数。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Range range = worksheet.getRange("B3:E5");
 ValidationProperties validation = new ValidationProperties();
 validation.setType(DataValidationConstants.TYPE_DEC);
 validation.setOperator(DataValidationConstants.OPR_BETWEEN);
 validation.setFirstParameter("0.3");
 validation.setSecondParameter("0.6");
 validation.setIgnoreBlank(true);
 validation.setDropDown(true);
 validation.setShowInput(true);
 validation.setInputTitle("Input");
 validation.setInputMessage("mmmmmmm");
 validation.setShowError(true);
 validation.setAlertStyle(DataValidationConstants.ALERT_STOP);
 validation.setErrorTitle("ERRER");
 validation.setErrorMessage("EEEEEEE");
 range.setValidation(validation);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界<DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/DataValidationConstants.html" title="application.constants 中的接口"><CODE>DataValidationConstants</CODE></A></DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="跳过导航链接"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>概述</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>软件包</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>类</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>树</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>索引</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>帮助</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/TextSplittingProperties.html" title="application.workbooks.workbook.worksheets.worksheet 中的类"><B>上一个类</B></A>&nbsp;
&nbsp;下一个类</FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../index.html?application/workbooks/workbook/worksheets/worksheet/ValidationProperties.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="ValidationProperties.html" target="_top"><B>无框架</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>所有类</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../allclasses-noframe.html"><B>所有类</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  摘要：&nbsp;嵌套&nbsp;|&nbsp;字段&nbsp;|&nbsp;<A HREF="#constructor_summary">构造方法</A>&nbsp;|&nbsp;<A HREF="#method_summary">方法</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
详细信息：&nbsp;字段&nbsp;|&nbsp;<A HREF="#constructor_detail">构造方法</A>&nbsp;|&nbsp;<A HREF="#method_detail">方法</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>
版权所有 2001-2006 无锡永中科技有限公司
</BODY>
</HTML>