0017123: General Ledger Report in XLS format gets Strings instead of numbers

Description

In 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 Reproduce

Open the General Ledger Report in XSL.

Proposed Solution

Instead 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>

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0017122

closed

AinhoaPagola

General Ledger Report in XLS format gets Strings instead of numbers

Notes
(0036701) hgbot (developer) 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 (viewer) 2011-05-24 12:38	Verified

Issue History
Date Modified	Username	Field	Change
2011-05-11 17:03	AinhoaPagola	Type	defect => backport
2011-05-11 17:03	AinhoaPagola	fix_in_branch	=> 2.50
2011-05-12 09:10	hgbot	Checkin
2011-05-12 09:10	hgbot	Note Added: 0036701
2011-05-12 09:10	hgbot	Status	scheduled => resolved
2011-05-12 09:10	hgbot	Resolution	open => fixed
2011-05-12 09:10	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/6f9b1d1fd7d0c313ca5879a21a974ac56b361d27 [^]
2011-05-24 12:38	adrianromero	Note Added: 0037373
2011-05-24 12:38	adrianromero	Status	resolved => closed