What about just using Excel IF function in a format like this:
[IF(A1; SUM(C33);""]
Here in the cell A1 you will have something like ${object.conditional() ?: ""}.
--
Regards,
Leo
Tuesday, December 17, 2013, 9:04:02 PM, you wrote:
| Hello, I’m having a hard time finding a working syntax for this : if a certain condition is true, write a sum function in it, otherwise leave it empty. I have tried both the « if » tag, and the ternary operator. Please help me express this correctly : ${object.conditional() ? [SUM(C33)] : ""} Thanks for your help, Marc Ce message et tous les fichiers attachés sont confidentiels et s'adressent exclusivement au(x) destinataire(s) indiqué(s) ci-dessus. Si vous recevez ce message par erreur, veuillez le retourner à l'expéditeur et le détruire. Tout usage, copie ou distribution non autorisés de ce courriel sont strictement interdits. This message and any attachments are confidential and intended solely for the above-mentioned recipient(s). If you have received this message in error, please return it to the sender and delete it from your files. Unauthorized use, copying or distribution of this e-mail is strictly prohibited. |
------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________ jXLS-user mailing list jXLS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jxls-user
