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.
Status: RESOLVED WORKSFORME
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-21 16:09 UTC by Jacek Bekier
Modified: 2015-05-01 20:57 UTC (History)
0 users



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

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
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.