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

Support Excel "Protect Sheet" allowed actions

    Details

      Description

      When clicking "Protect Sheet" in Excel, a pop-up will show up with a list of options indicating what actions are allowed in a protected sheet. ZSS should be able to understand this (keep the settings while importing the Excel) and, allow users to do the same settings in ZSS.

        Activity

        Hide
        henrichen henrichen added a comment - - edited
        Show
        henrichen henrichen added a comment - - edited in zpoi: Add EnhancedProtection record into zpoi. http://gitlab.potix.com:3000/zpoi/commit/4e3eba23083e22721cca25ed45ee38bc479718c9
        Hide
        henrichen henrichen added a comment - - edited

        in zpoi: implement HSSFSheetProtection, XSSFSheetProtection

        http://gitlab.potix.com:3000/zpoi/commit/063fde907c5734e9810a34eb2510168339ec5fb0

        Show
        henrichen henrichen added a comment - - edited in zpoi: implement HSSFSheetProtection, XSSFSheetProtection http://gitlab.potix.com:3000/zpoi/commit/063fde907c5734e9810a34eb2510168339ec5fb0
        Hide
        henrichen henrichen added a comment -

        1. Implement SSheetProtection
        2. Enhance importer, exporter…

        https://github.com/zkoss/zkspreadsheet/commit/a6d435678ba53cb7a0d55b48f3c2b4ada18e9c7c

        Show
        henrichen henrichen added a comment - 1. Implement SSheetProtection 2. Enhance importer, exporter… https://github.com/zkoss/zkspreadsheet/commit/a6d435678ba53cb7a0d55b48f3c2b4ada18e9c7c
        Hide
        henrichen henrichen added a comment - - edited

        1. Range.protectSheet(password, allowXxx, ...), Range.unprotectSheet(), Range.isSheetProtected(), Range.getSheetProtection()
        2. Check protection on action
        3. Test cases
        https://github.com/zkoss/zkspreadsheet/commit/6533867907c6ba4f7b8c033c19204cf84b93f766


        in zpoi: hashPassword(), getHashedPassword(), setHashedPassword(), CTXxx check isSetXxx before calling unsetXxx
        http://gitlab.potix.com:3000/zpoi/commit/b95e60230d7e1ebc91d044688da3407e2827886c


        in zsscml:
        1. Range.isProtected()
        2. Check protection on action
        https://github.com/zkoss/zsscml/commit/f706eb28b5f73e424581cee9eaef00149713fdda

        Show
        henrichen henrichen added a comment - - edited 1. Range.protectSheet(password, allowXxx, ...), Range.unprotectSheet(), Range.isSheetProtected(), Range.getSheetProtection() 2. Check protection on action 3. Test cases https://github.com/zkoss/zkspreadsheet/commit/6533867907c6ba4f7b8c033c19204cf84b93f766 — in zpoi: hashPassword(), getHashedPassword(), setHashedPassword(), CTXxx check isSetXxx before calling unsetXxx http://gitlab.potix.com:3000/zpoi/commit/b95e60230d7e1ebc91d044688da3407e2827886c — in zsscml: 1. Range.isProtected() 2. Check protection on action https://github.com/zkoss/zsscml/commit/f706eb28b5f73e424581cee9eaef00149713fdda
        Show
        henrichen henrichen added a comment - UI handled by Raymond https://github.com/zkoss/zkspreadsheet/commit/d4f3019aaebbbedc4554a590cb438ea562064152
        Hide
        henrichen henrichen added a comment -

        Done.

        Show
        henrichen henrichen added a comment - Done.
        Hide
        henrichen henrichen added a comment -

        neillee found some issue regarding options on "edit object". File a bug ZSS-679.

        Show
        henrichen henrichen added a comment - neillee found some issue regarding options on "edit object". File a bug ZSS-679 .
        Show
        henrichen henrichen added a comment - - edited Refix by Raymond (when book or sheet is null) https://github.com/zkoss/zkspreadsheet/commit/16f39efe36022fbadf81ee0dd910ff947d9a5809 https://github.com/zkoss/zsscml/commit/0aaf75b2f76a15b6c60f49cd7bd4f620ecf1f7b9
        Hide
        henrichen henrichen added a comment -

        Refix in Xls bit interpreted differently on sheet is protected or unprotected.
        3.5
        https://github.com/zkoss/zkspreadsheet/commit/ded4894d2175552cf6c7dbacefc8aa2753ceb7ac

        Show
        henrichen henrichen added a comment - Refix in Xls bit interpreted differently on sheet is protected or unprotected. 3.5 https://github.com/zkoss/zkspreadsheet/commit/ded4894d2175552cf6c7dbacefc8aa2753ceb7ac

          People

          • Assignee:
            Jenkins Jenkins
            Reporter:
            neillee neillee
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: