On Fri, 7 Mar 2008, Faraz Rozi wrote:
Hi folks, I have been working on this problem for quite some time and haven't gotten anywhere with it. The situation is quite critical and urgent. I'm using Apache POI-HSSF usermodel. I have written a program which produces a JTable of certain data and then exports this into a pre-existing excel spreadsheet based on user interaction from the GUI. My spreadsheet has certain cells with pre-existing formulas which rely on the values of other cells that the program is writing to.
Are you running a full formula evaluation once you're done with the jtable? That'd be my suggestion. Simply changing the values in dependent cells isn't enough, you'll still need to tell poi to go and re-calculate the formula cells for you
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
