Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031648
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2015-12-04 13:552015-12-15 09:57
ReporterpsanjuanView Statuspublic 
Assigned ToTriage Omni OMS 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031648: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0031593 closedAtulOpenbravo Debit and Credit values not shown when running General Ledger Report in XLS format using Microsoft Office 2007 
related to defect 00316683.0PR16Q1 closedTriage Omni OMS Debit and Credit values not shown when running Trial Balance Report in XLS format using Microsoft Office 2007 
related to defect 0031676 closedcaristu Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 

-  Notes
(0082754)
caristu (developer)
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 [^] [^]

- Issue History
Date Modified Username Field Change
2015-12-04 13:55 psanjuan New Issue
2015-12-04 13:55 psanjuan Assigned To => Triage Finance
2015-12-04 13:55 psanjuan Modules => Core
2015-12-04 13:55 psanjuan Triggers an Emergency Pack => No
2015-12-04 13:55 psanjuan Relationship added related to 0031593
2015-12-04 13:57 egoitz Issue Monitored: egoitz
2015-12-04 14:48 egoitz Resolution time => 1449788400
2015-12-09 12:17 maite Relationship added related to 0031668
2015-12-10 09:37 alostale Relationship added related to 0031676
2015-12-15 08:41 caristu Note Added: 0082745
2015-12-15 08:41 caristu Note Edited: 0082745 View Revisions
2015-12-15 08:42 caristu Note Edited: 0082745 View Revisions
2015-12-15 08:43 caristu Note Edited: 0082745 View Revisions
2015-12-15 09:55 caristu Note Deleted: 0082745
2015-12-15 09:57 caristu Review Assigned To => caristu
2015-12-15 09:57 caristu Note Added: 0082754
2015-12-15 09:57 caristu Status new => closed
2015-12-15 09:57 caristu Resolution open => fixed
2015-12-15 10:08 caristu Note Edited: 0082754 View Revisions

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker