Excel formula expression

[fhdbgvhd]

In iReport 3.0.0 version , how can one specify Report element property expression. I need to specify excel formula through property expression "net.sf.jasperreports.export.xls.formula"

I couldn't find the place, where in Ireport to specify the above expreesion. This is very urgent, Can somebody help me.

[rajil]

1. Open iReport 3.0

2. Open your JRXML file

3. Insert "Static Text" from tool bar

4. Right Click on Newly added Static Text

5. Select Custom Element Properties

6. Click On new button

7. Property Name :  net.sf.jasperreports.export.xls.formula

8. Property Value : write any valide Excel expression i.e.  sum(B1:B10) .

remember don't put = sign before formula

9. compile and export report in Excel

10. enjoy formula....

- By KP Bird