Bug 47620

Summary: XSSFWorkbook.setRepeatingRowsAndColumns causes FormulaParseException
Product: POI Reporter: David Agnew <prescindor>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.5-dev   
Target Milestone: ---   
Hardware: PC   
OS: Mac OS X 10.4   

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

Yegor