sheetprotectiontype-ag凯发旗舰厅

overview

package

class

tree

deprecated

index

help

prev class next class

frames no frames

summary: nested | enum constants | field | method

detail: enum constants | field | method

com.spire.xls
enum sheetprotectiontype

java.lang.object
  java.lang.enum<sheetprotectiontype>
      com.spire.xls.sheetprotectiontype

all implemented interfaces:: java.lang.comparable<sheetprotectiontype>

public enum sheetprotectiontype
extends java.lang.enum<sheetprotectiontype>
extends java.lang.enum<sheetprotectiontype>

represents sheet protection flags enums.

enum constant summary
`all` allows the user to do any thing on a protected worksheet.
`content` represents all flags
`deletingcolumns` true allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked.
`deletingrows` true allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked.
`filtering` true allows the user to set filters on the protected worksheet.
`formattingcells` true allows the user to format any cell on a protected worksheet.
`formattingcolumns` true allows the user to format any column on a protected worksheet.
`formattingrows` true allows the user to format any row on a protected.
`insertingcolumns` true allows the user to insert columns on the protected worksheet.
`insertinghyperlinks` true allows the user to insert hyperlinks on the worksheet.
`insertingrows` true allows the user to insert rows on the protected worksheet.
`lockedcells` true allows the user to select locked cells on the protected worksheet.
`none` not allows the user to do any thing on a protected worksheet.
`objects` true to protect shapes.
`scenarios` true to protect scenarios.
`sorting` true allows the user to sort on the protected worksheet.
`unlockedcells` true allows the user to select locked cells on the protected worksheet.
`usingpivottables` true allows the user to use pivot table reports on the protected worksheet.

enum constant detail

none

public static final sheetprotectiontype none

not allows the user to do any thing on a protected worksheet.

objects

public static final sheetprotectiontype objects

true to protect shapes.

scenarios

public static final sheetprotectiontype scenarios

true to protect scenarios.

formattingcells

public static final sheetprotectiontype formattingcells

true allows the user to format any cell on a protected worksheet.

formattingcolumns

public static final sheetprotectiontype formattingcolumns

true allows the user to format any column on a protected worksheet.

formattingrows

public static final sheetprotectiontype formattingrows

true allows the user to format any row on a protected.

insertingcolumns

public static final sheetprotectiontype insertingcolumns

true allows the user to insert columns on the protected worksheet.

insertingrows

public static final sheetprotectiontype insertingrows

true allows the user to insert rows on the protected worksheet.

insertinghyperlinks

public static final sheetprotectiontype insertinghyperlinks

true allows the user to insert hyperlinks on the worksheet.

deletingcolumns

public static final sheetprotectiontype deletingcolumns

true allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked.

deletingrows

public static final sheetprotectiontype deletingrows

true allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked.

lockedcells

public static final sheetprotectiontype lockedcells

true allows the user to select locked cells on the protected worksheet.

sorting

public static final sheetprotectiontype sorting

true allows the user to sort on the protected worksheet.

filtering

public static final sheetprotectiontype filtering

true allows the user to set filters on the protected worksheet. users can change filter criteria but can not enable or disable an auto filter.

usingpivottables

public static final sheetprotectiontype usingpivottables

true allows the user to use pivot table reports on the protected worksheet.

unlockedcells

public static final sheetprotectiontype unlockedcells