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

Cannot upload a file with a print area

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.8.0
    • 3.7.0
    • None
    • Security Level: Jimmy

      Steps to Reproduce

      1. run zsseeapp 3.7.0
      2. upload attached file

      Actual Result

      java.lang.NullPointerException
              at org.zkoss.poi.ss.formula.FormulaParser.createPtgForNonExistedName(FormulaParser.java:734)
              at org.zkoss.poi.ss.formula.FormulaParser.parseNameName(FormulaParser.java:684)
              at org.zkoss.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:490)
              at org.zkoss.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:328)
              at org.zkoss.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1282)
              at org.zkoss.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1242)
              at org.zkoss.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1229)
              at org.zkoss.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1584)
              at org.zkoss.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1684)
              at org.zkoss.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1668)
              at org.zkoss.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1625)
              at org.zkoss.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1605)
              at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1726)
              at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:229)
              at org.zkoss.poi.hssf.model.HSSFFormulaParser.parse(HSSFFormulaParser.java:72)
              at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.setPrintArea(HSSFWorkbook.java:1402)
              at org.zkoss.zss.range.impl.imexp.AbstractExcelExporter.exportSheet(AbstractExcelExporter.java:269)
              at org.zkoss.zss.range.impl.imexp.AbstractExcelExporter.export(AbstractExcelExporter.java:111)
              at org.zkoss.zss.api.impl.ExporterImpl.export(ExporterImpl.java:49)
              at org.zkoss.zss.app.repository.impl.SimpleRepository.save(SimpleRepository.java:84)
              at org.zkoss.zss.app.repository.impl.SimpleRepository.saveAs(SimpleRepository.java:117)
              at org.zkoss.zss.app.ui.dlg.OpenManageBookCtrl$2.onEvent(OpenManageBookCtrl.java:199)
              at org.zkoss.zss.app.ui.dlg.OpenManageBookCtrl$2.onEvent(OpenManageBookCtrl.java:181)
              at org.zkoss.zul.impl.FileuploadDlg.onClose(FileuploadDlg.java:61)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
      

      Debug Information

      print area is a string like Sheet1!A:K

            henrichen henrichen
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: