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
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.
Created attachment 14794 [details] File created in excel with desired output
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.
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.
No update for some time, closing this for now, please reopen with more information if this is still an issue.