Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017123Openbravo ERP09. Financial managementpublic2011-05-11 17:032011-05-24 12:38
ReporterAinhoaPagola 
Assigned ToAinhoaPagola 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017123: General Ledger Report in XLS format gets Strings instead of numbers
DescriptionIn the General Ledger Report, in the XLS version, the Credit and Debit fields are Strings instead of Numbers. Strings have a ' before the numeric figures.

This is why operations like + work OK but SUM function and similars don't.
Steps To ReproduceOpen the General Ledger Report in XSL.
Proposed SolutionInstead of:
<textFieldExpression class="java.lang.String"><![CDATA[($F{AMTACCTCR}!=BigDecimal.ZERO && $F{AMTACCTCR}!=null)?$P{NUMBERFORMAT}.format($F{AMTACCTCR}).toString():new String(" ")]]></textFieldExpression>

Have:
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AMTACCTCR}]]></textFieldExpression>

                  
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0017122 closed AinhoaPagola General Ledger Report in XLS format gets Strings instead of numbers 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-11 17:03AinhoaPagolaTypedefect => backport
2011-05-11 17:03AinhoaPagolafix_in_branch => 2.50
2011-05-12 09:10hgbotCheckin
2011-05-12 09:10hgbotNote Added: 0036701
2011-05-12 09:10hgbotStatusscheduled => resolved
2011-05-12 09:10hgbotResolutionopen => fixed
2011-05-12 09:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/6f9b1d1fd7d0c313ca5879a21a974ac56b361d27 [^]
2011-05-24 12:38adrianromeroNote Added: 0037373
2011-05-24 12:38adrianromeroStatusresolved => closed

Notes
(0036701)
hgbot   
2011-05-12 09:10   
Repository: erp/stable/2.50
Changeset: 6f9b1d1fd7d0c313ca5879a21a974ac56b361d27
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Wed May 11 19:12:35 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/6f9b1d1fd7d0c313ca5879a21a974ac56b361d27 [^]

Fixes issue 17123 General Ledger Report in XLS gets numbers

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
---
(0037373)
adrianromero   
2011-05-24 12:38   
Verified