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

Importing a chart with a FormulaParseException

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Later Later
    • 3.8.3
    • 3.8.1
    • None
    • Security Level: Jimmy
    • None

      Steps to reproduce

      1. load the attached file

      actual result

      INFO: The specified formula '' contains an error. Expects cell reference or constant literal. when parsing at [t2262.xls]Sheet1!null
      org.zkoss.poi.ss.formula.FormulaParseException: The specified formula '' contains an error. Expects cell reference or constant literal.
      at org.zkoss.poi.ss.formula.FormulaParser.expected(FormulaParser.java:1978)
      at org.zkoss.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1512)
      at org.zkoss.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1467)
      at org.zkoss.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1454)
      at org.zkoss.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1809)
      at org.zkoss.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1909)
      at org.zkoss.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1893)
      at org.zkoss.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1850)
      at org.zkoss.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1830)
      at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1951)
      at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:299)
      at org.zkoss.zssex.formula.FormulaEngineEx.parse(FormulaEngineEx.java:81)
      at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.parse0(FormulaEngineImpl.java:204)
      at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.parse(FormulaEngineImpl.java:177)
      at org.zkoss.zss.model.impl.chart.GeneralChartDataImpl.setCategoriesFormula(GeneralChartDataImpl.java:140)
      at org.zkoss.zss.range.impl.imexp.ExcelXlsImporter.importSeries(ExcelXlsImporter.java:287)
      at org.zkoss.zss.range.impl.imexp.ExcelXlsImporter.importChart(ExcelXlsImporter.java:114)
      at org.zkoss.zss.range.impl.imexp.ExcelXlsImporter.importDrawings(ExcelXlsImporter.java:220)
      at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:162)
      at org.zkoss.zss.range.impl.imexp.ExcelImportAdapter.imports(ExcelImportAdapter.java:46)
      at org.zkoss.zss.range.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54)
      at org.zkoss.zss.ui.Spreadsheet.getSBook(Spreadsheet.java:647)
      at org.zkoss.zss.ui.Spreadsheet.getSelectedSSheet(Spreadsheet.java:845)
      at org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4668)
      at org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:4007)
      at org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:885)

      debug info

      • zss still can display the chart

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

              Created:
              Updated:
              Resolved: