protectproperties.html

永中OFFICE二次开发帮助文档

</DD>
</DL>
<HR>

<A NAME="setAllowDeleteRows(boolean)"><!-- --></A><H3>
setAllowDeleteRows</H3>
<PRE>
public void <B>setAllowDeleteRows</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许删除行。如果为 True，则允许用户在受保护的工作表上删除行，要删除的行中的每个单元格都是解除锁定的。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许删除行
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许删除行
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowDeleteRows(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowEditingObject(boolean)"><!-- --></A><H3>
setAllowEditingObject</H3>
<PRE>
public void <B>setAllowEditingObject</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许编辑对象。如果为 True，则保护方案。本参数仅对工作表有效。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许编辑对象
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许编辑对象
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowEditingObject(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowEditingScenarios(boolean)"><!-- --></A><H3>
setAllowEditingScenarios</H3>
<PRE>
public void <B>setAllowEditingScenarios</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许编辑方案。如果为 True，则允许用户在受保护的工作表上使用编辑对象。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许编辑方案
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许编辑方案
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowEditingScenarios(true);
 protectProperties.setAllowFormattingCells(true);
 protectProperties.setAllowInsertingColumns(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowFiltering(boolean)"><!-- --></A><H3>
setAllowFiltering</H3>
<PRE>
public void <B>setAllowFiltering</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许自动筛选。如果为 True，则允许用户在受保护的工作表上设置筛选。用户可以更改筛选条件，但是不能启用或禁用自动筛选功能。
 用户也可以在已有的自动筛选功能上设置筛选。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许设置筛选
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许自动筛选
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowFiltering(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowFormattingCells(boolean)"><!-- --></A><H3>
setAllowFormattingCells</H3>
<PRE>
public void <B>setAllowFormattingCells</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许格式化单元格。如果为 True，则允许用户为受保护的工作表上的任意单元格设置格式。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许格式化单元格
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许格式化单元格
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowFormattingCells(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowFormattingColumns(boolean)"><!-- --></A><H3>
setAllowFormattingColumns</H3>
<PRE>
public void <B>setAllowFormattingColumns</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许格式化列。如果为 True，则允许用户为受保护的工作表上的任意列设置格式。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许格式化列
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许格式化列
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowFormattingColumns(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowFormattingRows(boolean)"><!-- --></A><H3>
setAllowFormattingRows</H3>
<PRE>
public void <B>setAllowFormattingRows</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许格式化行。如果为 True，则允许用户为受保护的工作表上的任意行设置格式。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许格式化行
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许格式化行
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowFormattingRows(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowInsertingColumns(boolean)"><!-- --></A><H3>
setAllowInsertingColumns</H3>
<PRE>
public void <B>setAllowInsertingColumns</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许插入列。如果为 True，则允许用户在受保护的工作表上插入列。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许插入列
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许插入列
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowInsertingColumns(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowInsertingHyperlinks(boolean)"><!-- --></A><H3>
setAllowInsertingHyperlinks</H3>
<PRE>
public void <B>setAllowInsertingHyperlinks</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许插入超链接。如果为 True，则允许用户在受保护的工作表中插入超链接。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许插入超链接
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许插入超链接
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowInsertingHyperlinks(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowInsertingRows(boolean)"><!-- --></A><H3>
setAllowInsertingRows</H3>
<PRE>
public void <B>setAllowInsertingRows</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许插入行。如果为 True，则允许用户在受保护的工作表上插入行。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许插入行
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许插入行
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowInsertingRows(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowSorting(boolean)"><!-- --></A><H3>
setAllowSorting</H3>
<PRE>
public void <B>setAllowSorting</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许排序。如果为 True，则允许用户在受保护的工作表上进行排序。排序区域中的每个单元格必须是解除锁定的或取消保护的。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许排序
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许排序
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowSorting(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setAllowUsingPivotTables(boolean)"><!-- --></A><H3>
setAllowUsingPivotTables</H3>
<PRE>
public void <B>setAllowUsingPivotTables</B>(boolean&nbsp;b)</PRE>
<DL>
<DD>是否允许使用数据透视表。如果为 True，则允许用户在受保护的工作表上使用数据透视表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>b</CODE> - true为允许使用数据透视表
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并允许使用数据透视表
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setAllowUsingPivotTables(true);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSelectionStyle(int)"><!-- --></A><H3>
setSelectionStyle</H3>
<PRE>
public void <B>setSelectionStyle</B>(int&nbsp;selection)</PRE>
<DL>
<DD>设置工作表选取方式。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>selection</CODE> - 工作表选取方式，其取值为如下常量：
 <pre>
 ProtectConstants.NO_SELECTION     -1（没有选取,防止在工作表上进行任何选择操作）
 ProtectConstants.NO_RESTRICTIONS 0（允许选定任意单元格）
 ProtectConstants.UNLOCKED_CELLS  1（只选取未锁定单元格）
 </pre>
 <p>
 <b>例子: </b>
 <pre>
 //保护当前工作表,密码为"aa",并只选取未锁定单元格
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 ProtectProperties protectProperties = new ProtectProperties();
 protectProperties.setSelectionStyle(ProtectConstants.UNLOCKED_CELLS);
 boolean flag = worksheet.protect("aa", protectProperties);
 System.out.println(flag);
 </pre><DT><B>另请参见：</B><DD><A HREF="../../../../application/constants/ProtectConstants.html" title="application.constants 中的接口"><CODE>ProtectConstants</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/Names.html" title="application.workbooks.workbook.worksheets 中的类"><B>上一个类</B></A>&nbsp;
&nbsp;<A HREF="../../../../application/workbooks/workbook/worksheets/Scenario.html" title="application.workbooks.workbook.worksheets 中的类"><B>下一个类</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../index.html?application/workbooks/workbook/worksheets/ProtectProperties.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="ProtectProperties.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>