Will someone tell me what class/method to use to trigger formular rec prior to saving the workbook object to a file?
I used POI to create daily Excel file using a template with formular. First of all, user will be prompted to save the file whey he/she exit Excel, eventhough he/she had never change any content. This is due to the formula recal upon Excel startup. Second problem is when a user is currently browsing an XLS file with the "recal" turned off, simply click open the POI generared XLS file (with formula), the formula wil not be doing any recal and therefore it display wrong info. Is tere a way via POI that I can trigger a "recal" before saving? jml __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- 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/
