https://issues.apache.org/bugzilla/show_bug.cgi?id=46806
Summary: Unable to Create XSSF Workbook with formula that
references column > 255
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Creating an XSSF Workbook with a cell formula that references a cell in a
column that is greater than 255 causes an exception.
In org.apache.poi.ss.util.CellReference there is the constant:
private static final String BIFF8_LAST_COLUMN = "IV";
Should be some kind of switch depending on if the workbook is HSSF or XSSF to
allow for references in columns > 255.
java.lang.IllegalArgumentException: Unparsable formula 'SUM(F4:IW4)'
at org.apache.poi.xssf.usermodel.XSSFCell.setCellFormula(XSSFCell.java:384)
at
org.vbn.hours.logic.ExcelReporter.exportTPDPlannedHoursReport(ExcelReporter.java:2751)
at org.vbn.hours.logic.ExcelReporter.runReport(ExcelReporter.java:70)
at
org.vbn.hours.logic.VBNHoursController$1.doInBackground(VBNHoursController.java:61)
at
org.vbn.hours.logic.VBNHoursController$1.doInBackground(VBNHoursController.java:1)
at javax.swing.SwingWorker$1.call(SwingWorker.java:278)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at javax.swing.SwingWorker.run(SwingWorker.java:317)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.poi.ss.formula.FormulaParser$FormulaParseException:
Specified named range 'IW4' does not exist in the current workbook.
at
org.apache.poi.ss.formula.FormulaParser.parseNameOrCellRef(FormulaParser.java:440)
at
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:340)
at
org.apache.poi.ss.formula.FormulaParser.parseFunctionReferenceOrName(FormulaParser.java:332)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:733)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:693)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:680)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:982)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1083)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1067)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1024)
at
org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:665)
at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:562)
at
org.apache.poi.ss.formula.FormulaParser.parseFunctionReferenceOrName(FormulaParser.java:324)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:733)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:693)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:680)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:982)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1083)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1067)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1024)
at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1003)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1125)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:192)
at org.apache.poi.xssf.usermodel.XSSFCell.setCellFormula(XSSFCell.java:381)
... 11 more
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
