You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Dónal Doyle <do...@idiro.com> on 2007/06/25 23:02:13 UTC
Excel not recalculating Formulas
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