Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: [Bug 60924] New: Excel 2016 SWITCH Statement Not Supported
Date: Mon, 27 Mar 2017 17:24:26 +0000
Message-ID: <bug-60924-47293@https.bz.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Auto-Submitted: auto-generated
MIME-Version: 1.0
archived-at: Mon, 27 Mar 2017 17:24:32 -0000

https://bz.apache.org/bugzilla/show_bug.cgi?id=3D60924

            Bug ID: 60924
           Summary: Excel 2016 SWITCH Statement Not Supported
           Product: POI
           Version: unspecified
          Hardware: PC
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: barnes41@llnl.gov
  Target Milestone: ---

Version: First seen with 3.10-FINAL, however skimming the code it appears to
still be a problem in 3.15-FINAL.

Excel 2016 added a new SWITCH statement, and likely others.  Running
evaluateAll() on the workbook results in the following stack trace.

org.apache.poi.ss.formula.FormulaParseException: Name '_xlfn.SWITCH' is
completely unknown in the current workbook
        at
org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:920)
        at
org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:55=
8)
        at
org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:4=
29)
        at
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.=
java:268)
        at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.jav=
a:1119)
        at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:10=
79)
        at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1066)
        at
org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1426)
        at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.ja=
va:1526)
        at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java=
:1510)
        at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.=
java:1467)
        at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:=
1447)
        at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1568)
        at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:176)
        at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFE=
valuationWorkbook.java:148)
        at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.j=
ava:286)
        at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java=
:230)
        at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue=
(XSSFFormulaEvaluator.java:264)
        at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSF=
FormulaEvaluator.java:151)
        at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(=
HSSFFormulaEvaluator.java:324)
        at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(=
HSSFFormulaEvaluator.java:315)
        at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAll(XSSFFormulaE=
valuator.java:252)

For anyone seeing this bug and looking for a workaround, follow the
instructions at http://poi.apache.org/spreadsheet/user-defined-functions.ht=
ml
to implement a custom function with the name '_xlfn.SWITCH'.

--=20
You are receiving this mail because:
You are the assignee for the bug.=

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org