Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0031629Openbravo ERP09. Financial managementpublic2015-11-26 10:302015-12-01 12:33
maite 
AtulOpenbravo 
immediatemajoralways
closedfixed 
5
 
3.0PR15Q3.4 
dmiguelez
Core
No
0031629: Debit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007
Debit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007
1. Run General Ledger Report in XLS format using Microsoft Office 2007 from a windows machine setting any filtering critera
2. Open xls file with Microsoft Excel and realize that Credit and Debit values are not shown

NOTE: difference is in format of Credit and Debit columns. If you open PR15Q2 file with Microsoft Office 2007 and check format of the column is "General". However file from PR15Q3 has format defined as "Personalize"
No tags attached.
blocks defect 0031593 closed AtulOpenbravo Debit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007 
Issue History
2015-12-01 12:30dmiguelezTypedefect => backport
2015-12-01 12:30dmiguelezTarget Version => 3.0PR15Q3.4
2015-12-01 12:32hgbotCheckin
2015-12-01 12:32hgbotNote Added: 0082483
2015-12-01 12:32hgbotStatusscheduled => resolved
2015-12-01 12:32hgbotResolutionopen => fixed
2015-12-01 12:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q3.4/rev/6abe3000db92a8e84f1ecfac110496db027f4c9e [^]
2015-12-01 12:33dmiguelezReview Assigned To => dmiguelez
2015-12-01 12:33dmiguelezNote Added: 0082487
2015-12-01 12:33dmiguelezStatusresolved => closed

Notes
(0082483)
hgbot   
2015-12-01 12:32   
Repository: erp/backports/3.0PR15Q3.4
Changeset: 6abe3000db92a8e84f1ecfac110496db027f4c9e
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Nov 30 14:24:17 2015 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR15Q3.4/rev/6abe3000db92a8e84f1ecfac110496db027f4c9e [^]

Fixes Issue 31629:Debit and Credit values not shown when running General
Ledger Report in XLS format using Microsoft Office 2007

Used Numberformat parameter to format the numeric fields

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
---
(0082487)
dmiguelez   
2015-12-01 12:33   
Code Review + Testing Ok