I'm using the 3.5 beta to read a 2007 excel workbook.
In my sheet, I created a cell (F2) that had a simple formula : =C2*D2
In my code, it realizes this is a formula and evaluates properly.
In excel, I dragged the formula down so that F3:F380 had the same
effective formula as F2 (C3*D3, etc).
When F3 is evaluated, it works ok, but when F4 is evaluated, it bombs with
the stack trace below.
If I enter the formula manually it works ok, but when I drag the formula
down, it keeps doing that. Is this functionality supported? Do you have
to evaluate the cell differently?
-Jeff
org.apache.poi.hssf.model.FormulaParser$FormulaParseException: Parse error
near char 0 '
at
org.apache.poi.hssf.model.FormulaParser.expected(FormulaParser.java:142)
at
org.apache.poi.hssf.model.FormulaParser.parseNumber(FormulaParser.java:570)
at
org.apache.poi.hssf.model.FormulaParser.parseSimpleFactor(FormulaParser.java:537)
at
org.apache.poi.hssf.model.FormulaParser.percentFactor(FormulaParser.java:499)
at
org.apache.poi.hssf.model.FormulaParser.powerFactor(FormulaParser.java:486)
at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:694)
at
org.apache.poi.hssf.model.FormulaParser.additiveExpression(FormulaParser.java:775)
at
org.apache.poi.hssf.model.FormulaParser.concatExpression(FormulaParser.java:759)
at
org.apache.poi.hssf.model.FormulaParser.comparisonExpression(FormulaParser.java:716)
at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:817)
at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:116)
at
org.apache.poi.ss.usermodel.FormulaEvaluator.evaluateCell(FormulaEvaluator.java:333)
at
org.apache.poi.ss.usermodel.FormulaEvaluator.internalEvaluate(FormulaEvaluator.java:326)
at
org.apache.poi.ss.usermodel.FormulaEvaluator.evaluate(FormulaEvaluator.java:133)
at
com.dteco.pmp.ExcelSheetReader.getStringValue(ExcelSheetReader.java:235)
at
com.dteco.pmp.ExcelSheetReader.readCells(ExcelSheetReader.java:202)
at
com.dteco.pmp.ExcelSheetReader.collectData(ExcelSheetReader.java:191)
at
com.dteco.pmp.ExcelSheetReader.getTabularData(ExcelSheetReader.java:116)
at
com.dteco.pmp.ZReportExtractor.loadEmpStocksMap(ZReportExtractor.java:229)
at
com.dteco.pmp.ZReportExtractor.reportExtract(ZReportExtractor.java:157)
at
com.dteco.pmp.SuccessFactorsRunner.main(SuccessFactorsRunner.java:27)
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:585)
at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
*** PROPRIETARY, CONFIDENTIAL OR PRIVILEGED COMMUNICATION ***
This communication may contain proprietary, privileged or confidential
information protected by law. It is solely for the use of the intended
recipient named above. Any review, dissemination, distribution,
forwarding, or copying of this communication by someone other than the
intended recipient, or the employee responsible for delivering this
communication to the intended recipient, is prohibited. If you have
received this communication in error, please immediately notify the sender
via email, then destroy the original message.
