Would it be possible to add IF support to the formulas? I have a couple of reports that need to use if statements.
Here is an example of somthing I am trying to do (that is not working with Aspose Excel):
=IF(H288 = “1”,“Commission”,IF(H288 = “2”,“Cheque”,""))
Yes. I will add IF support to the formulas. It will be available at the beginning of next week.
Now it’s availabe. Please download it at http://www.aspose.com/products/aspose.excel/fixes/aspose.excel.zip.
Works well for the formula I posted but it seems a few operators do not work?? Could you check:
<> not equal to
> greater than
< less than
>= greater or equal
<= less or equal
Thank you very much for the quick response!
Surely I will make these operators work. Please wait for another two days.
Thanks for your patience.
No hurry Laurence,
I have worked around it using just ‘=’ but it will be needed in the near future I am sure. These features are making Aspose.Excel a really powerful online reporting tool. Keep it up and thank you!
Now it’s available. Please download Hotfix 1.7.6.