Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008776Openbravo ERPA. Platformpublic2009-04-27 12:202012-10-11 09:27
iperdomo 
iperdomo 
normalmajoralways
closedout of date 
202.6.28-gentoo-r5
 
 
Core
No
0008776: Improve the number format handling on jasper report based reports
Current:
* The current approach to handling number formatting is through the NUMBERFORMAT parameter, that is a java.text.DecimalFormat class
* The textfield is of java.lang.String format and the paramter is used in the textfield expression: $P{NUMBERFORMAT}.format($F{somefield})
* This has the problem that when exporting to other formats like MS Excel, the numbers are 'strings' so you cannot make calculations with the cells
* Attached you'll find a patch with part of the proposed solution
* There should be a way to make the format map dynamically, so can modifiable
by the consultant
No tags attached.
related to defect 0008513 closed iperdomo Number cells exported to excel are not recognised as numeric values 
diff HttpSecureAppServlet_2.40.diff (1,205) 2009-04-27 12:20
https://issues.openbravo.com/file_download.php?file_id=1226&type=bug
Issue History
2009-04-27 12:20iperdomoNew Issue
2009-04-27 12:20iperdomoAssigned To => iperdomo
2009-04-27 12:20iperdomoFile Added: HttpSecureAppServlet_2.40.diff
2009-04-27 12:20iperdomoRegression testing => No
2009-04-27 12:20iperdomoStatusnew => acknowledged
2009-05-08 17:04iperdomoRelationship addedrelated to 0008513
2012-10-11 09:27iperdomoStatusacknowledged => scheduled
2012-10-11 09:27iperdomofix_in_branch => pi
2012-10-11 09:27iperdomoStatusscheduled => closed
2012-10-11 09:27iperdomoResolutionopen => out of date

There are no notes attached to this issue.