|Summary:||Column outlines seem not to work in workbooks with multiple sheets.|
|Product:||POI||Reporter:||Jacek Bekier <jacek.bekier>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
File created in excel with desired output
File created by POI
Description Jacek Bekier 2005-04-21 16:09:42 UTC
Hello, I am creating a workbook with multiple (3) sheets. Each sheet contains column outlines created using HSSFSheet.groupColumn() method. Workbook is created succesfully, but when I open the file using Excel, the following message is displayed: "File error: data may have been lost." The spreadsheet content is OK and the outlines are shown. Additionaly, depending on the data in the file, one of the following, or both, occur: 1. Excel crashes after several seconds 2. An extra cell is added in the 1st column of the 1st or 2nd sheet with value =#N/A. Clicking on this cell sometimes causes Excel to crash. I have not been able to figure out the relation between the data in the spreedsheet and occurence of these errors, it seems to be random;) I have no problems with row outlines on multiple sheets. Thanks in advance, Jacek
Comment 1 Avik Sengupta 2005-04-22 13:18:00 UTC
Could you please attache to this bug 1. A file created by excel showing what you want to achive. 2. Simlar file, created by POI. That'll help debuggin. thanks.
Comment 2 Jacek Bekier 2005-04-22 14:41:20 UTC
Created attachment 14794 [details] File created in excel with desired output
Comment 3 Jacek Bekier 2005-04-22 14:44:35 UTC
Created attachment 14795 [details] File created by POI The only difference between the spreadsheets is the error message, shown when the file created by POI is opened in Excel.
Comment 4 Dominik Stadler 2014-07-22 17:03:24 UTC
If this is still an issue, please attach the code that produces the file via POI to let us see if it is fixed in the latest version.
Comment 5 Dominik Stadler 2015-05-01 20:57:07 UTC
No update for some time, closing this for now, please reopen with more information if this is still an issue.