Too many form controls for HSSF

[Gareth Smith <po...@garethsmith.co.uk>]

Using the POI HSSF package, there appears to be a limit to the number of form
controls which can be used on a sheet. 
If a sheet which has too many form controls is run through POI then it cannot be
read by Excel any more, giving the error "Damage to the file was so extensive
that repairs were not possible.".

There is a bug for this submitted to bugzilla
(http://issues.apache.org/bugzilla/show_bug.cgi?id=39512), however there have
been no replies to this since it was posted a month and a half ago.

As with the reported bug, I have also found the number of controls which breaks
POI to be 60. There are example files to this effect within the bug report.

As I am trying to process forms using POI, having a limit on the number of form
controls is quite a major setback.

Thanks for any help,
Gareth


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/