Bug 62619 - Cell Style and format is Lost for Excel in Latter versions of Ms office 2010
Summary: Cell Style and format is Lost for Excel in Latter versions of Ms office 2010
Status: NEEDINFO
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P1 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-13 07:39 UTC by Praveen Madduri
Modified: 2018-12-22 17:35 UTC (History)
0 users



Attachments
ScreenShot of output files for 2010 & 2016 versions (554.00 KB, application/msword)
2018-08-13 07:39 UTC, Praveen Madduri
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Praveen Madduri 2018-08-13 07:39:37 UTC
Created attachment 36088 [details]
ScreenShot of output files for 2010 & 2016 versions

I am trying to export excel from POI, output Excel file contains 100 Rows and 8 columns. i have observed a drastaic change in the output while opening the file in MS office 2010 and 2016 versions.

Cell style and format is parilally lost in first sheet and in Latter sheet complete cell style and format is lost. AFrom my primary invetsigation i found this issue Lies in POI code.  Kindly Suggest me to fix this bug.
 
 Please find attached the Screen shots of the Output file in both the versions
Comment 1 Dominik Stadler 2018-12-22 17:35:08 UTC
Please also provide some code which produces the file in Apache POI.