"Protect Sheet" doesn't prevents cells from using auto filter

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.0.0
    • Affects Version/s: 3.0.0 RC
    • Component/s: ZSS Component
    • None

      Problem Description:

      According to Excel 2007's default behavior, "protect Sheet" could allow users to use auto filter, but it's not default setting. Spreadsheet allows users to auto filter.

      Reproducing Steps:

      1. display an Excel 2007 file
      2. enable a filter.
      3. click "Protect Sheet" on the tool-bar
      4. click drop-down list to change auto filter's setting

      Expected:
      drop-down list is not displayed when clicking it. (Like Excel)

      Actual:
      Some rows visibility is changed by auto filter.

            Assignee:
            hawk
            Reporter:
            hawk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: