Hello Josh, Thank you for your answer. I was not very exhaustive in my last e-mail. Let me attach a few more files. Just for info, I'm using Excel 2003, I don't have Excel 2007, that's why I'm using HSSF. I also tried with 3.5b3 (since I didn't find 3.5b4)
Here is the model Excel file that I want to modify (generated with Excel 2003) : http://www.nabble.com/file/p20715514/EssaiModifExcelSource.xls EssaiModifExcelSource.xls Here is the modified Excel file with POI 2.5.1-FINAL (working ok with Excel 2003) : http://www.nabble.com/file/p20715514/EssaiModifExcelDestination251.xls EssaiModifExcelDestination251.xls Here is the modified Excel file with POI 3.1-FINAL (not working with Excel 2003) : http://www.nabble.com/file/p20715514/EssaiModifExcelDestination31.xls EssaiModifExcelDestination31.xls Here is the modified Excel file with POI 3.5b3 (working with Excel 2003) : http://www.nabble.com/file/p20715514/EssaiModifExcelDestination35b3.xls EssaiModifExcelDestination35b3.xls So you were right, there was a bug on 3.1 which is corrected on 3.5b3. So for now, I suppose I'll have to stay on version 2.5.1 on our production server. We are a big factory and no beta version can be used on production environment. So I'll be waiting for version 3.5 final, I guess. Thanks a lot for your help. Best regards, Michel Wozniak Josh Micich wrote: > > Hello Michael, > > In my Excel (2007) your input file opens without any error or warning > message, but the chart/rows/columns of the first sheet ('Vue') is/are > not visible. I guess this is unexpected in the *input* since you wrote > (about the output): "but the sheet with the graph (which I don't even > touch in Java) is void". > The POI code you supplied runs on the latest svn trunk without error, > and the output file also opens in Excel without error message. Again, > the first sheet content is not visible. > > So it may be the case that you are seeing a bug that was fixed since > version 3.1, but it's hard to tell when I can't see the content of the > first sheet. Do you know how this input file was produced? > > If you still experience problems with the latest version (3.5-beta4), > please upload your copy of EssaiModifExcelOut.xls as produced by your > POI 2.5.1 version, so we can do a BiffViewer comparison to understand > the differences in behaviour. > > regards, > Josh > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/XLS-modification-problem-tp20701753p20715514.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
