While generate Excel file Comes runtime Error

[bansri.gor]

Hello,  I am the beginner In the Jasper studio. I try to add below Property for add excel formula.

<property name="net.sf.jasperreports.export.xls.formula">
                            <![CDATA[=($'COURSE INFO'.C7')]]>
                        </property>

this Property Gives me a runtime error. this error is below 

net.sf.jasperreports.engine.JRException: org.apache.poi.ss.formula.FormulaParseException: Parse error near char 1 '$' in specified formula '($'COURSE INFO'.C7')'. Expected number, string, defined name, or data table

 

Excel Formula not work. Tell me. Please, How can  I solve those error? 

 

[hozawa]

There's a sample on how to use formula.

http://jasperreports.sourceforge.net/sample.reference/xlsformula/index.html

>$'COURSE INFO'.C7'

Try removing the '$'