>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]
