Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-679

Edit objects option in sheet protection is inconsistent when save to excel

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.5.0 RC
    • Fix Version/s: 3.5.0
    • Component/s: None
    • Labels:
      None

      Description

      The sheet protection format in excel when in protection should be as below:

      <!--
      	Protection: true
      	Edit objects: false
      -->
      <sheetProtection sheet="1" objects="1"/>
      
      <!--
      	Protection: true
      	Edit objects: true
      -->
      <sheetProtection sheet="1"/>
      

      When unprotected sheet, no matter "Edit objects" option is allowed or not, it will eventually became false:

      <!--
      	Protection: false
      	Edit objects: true/false
      -->
      ( none )
      
      

        Activity

        Hide
        henrichen henrichen added a comment -

        Fixed.

        Show
        henrichen henrichen added a comment - Fixed.
        Show
        henrichen henrichen added a comment - https://github.com/zkoss/zkspreadsheet/commit/95d1a1c312d9b9152abc9c56c894648a102fb129 http://gitlab.potix.com:3000/zpoi/commit/2c367d51cba68f2adb2ca2a084a2c8fd0d29479f
        Hide
        henrichen henrichen added a comment - - edited
        • sheet protected:
          • selectLockedCells: NA or false -> checked; true -> unchecked
          • selectUnlockedCells: NA or false -> checked; true -> unchecked
          • scenarios: NA or false -> checked; true -> unchecked
          • objects: NA or false -> checked; true -> unchecked
          • other Xxx: false -> checked; NA or true -> unchecked
        • sheet unprotected:
          • selectLockedCells: NA or false -> checked; true -> unchecked
          • selectUnlockedCells: NA or false -> checked; true -> unchecked
          • scenarios: NA, true, or false -> unchecked
          • objects: NA, true, or false -> unchecked
          • other Xxx: false -> checked; NA or true -> unchecked
        Show
        henrichen henrichen added a comment - - edited sheet protected: selectLockedCells: NA or false -> checked; true -> unchecked selectUnlockedCells: NA or false -> checked; true -> unchecked scenarios: NA or false -> checked; true -> unchecked objects: NA or false -> checked; true -> unchecked other Xxx: false -> checked; NA or true -> unchecked sheet unprotected: selectLockedCells: NA or false -> checked; true -> unchecked selectUnlockedCells: NA or false -> checked; true -> unchecked scenarios: NA, true, or false -> unchecked objects: NA, true, or false -> unchecked other Xxx: false -> checked; NA or true -> unchecked

          People

          • Assignee:
            dennis dennis
            Reporter:
            RaymondChao RaymondChao
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: