Thanks Alex,
Your solution is working. But now I am not able to hide the cells where the
intermidiate formula value is stored.
HSSFCellStyle.setHidden(true) doesnot seem to be working to hide the value in the
cell.
Is there anyway to hide the value of the cell.
Thanks
pavan
Alex Karshakevich <[EMAIL PROTECTED]> wrote:
Hi,
We were having the same problem with a different formula, having several
nested IFs and math functions. We thought it may be because of nesting
or length of the formula, so our solution was to break the formula into
several shorter pieces and put them into hidden columns, and combine the
result in the destination cell. That worked out in our case. You may
wish to give that a shot.
Alex
>>>I'm trying to get this following formula working when generating an
>>>Excel file using HSSF.
>>>
>>>=IF(EXACT(B101,0),PRODUCT(C101,100),ROUND((C101-B101)/B101*100,0))
>>>
>>>I use the following code:
>>>
>>>HSSFCell c = r.createCell(cellnum);
>>>c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
>>>c.setCellFormula(formula); //The string above
>>>
>>>When using it in normal Excel the formula works fine. In the HSSF
>>>generated file I'm getting a #VALUE! error. However, if I click in
>>>the formula in excel and confirm it without changing anything it also
>>>works.
>>>
>>>
>>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
