poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 黄鑫 <soddy...@gmail.com>
Subject the CellReference didn't support column select ? like "$A:$A"
Date Tue, 23 Apr 2013 11:33:37 GMT
I found this error in my excel files.
It was formula like

=INDIRECT("'Sheet1'!$A:$A")

When I debug this , I found POI wanted to use Integer.parseInt to parse
"$A:$A" to column string in the CellReference.classifyCellReference.
But it's a letter "A".
And I find the Row ref process are support this case because that call
CellReference.convertColStringToIndex instead of Integer.parseInt.

-- 
thanks!.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message