Excel formula expression

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.
fhdbgvhd's picture
Joined: May 12 2008 - 12:33am
Last seen: 15 years 4 months ago

1 Answer:

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

rajil's picture
Joined: Jun 11 2008 - 10:18pm
Last seen: 1 week 6 days ago