poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dónal Doyle <donal.do...@idiro.com>
Subject Excel not recalculating Formulas
Date Mon, 25 Jun 2007 21:02:13 GMT
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: rcote@ebi.ac.uk [mailto:rcote@ebi.ac.uk] 
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            RCote@ebi.ac.uk
Hinxton
Cambridge CB10 1SD                      Phone: (+44) 1223 492610
United Kingdom                          Fax  : (+44) 1223 494468


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org



-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message