Hi, When I change values using POI, any formulas or graphs depending on these values are not updated.
For example A1 = 100 and A2 = A1, then A2 is 100 Using POI I set A1 = 200 but when I open excel A2 is still 100. If I use Ctrl + F9 the A2 is updated correctly in excel. Is it possible to get Excel to update it automatically as this approach doesn't exactly suit. I have googled this quiet a bit and I have found that I need to set some recalc on open flag but can't find where to do this. Does any one have information on this. Also I am using Excel 2003 and poi 3.0. I think that this might not be a problem in poi 2.0 but can't find a download for older versions. Any help would be great. Also getting the same problem with charts not updating. Regards, Dónal -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 June 2007 20:25 To: POI Users List Subject: Re: Generate csv file using poi On Mon, June 25, 2007 8:03 pm, tiffany wrote: > > Hi, > > I plan to write a program using POI to read an excel work book, retrieve > data from the work book and generate the data into a csv(Common Separated > value) file. > CSV is comma-separated values. You just need to extract the values you want to write and put commas between each value: value1, value2, value3 -- Richard Cote Software Engineer - PRIDE Project Team (Sequence Database Group) European Bioinformatics Institute Wellcome Trust Genome Campus [EMAIL PROTECTED] Hinxton Cambridge CB10 1SD Phone: (+44) 1223 492610 United Kingdom Fax : (+44) 1223 494468 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.8/869 - Release Date: 6/25/2007 5:32 PM --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
