Bug 34555

Summary: Column outlines seem not to work in workbooks with multiple sheets.
Product: POI Reporter: Jacek Bekier <jacek.bekier>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: 2.5-FINAL   
Target Milestone: ---   
Hardware: Other   
OS: Windows XP   
Attachments: File created in excel with desired output
File created by POI

Description Jacek Bekier 2005-04-21 16:09:42 UTC
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, 
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.