Bug 47620 - XSSFWorkbook.setRepeatingRowsAndColumns causes FormulaParseException
Summary: XSSFWorkbook.setRepeatingRowsAndColumns causes FormulaParseException
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Mac OS X 10.4
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2009-08-01 18:09 UTC by David Agnew
Modified: 2009-08-05 10:55 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description David Agnew 2009-08-01 18:09:04 UTC
XSSFWorkbook.setRepeatingRowsAndColumns gets a FormulaParseException below a call to XSSFName.setRefersToFormula at line 934 when one attempts to specify no repeating columns by setting the first and last repeating column to -1. Setting the first and last repeating row to -1 does not cause an exception if at least repeating column is specified.

Workaround: Set a large unused column number for first and last repeating column (e.g., 255). Then it works without throwing an exception.
Comment 1 Yegor Kozlov 2009-08-05 10:55:29 UTC
Fixed in 801339