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>
Status: RESOLVED WORKSFORME    
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 
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.