Thanks for the details.
As mentioned we have attached the sample java code and the resultant excel created from our local server and sub prod environment and also their respective pdf files.
In the sample code, we have passed the excel which is having issue as input and tried to auto fit it and saved it. TestFileBefore1481971124205.xls --> TEST sheet
In addition to this sheet we have added a additional sheet (Sheet1) where we had set the value for one particular cell alone.
While running the sample code in local server we had got the following result sheet ExportExcel1482037911445.xls .
In this resultant excel, in both the sheets the column width had been auto fit to its contents.
But the same when exceuted on sub prod enviroment, we got the following resultant excel. AfterAutoFit1482043026263.xls
In this resultant excel , only the Sheet1 columns had been auto fit to the contents but the TEST sheet columns had not been auto fit to its contents and we are getting exponential values and ‘##’ values in excel.
The resulted values has been highlighted in the attached excel sheets.
Note : We had changed the location and report name details in sample code when it is execeuted on sub prod environment.
Server details : WebLogic Server Version: 10.3.4.0
Java version "1.6.0_21"
Same version used in both local and sub prod environments.
Please help us in resolving this issue and let us know if any further details are required.
Thanks in advance.