Thanks for your response.
This is a difficult problem to reproduce. The excel file is originated
elsewhere in our application by writing out using POI. When it is read in
this state, the error occurs. If you open the file with Excel, then save it,
then access it in the application, the error does not occur. As such, I
cannot provide an example excel file because by downloading it and saving
it, the error is removed. Something in the save in Excel is cleaning up the
problem.
The formula string is something like: =f4+g4+h4+i4, where the f,g,h, and i
stay the same, but the 4 changes with each row.
The code that writes the formula cell looks like this:
final StringBuffer excelFormula = new StringBuffer(<some string>);
excelSheet.setUserValue(dataRow, currentColumn,
excelFormula.toString());
The cell type is not set. How would I set the cell type to
HSSFCell.CELL_TYPE_FORMULA here?
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Where-is-POI-formula-read-for-HSSF-tp4967675p4971408.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
