We are facing a peculiar problem in excel generation from java. Apache poi
is being used to generate
the code. Some of the cells in excel contain formula.
For examlple one of formula is "=E16+E20+E24+E28".
Real problem starts when above mentioned formula some time comes as
"=E16+E20+E23+E26" in the excel
and produces incorrect summation. This comes on random pattern and one
important thing to mention here
that from 3rd value onwards formula gets started incorrect always.
Following is spceimen code being used for generating above formula,
int rowStartRole = 0;
int rowCount = 15;
int empTypeCount = 3;
int loopCountMax = 4;
String columnIndex = "E";
String sum = null;
/* Loop starts */
for(int loopCount=0;loopCount<loopCountMax; loopCount++) {
if(null == sum){
rowStartRole = rowCount + 1;
sum= columnIndex + rowStartRole;
} else{
rowStartRole = rowStartRole + empTypeCount + 1;
sum= sum + "+" + columnIndex + rowStartRole;
}
}
/* Loop ends */
// set the formula for cell
setCellFormula(sum)
This issue is completely unpredictable and same excel file generated
multiple times results into
correct or incorrect excel randomly.
We get this issue in production environment only though we have development
and UAT environment which
are replica of production, but this issue never ever occur there.
Server : weblogic 10.3.4
Apache poi ver. : 3.2
--
You received this message because you are subscribed to the Google Groups
"JPassion.com: Java Programming" group.
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/jpassion_java?hl=en-US.
