Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031648Openbravo ERP09. Financial managementpublic2015-12-04 13:552015-12-15 09:57
Reporterpsanjuan 
Assigned ToTriage Omni OMS 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031648: Review the export of the reports to Excel using Microsoft Office 2007
DescriptionReview the export of the reports to Excel using Microsoft Office 2007
Steps To Reproducen/a
Proposed Solution1. Run the Openbravo Reports 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 all fields required are properly shown.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031593 closed AtulOpenbravo Debit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007 
related to defect 00316683.0PR16Q1 closed Triage Omni OMS Debit and Credit values not shown when running Trial Balance Report in XLS format using Microsoft Office 2007 
related to defect 0031676 closed caristu Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-12-04 13:55psanjuanNew Issue
2015-12-04 13:55psanjuanAssigned To => Triage Finance
2015-12-04 13:55psanjuanOBNetwork customer => No
2015-12-04 13:55psanjuanModules => Core
2015-12-04 13:55psanjuanTriggers an Emergency Pack => No
2015-12-04 13:55psanjuanRelationship addedrelated to 0031593
2015-12-04 13:57egoitzOBNetwork customerNo => Yes
2015-12-04 13:57egoitzIssue Monitored: egoitz
2015-12-04 14:48egoitzResolution time => 1449788400
2015-12-09 12:17maiteRelationship addedrelated to 0031668
2015-12-10 09:37alostaleRelationship addedrelated to 0031676
2015-12-15 08:41caristuNote Added: 0082745
2015-12-15 08:41caristuNote Edited: 0082745bug_revision_view_page.php?bugnote_id=0082745#r10459
2015-12-15 08:42caristuNote Edited: 0082745bug_revision_view_page.php?bugnote_id=0082745#r10460
2015-12-15 08:43caristuNote Edited: 0082745bug_revision_view_page.php?bugnote_id=0082745#r10461
2015-12-15 09:55caristuNote Deleted: 0082745
2015-12-15 09:57caristuReview Assigned To => caristu
2015-12-15 09:57caristuNote Added: 0082754
2015-12-15 09:57caristuStatusnew => closed
2015-12-15 09:57caristuResolutionopen => fixed
2015-12-15 10:08caristuNote Edited: 0082754bug_revision_view_page.php?bugnote_id=0082754#r10464

Notes
(0082754)
caristu   
2015-12-15 09:57   
(edited on: 2015-12-15 10:08)
Now the detect cell type feature is disabled by default. The XLS report content is exported as string now. So now the data is not hidden anymore when opening the report with Office.

If you want to export numeric values, this configuration can be overridden at report level, adding the following content into the .jrxml template:

1) Add the "net.sf.jasperreports.export.xls.detect.cell.type" property with true as its value.
2) Add a pattern for the text field. For example, the patternExpression tag can be used to define the numeric mask.

As an example the General Ledger Report and the Trial Balance has been updated properly. We are using the numeric format output defined for reports in the Format.xml file. This way this reports can apply that format automatically.

Here you can find the changes for these reports: https://code.openbravo.com/erp/devel/pi/rev/7c6686c849289aee3d72d86dc1f9ab5397c6adcb [^] [^]