Package ch.rabanti.nanoxlsx4j

Enum Class Worksheet.SheetProtectionValue

java.lang.Object

java.lang.Enum<Worksheet.SheetProtectionValue>

ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

All Implemented Interfaces:

Serializable, Comparable<Worksheet.SheetProtectionValue>, Constable

Enclosing class:

Worksheet

public static enum Worksheet.SheetProtectionValue
extends Enum<Worksheet.SheetProtectionValue>

Enum to define the possible protection types when protecting a worksheet

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
autoFilter	If selected, the user can use auto filters if the worksheets is protected
deleteColumns	If selected, the user can delete columns if the worksheets is protected
deleteRows	If selected, the user can delete rows if the worksheets is protected
formatCells	If selected, the user can format cells if the worksheets is protected
formatColumns	If selected, the user can format columns if the worksheets is protected
formatRows	If selected, the user can format rows if the worksheets is protected
insertColumns	If selected, the user can insert columns if the worksheets is protected
insertHyperlinks	If selected, the user can insert hyperlinks if the worksheets is protected
insertRows	If selected, the user can insert rows if the worksheets is protected
objects	If selected, the user can edit objects if the worksheets is protected
pivotTables	If selected, the user can use pivot tables if the worksheets is protected
scenarios	If selected, the user can edit scenarios if the worksheets is protected
selectLockedCells	If selected, the user can select locked cells if the worksheets is protected
selectUnlockedCells	If selected, the user can select unlocked cells if the worksheets is protected
sort	If selected, the user can sort cells if the worksheets is protected

Method Summary

Modifier and Type	Method	Description
static Worksheet.SheetProtectionValue	valueOf(String name)	Returns the enum constant of this class with the specified name.
static Worksheet.SheetProtectionValue[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

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 Details

values

public static Worksheet.SheetProtectionValue[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static Worksheet.SheetProtectionValue valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (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 class has no constant with the specified name

NullPointerException - if the argument is null