>> ='Sheet1'!B2
>This should work. dont put the quotes around Sheet1. You will also have
>to ensure that Sheet1 is a valid sheetname.
I have entered the formula like this: cell.setCellFormula("Sheet1!B2")
When I open the spreadsheet, I'm getting: =#REF!B2
The sheet "Sheet1" is created prior to entering the formula and contains
valid data. Again, if I enter the formula like simple string with
cell.setCellValue("=Sheet1!B2") and use F2 in Excel, on the cell, it
creates the reference properly.
Any suggestions?
Thank you,
Cristian
Avik Sengupta
<[EMAIL PROTECTED]> To: POI Users List <[EMAIL
PROTECTED]>
cc:
06/06/2003 11:53 Subject: Re: Formulas for Excel
AM
Please respond to
"POI Users List"
>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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
