Hi, We are creating an XLS file using HSSF. When the file content exceeds a particular size, we are not able to open the file in MS Excel. The same file opens if a few records are reduced. The XLS file is created using a Java program. Also in the same file, when it is in the openable size, a specific cell style that I am applying repeatedly stops getting applied after some loops. Opening the file in MS Excel and applying the same gives a 'No more fonts may be applied in this workbook' error. We tried using 1.8.0 dev build and it still does not work. Any help will be appreciated. Thanks Anand
please try 2.0-pre3 - this sounds like the concurrency bug.
As mentioned by you we have used version 2.0-pre3. The same problem was coming with this version also. Later we changed our code to reduce the number of cellstyles and fonts applied to a worksheet. (The cellstyles and fonts are now applied to a couple of rows and rest of the worksheet uses default values.) After this change our code is working with version 2.0-pre3, but it is still not working with older version and is giving the error "Cannot open file" for large file size. Since the version 2.0-pre3 is not a released version we cannot use it in production. Can you please provide the equivalent released version which will solve our problem. Thanks
From the last report, it looks like the actual bug is solved. The poster's issue seems to be release nomenclature. So marking this bug fixed. Anand, trust your own unit tests more that what we call a release! In any case, 2.0 is coming soon!