Package io.keikai.api

Class SheetProtection


  • public class SheetProtection
    extends Object
    SheetProtection values config.

    Using SheetProtection.Builder you can construct a SheetProtection object.

    Since:
    5.0.0
    Author:
    jumperchen
    • Method Detail

      • getPassword

        public String getPassword()
        Returns the password.
        Returns:
      • isObjectsEditable

        public boolean isObjectsEditable()
        Returns whether to protect objects.

        Default to true

        Returns:
      • isScenariosEditable

        public boolean isScenariosEditable()
        Returns whether to protect scenarios.

        Default to true

        Returns:
      • isFormatCellsAllowed

        public boolean isFormatCellsAllowed()
        Returns whether to allow user to format any cell on the protected sheet.

        Default to false

        Returns:
      • isFormatColumnsAllowed

        public boolean isFormatColumnsAllowed()
        Returns whether to allow user to format any columns on the protected sheet.

        Default to false

        Returns:
      • isFormatRowsAllowed

        public boolean isFormatRowsAllowed()
        Returns whether to allow user to format any rows on the protected sheet.

        Default to false

        Returns:
      • isInsertColumnsAllowed

        public boolean isInsertColumnsAllowed()
        Returns whether to allow user to insert columns on the protected sheet.

        Default to false

        Returns:
      • isInsertRowsAllowed

        public boolean isInsertRowsAllowed()
        Returns whether to allow user to insert rows on the protected sheet.

        Default to false

        Returns:
      • isInsertHyperlinksAllowed

        public boolean isInsertHyperlinksAllowed()
        Returns whether to allow user to insert hyperlinks on the protected sheet.

        Default to false

        Returns:
      • isDeleteColumnsAllowed

        public boolean isDeleteColumnsAllowed()
        Returns whether to allow user to delete columns on the protected sheet.

        Default to false

        Returns:
      • isDeleteRowsAllowed

        public boolean isDeleteRowsAllowed()
        Returns whether to allow user to delete rows on the protected sheet.

        Default to false

        Returns:
      • isSortAllowed

        public boolean isSortAllowed()
        Returns whether to allow user to sort on the protected sheet.

        Default to false

        Returns:
      • isAutoFilterAllowed

        public boolean isAutoFilterAllowed()
        Returns whether to allow user to set filters on the protected sheet.

        Default to false

        Returns:
      • isPivotTablesAllowed

        public boolean isPivotTablesAllowed()
        Returns whether to allow user to use pivot table reports on the protected sheet.

        Default to false

        Returns:
      • isSelectLockedCellsAllowed

        public boolean isSelectLockedCellsAllowed()
        Returns whether to allow select locked cells.

        Default to false

        Returns:
      • isSelectUnlockedCellsAllowed

        public boolean isSelectUnlockedCellsAllowed()
        Returns whether to allow select unlocked cells.

        Default to false

        Returns: