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]
