You mean it used to work properly with 1.10?? Thats bad! It would be helpful if you could try out with latest CVS. Dont *move* yet, but it would be helpful for debugging if you try out your code with it.
Can you send accross the two sheets that you generated? If not, you'll need to debug it yourself. First thing to do is run both files thru BiffViewer. Then check for differences in the two outputs. That'll give you an idea of whats different between 1.10 and 2.0pre3. HTH - Avik -------Original Message------- > From: Singh, Arshi (Indsys) <[EMAIL PROTECTED]> > Subject: RE: HSSF Workbook not opening in MS Excel > Sent: 07 Oct 2003 19:58:57 > > Hi, > I have recently moved to poi-2.0-pre3 release. Earlier i was using poi 10.0. Should I be moving to a newer version now ? > > The data is "exactly" the same. I am using the same input files for generating the excel reports. The input file contains the strings that form data for cells. > > One more observation is that, if I reduce the number of sheets to say 20, then i am able to open the workbook in MS Excel , but if its a little higher around 27, then it does not open. So i guess the reason could be what you suggested. > > Arshi. > > -----Original Message----- > From: Avik Sengupta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 07, 2003 8:15 PM > To: POI Users List; Poi-User (E-mail) > Subject: Re: HSSF Workbook not opening in MS Excel > > > Which version are you using? There was a bug wherein the file would get > corrupted if more than a particular number of unique strings were there > in the sheet. This bug has been fixed in current CVS, if you want to try > that out. > > Or it could be a similar but different bug.. in which case its down to > reading hex dumps again :( > > You say its the same data ... are you sure its *exactly* the same data? > If it is, then its a big bug... I dont think it would be memory issue > while generating.. not if you are able to consistently replicate the > error. > > Regards > - > Avik > > > -------Original Message------- > > From: Singh, Arshi (Indsys) > > Subject: HSSF Workbook not opening in MS Excel > > Sent: 07 Oct 2003 13:26:44 > > > > Hi All, > > > > I am creating a workbook with 27 tabs (sheets), using poi, > hssf. > > > > I had successfully done it earlier and opened that workbook in > MSExcel. Now due to some mysterious reason when i create a workbook for > the same data, it does not open in MSExcel. The size of workbook is also > slightly more...575 kb (earlier 566 kb). > > > > I fail to understand the reason for this. If i try to open the > workbook that i had generated earlier, it opens perfectly with 27 tabs. > But this new workbook having same data fails to open. It just flashes > the MSExcel with no document on it. > > > > Could this be due to some memory problem while generating the > workbook repeatedly. Kindly help me to detect the problem. I did not > make any changes in code since then, but all of a sudden this problem > starting coming. > > > > Regards, > > Arshi > > g GE Industrial Systems > > ________________________________________ > > > > Arshi Singh > > GE-IBC, Datawarehousing > > GE Industrial Systems > > Center Point, HUDA Lane > > Begumpet, Secunderabad 500 003 > > > > email: [EMAIL PROTECTED] > > Tel: 91-40-27881480 (D), 1800 > -------Original Message------- > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -------Original Message-------
