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

protectSheet error after 3.8.3 update

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 3.8.3
    • ZSS Component
    • None

      Problem occurs when trying to protect a sheet after formatting some cells:

      Works perfectly with 3.8.0.1

      Ranges.range(sheet).protectSheet("plan1",
      true, true, false, false, false, false, false,
      false, false, false, false, false, false, false, false);
      8
      then:

      ERROR [org.zkoss.zk.ui.impl.UiEngineImpl] (http-localhost/127.0.0.1:8080-3) : java.lang.NoSuchMethodError: org.apache.commons.codec.binary.Base64.encodeAsString([B)Ljava/lang/String;
      at org.zkoss.poi.ss.util.SheetUtil.base64Random16Bytes(SheetUtil.java:305) [zpoi-3.9.10.jar:3.9.10]
      at org.zkoss.zss.model.impl.SheetImpl.setPassword(SheetImpl.java:1768) [zssmodel-3.8.3.jar:3.8.3]
      at org.zkoss.zss.range.impl.RangeImpl.setPasswordInLock(RangeImpl.java:2188) [zssmodel-3.8.3.jar:3.8.3]
      at org.zkoss.zss.range.impl.RangeImpl.protectSheetInLock(RangeImpl.java:2151) [zssmodel-3.8.3.jar:3.8.3]
      at org.zkoss.zss.range.impl.RangeImpl.access$3000(RangeImpl.java:107) [zssmodel-3.8.3.jar:3.8.3]
      at org.zkoss.zss.range.impl.RangeImpl$59.invoke(RangeImpl.java:2082) [zssmodel-3.8.3.jar:3.8.3]
      at org.zkoss.zss.model.util.ReadWriteTask.doInWriteLock(ReadWriteTask.java:43) [zssmodel-3.8.3.jar:3.8.3]
      at org.zkoss.zss.range.impl.RangeImpl.protectSheet(RangeImpl.java:2091) [zssmodel-3.8.3.jar:3.8.3]
      at org.zkoss.zss.api.impl.RangeImpl.protectSheet(RangeImpl.java:763) [zss-3.8.3.jar:3.8.3]
      at br.jus.tse.corporativo.sigepro.excel.web.jsf.mbeans.UoBookBean.conditionalFormatting(UoBookBean.java:339) [classes:]
      at br.jus.tse.corporativo.sigepro.excel.web.jsf.mbeans.UoBookBean.onAfterCellChange(UoBookBean.java:105) [classes:]

            Unassigned Unassigned
            LeonardoRosa LeonardoRosa
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: