[#5196] - excelformula with decimal and comma

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Category:
Bug report
Priority:
Immediate
Status:
New
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

Hi
This is my text field expression.

$F{rate}==0 ? "_" : (new java.text.DecimalFormat("###0.0000;(###0.0000)")).format($F{rate})
Property name---->net.sf.jasperreports.export.xls.formula

I want to display 1 as 1.0000,but it shown as 1 only.
That means when applying excel formula,i am not getting comma seperation and decimal precision in excel.
liyak9@gmail.com
regards
Liya

AttachmentSize
Binary Data report3.jrxml5.93 KB
liyak9's picture
12
Joined: Apr 18 2011 - 10:50pm
Last seen: 11 years 2 months ago
Feedback