Formulas for Excel

[Cristian Popa <Ch...@canadalife.com>]

I am generating formulas like:

=COUNTA(I8:I97)

and enter them in cell with setCellFormula().

When I open the spreadsheet, Excel displays 1, no matter the count (0 or
non-0). I have to go on the cell, press F2, Enter and the cell makes the
calculation. Is there anything I can do to enter formulas so that Excel
will recognize them properly?

As for formulas like:

='Sheet1'!B2

is there a workaround so I can enter them properly?

I am using POI 1.10.0 build.


Thank you for your support and keep up the good work,

Cristian





Disclaimer Notice: If you are not the intended recipient of this
transmission, you are hereby notified that any disclosure or other action
taken in reliance on its contents is strictly prohibited. Please delete the
information from your system and notify the sender immediately. We have
taken precautions against viruses, but take no responsibility for loss or
damage that may be caused by its contents.
************************************************************
Avertissement:
Si vous n'êtes pas le destinataire du présent message, soyez par la
présente avisé que toute divulgation ou autre action effectuée en rapport
avec le contenu du message est formellement interdite. Si vous avez reçu ce
message par erreur, veuillez nous en aviser sans délai par un courriel de
réponse et effacer les renseignements de votre système. Nous prenons toutes
les précautions nécessaires pour nous assurer que le présent message ne
contient pas de virus mais nous n'assumons aucune responsabilité quant à la
perte ou aux dommages qui pourraient être causés par son contenu.

Re: Formulas for Excel

[Avik Sengupta <av...@apache.org>]

>I have to go on the cell, press F2, Enter and the cell makes the
> calculation
This is a problem we keep getting, but havent had a good solution till
now. Your best bet atm would be to add it to bugzilla :(

> ='Sheet1'!B2
This should work. dont put the quotes around Sheet1. You will also have
to ensure that Sheet1 is a valid sheetname. 


> On Fri, 2003-06-06 at 20:52, Cristian Popa wrote:
> I am generating formulas like:
> 
> =COUNTA(I8:I97)
> 
> and enter them in cell with setCellFormula().
> 
> When I open the spreadsheet, Excel displays 1, no matter the count (0 or
> non-0). I have to go on the cell, press F2, Enter and the cell makes the
> calculation. Is there anything I can do to enter formulas so that Excel
> will recognize them properly?
> 
> As for formulas like:
> 
> ='Sheet1'!B2
> 
> is there a workaround so I can enter them properly?
> 
> I am using POI 1.10.0 build.
> 
> 
> Thank you for your support and keep up the good work,
> 
> Cristian
> 
> 
> 
> 
> 
> Disclaimer Notice: If you are not the intended recipient of this
> transmission, you are hereby notified that any disclosure or other action
> taken in reliance on its contents is strictly prohibited. Please delete the
> information from your system and notify the sender immediately. We have
> taken precautions against viruses, but take no responsibility for loss or
> damage that may be caused by its contents.
> ************************************************************
> Avertissement:
> Si vous n'êtes pas le destinataire du présent message, soyez par la
> présente avisé que toute divulgation ou autre action effectuée en rapport
> avec le contenu du message est formellement interdite. Si vous avez reçu ce
> message par erreur, veuillez nous en aviser sans délai par un courriel de
> réponse et effacer les renseignements de votre système. Nous prenons toutes
> les précautions nécessaires pour nous assurer que le présent message ne
> contient pas de virus mais nous n'assumons aucune responsabilité quant à la
> perte ou aux dommages qui pourraient être causés par son contenu.
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org