Decimal number format in AdHoc Views displaying incorrectly for resources with English(non US) locale after JasperSoft 8.1.1 upgrade.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After the upgrade from Jaspsersoft 7.8 to 8.1.1, the number formats have changed in AdHoc views 

Steps to Reproduce: 

1. Login to clarity with a user who has access to Advance Reporting
2. In Clarity set a resource to have the English(Australia) locale
3. Create an AdHoc View with any domain which has financial attributes (e.g Rows: Investment Name, Plan Transaction Class. Columns: Fiscal Month, Actual COst, Plan Cost)  
   
   

Expected Results: Numeric formatted results should be displayed in format 999,999.99

Actual Results: Numeric results are formatted with . and , transposed - 999.999,00

Workaround: 
Export the data in any format like CSV, Excel, PDF and format is ok as expected

 

Environment

Release : Jaspersoft 8.1.1 with any supported & compatible version of Clarity and non US locale, i.e. Australia

Cause

Tibco has confirmed this as defect JS-67531 and Broadcom is tracking this under DE69667

Resolution

DE69667 - Issue is resolved with JasperSoft 8.1.1 Patch 1.

Additional Information

Issues Fixed in Jaspersoft 8.1.1 Patch 1