Bug 34555 - Column outlines seem not to work in workbooks with multiple sheets.
Summary: Column outlines seem not to work in workbooks with multiple sheets.
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.5-FINAL
Hardware: Other Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2005-04-21 16:09 UTC by Jacek Bekier
Modified: 2015-05-01 20:57 UTC (History)
0 users

File created in excel with desired output (24.00 KB, application/vnd.ms-excel)
2005-04-22 14:41 UTC, Jacek Bekier
File created by POI (25.50 KB, application/vnd.ms-excel)
2005-04-22 14:44 UTC, Jacek Bekier

Note You need to log in before you can comment on or make changes to this bug.
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.