Simplest way to go is to write the formula in the cell. When the user opens the workbook excel will calculate the values. IMO, formula evaluation support in POI 3.0 is for scenarios where you want to find out what value a formula cell will contain upon evaluation within you Java Application.
Regards, Tahir -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 1:06 PM To: poi-user@jakarta.apache.org Subject: Formulas with POI Hi, At the moment, I'm developpeing a tool to export a request result throught the MS Excel format using POI. I would like to use formulas to make a sum. I'm using poi 2.0. I only found the AddPtg classes but I don't really understand how to use it. Is anyone can help me? In the meantime, I'm trying to use the Sum classes of POI 3.0 but it's not yet released. Thanks Greg --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/