Package ch.rabanti.picoxlsx4j
Enum Worksheet.SheetProtectionValue
- java.lang.Object
-
- java.lang.Enum<Worksheet.SheetProtectionValue>
-
- ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue
-
- All Implemented Interfaces:
Serializable
,Comparable<Worksheet.SheetProtectionValue>
- Enclosing class:
- Worksheet
public static enum Worksheet.SheetProtectionValue extends Enum<Worksheet.SheetProtectionValue>
Enum to define the possible protection types when protecting a worksheet
-
-
Enum Constant Summary
Enum Constants Enum Constant Description autoFilter
If selected, the user can use auto filters if the worksheets is protecteddeleteColumns
If selected, the user can delete columns if the worksheets is protecteddeleteRows
If selected, the user can delete rows if the worksheets is protectedformatCells
If selected, the user can format cells if the worksheets is protectedformatColumns
If selected, the user can format columns if the worksheets is protectedformatRows
If selected, the user can format rows if the worksheets is protectedinsertColumns
If selected, the user can insert columns if the worksheets is protectedinsertHyperlinks
If selected, the user can insert hyperlinks if the worksheets is protectedinsertRows
If selected, the user can insert rows if the worksheets is protectedobjects
If selected, the user can edit objects if the worksheets is protectedpivotTables
If selected, the user can use pivot tables if the worksheets is protectedscenarios
If selected, the user can edit scenarios if the worksheets is protectedselectLockedCells
If selected, the user can select locked cells if the worksheets is protectedselectUnlockedCells
If selected, the user can select unlocked cells if the worksheets is protectedsort
If selected, the user can sort cells if the worksheets is protected
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static Worksheet.SheetProtectionValue
valueOf(String name)
Returns the enum constant of this type with the specified name.static Worksheet.SheetProtectionValue[]
values()
Returns an array containing the constants of this enum type, in the order they are declared.
-
-
-
Enum Constant Detail
-
objects
public static final Worksheet.SheetProtectionValue objects
If selected, the user can edit objects if the worksheets is protected
-
scenarios
public static final Worksheet.SheetProtectionValue scenarios
If selected, the user can edit scenarios if the worksheets is protected
-
formatCells
public static final Worksheet.SheetProtectionValue formatCells
If selected, the user can format cells if the worksheets is protected
-
formatColumns
public static final Worksheet.SheetProtectionValue formatColumns
If selected, the user can format columns if the worksheets is protected
-
formatRows
public static final Worksheet.SheetProtectionValue formatRows
If selected, the user can format rows if the worksheets is protected
-
insertColumns
public static final Worksheet.SheetProtectionValue insertColumns
If selected, the user can insert columns if the worksheets is protected
-
insertRows
public static final Worksheet.SheetProtectionValue insertRows
If selected, the user can insert rows if the worksheets is protected
-
insertHyperlinks
public static final Worksheet.SheetProtectionValue insertHyperlinks
If selected, the user can insert hyperlinks if the worksheets is protected
-
deleteColumns
public static final Worksheet.SheetProtectionValue deleteColumns
If selected, the user can delete columns if the worksheets is protected
-
deleteRows
public static final Worksheet.SheetProtectionValue deleteRows
If selected, the user can delete rows if the worksheets is protected
-
selectLockedCells
public static final Worksheet.SheetProtectionValue selectLockedCells
If selected, the user can select locked cells if the worksheets is protected
-
sort
public static final Worksheet.SheetProtectionValue sort
If selected, the user can sort cells if the worksheets is protected
-
autoFilter
public static final Worksheet.SheetProtectionValue autoFilter
If selected, the user can use auto filters if the worksheets is protected
-
pivotTables
public static final Worksheet.SheetProtectionValue pivotTables
If selected, the user can use pivot tables if the worksheets is protected
-
selectUnlockedCells
public static final Worksheet.SheetProtectionValue selectUnlockedCells
If selected, the user can select unlocked cells if the worksheets is protected
-
-
Method Detail
-
values
public static Worksheet.SheetProtectionValue[] values()
Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:for (Worksheet.SheetProtectionValue c : Worksheet.SheetProtectionValue.values()) System.out.println(c);
- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
public static Worksheet.SheetProtectionValue valueOf(String name)
Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)- Parameters:
name
- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException
- if this enum type has no constant with the specified nameNullPointerException
- if the argument is null
-
-