validationproperties.html

永中OFFICE二次开发帮助文档

ValidationProperties</H3>
<PRE>
public <B>ValidationProperties</B>()</PRE>
<DL>
<DD>默认构件器。
<P>
</DL>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>方法详细信息</B></FONT></TH>
</TR>
</TABLE>

<A NAME="setAlertStyle(int)"><!-- --></A><H3>
setAlertStyle</H3>
<PRE>
public void <B>setAlertStyle</B>(int&nbsp;alertStyle)</PRE>
<DL>
<DD>设置出错警告的样式。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>alertStyle</CODE> - 设置出错警告的样式，alertStyle可取下列值：
 <pre>
 ALERT_STOP － 则样式为终止
 ALERT_WARN － 则样式为警告
 ALERT_INFO － 则样式为信息
 </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="setDropDown(boolean)"><!-- --></A><H3>
setDropDown</H3>
<PRE>
public void <B>setDropDown</B>(boolean&nbsp;dropDown)</PRE>
<DL>
<DD>设置是否提供下拉箭头。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>dropDown</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="setErrorMessage(java.lang.String)"><!-- --></A><H3>
setErrorMessage</H3>
<PRE>
public void <B>setErrorMessage</B>(java.lang.String&nbsp;errorMessage)</PRE>
<DL>
<DD>设置警告信息的内容。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>errorMessage</CODE> - 警告对话框的内容
 <p>
 <b>例子：</b>
 <pre>
 //此例设置警告信息的内容为"EEEEEEE"。
 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="setErrorTitle(java.lang.String)"><!-- --></A><H3>
setErrorTitle</H3>
<PRE>
public void <B>setErrorTitle</B>(java.lang.String&nbsp;errorTitle)</PRE>
<DL>
<DD>设置警告对话框的标题。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>errorTitle</CODE> - 警告对话框的标题
 <p>
 <b>例子：</b>
 <pre>
 //此例设置警告对话框的标题为"ERROR"。
 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="setFirstParameter(java.lang.String)"><!-- --></A><H3>
setFirstParameter</H3>
<PRE>
public void <B>setFirstParameter</B>(java.lang.String&nbsp;firstPara)</PRE>
<DL>
<DD>设置比较的第一个值或公式。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>firstPara</CODE> - 比较的第一(或唯一)个值或公式
 <p>
 <b>例子：</b>
 <pre>
 //此例设置比较的第一个值是0.3。
 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="setIgnoreBlank(boolean)"><!-- --></A><H3>
setIgnoreBlank</H3>
<PRE>
public void <B>setIgnoreBlank</B>(boolean&nbsp;ignoreBlank)</PRE>
<DL>
<DD>设置是否忽略空单元格。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>ignoreBlank</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="setInputMessage(java.lang.String)"><!-- --></A><H3>
setInputMessage</H3>
<PRE>
public void <B>setInputMessage</B>(java.lang.String&nbsp;inputMessage)</PRE>
<DL>
<DD>设置提示信息的内容。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>inputMessage</CODE> - 输入提示信息的内容
 <p>
 <b>例子：</b>
 <pre>
 //此例设置提示信息的内容为"mmmmmmm"。
 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="setInputTitle(java.lang.String)"><!-- --></A><H3>
setInputTitle</H3>
<PRE>
public void <B>setInputTitle</B>(java.lang.String&nbsp;inputTitle)</PRE>
<DL>
<DD>设置提示信息的标题。
 <p>
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>inputTitle</CODE> - 输入提示信息的标题
 <p>
 <b>例子：</b>
 <pre>
 //此例设置提示信息的标题为"Input"。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();