The last I checked HSSF didn't actually handle formulas, even though the literature/code markup makes it sound like it does. Here is the thread from the archives for this group: http://marc.theaimsgroup.com/?l=poi-user <http://marc.theaimsgroup.com/?l=poi-user&m=105190961026425&w=2> &m=105190961026425&w=2 Please let me know if you find a way to get HSSF to do formulas. thx, Matt Savino
-----Original Message----- From: Anant Sagar [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 1:39 AM To: POI Users List Subject: HSSF: Sheet Reference Formula not working Hi All, Need Help! When I am trying to set a sheet reference formula to a cell, I get the 'Integer Expected' error. I m using latest POI version i.e. "poi-2.0-RC1-20031102". I am trying to create a formula in Sheet 3 to sum Sheet1:Cell B12 and Sheet2:Cell.Here is the code where it originates. I tried by putting = sign before formula, this also does'nt work. The same formula works if i paste on excel cell manually. ------------------------------------------------------- String strFormulas = "SUM('Sheet1'!B12,'Sheet2'!B12)" ; objCell.setCellFormula(strFormulas); ------------------------------------------------------- Here is the stacktrace------- Error: Integer Expected java.lang.RuntimeException: Cannot Parse, sorry : Integer Expected at org.apache.poi.hssf.model.FormulaParser.Abort(FormulaParser.java:154) at org.apache.poi.hssf.model.FormulaParser.Expected(FormulaParser.java:1 61) at org.apache.poi.hssf.model.FormulaParser.GetNum(FormulaParser.java:258 ) at org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:492 ) at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:545) at org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java :596) at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:701) at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:7 15) at com.pg.psf.util.ExcelWriter.writeToExcel(E:/JRUN4/servers/PSF/default -ear/default-war/WEB-INF/src/com/pg/psf/util/ExcelWriter.java:318) Does someone know how to solve this problem. Pls. let me know. -Anant Sagar
