Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Worksheet Protection

  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Table Name
    Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
 
Options


The ASP.NET MVC Spreadsheet supports workbook and worksheet element protection defined within a document. If the document contains protected elements, the Spreadsheet prevents their modification by your end-users.

Note: The Formula Bar that displays focused cell content allows end-users to view formulas contained within the protected cells.

In this demo, the Spreadsheet opens a document with the applied worksheet password protection that prevents modification of certain cells. In particular, you can modify only cells belonging to rows from 6 to 22 and columns from D to J - these cells are colored with different shades of green. Using Spreadsheet API, you can allow or disallow end-users to format, insert, delete, sort, filter or edit areas of the protected worksheet. The Protect and Unprotect methods of a worksheet object are used in the demo for this purpose. According to the defined permissions, the Spreadsheet UI prevents end-users from modifying protected elements - ribbon items and context menu items that relate to customization of these elements are either disabled or not in effect.

From a usability standpoint, document protection allows you to hide data or formulas that might confuse end-users and prevent users from viewing or making changes to such data.


See Also: