All,
I tried to put in a couple simple formulas, like count and sum and I cannot
get the spreadsheet to "autocalc" these formulas. Anybody have a snippet of
working code that produces a correctly working formula?
curCell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
curCell.setCellFormula("COUNTA("+alphabet.charAt(count)+startRow+":"+alphabe
t.charAt(count)+(rowCount)+")");
After viewing the spreadsheet, if you hit F2 on the formula then enter, it
recalcs it. SO the syntax seems correct.
Any other ideas?
Thanks,
Chris Ernenwein
Senior Software Engineer
http://www.phtcorp.com
AIM, MSN, Y!: cernenwein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
