Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031676Openbravo ERPA. Platformpublic2015-12-09 17:262015-12-15 23:49
Reportercaristu 
Assigned Tocaristu 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q1 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2015-04-13
Regression introduced in release3.0PR15Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/ac68a43ce6569746a77f67d78906d7addbac841b [^]
Triggers an Emergency PackNo
Summary0031676: Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007
DescriptionSome values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007
Steps To Reproduce1. Run any manual report in XLS format
2. Open xls file with Microsoft Excel 2007and realize that Credit and Debit values are not shown
Proposed SolutionThe cell auto detect feature of Jasper is generating the format of the column as "Personalize", this causes the values not be shown.

Without using this feature all the values are exported as strings.

Notice that this is problem not happening with LibreOffice.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031648 closed Triage Omni OMS Review the export of the reports to Excel using Microsoft Office 2007 
depends on backport 00316833.0PR15Q4.1 closed caristu Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 
depends on backport 00316843.0PR15Q3.5 closed caristu Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 
caused by feature request 0029566 closed caristu Upgrade Jasper Libraries 
related to defect 0031710 closed collazoandy4 Review XLS reports to apply cell type when required 
related to feature request 0033743 new Triage Platform Base Numeric Values in Reports are Text, not numeric in Excel 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-12-09 17:26caristuNew Issue
2015-12-09 17:26caristuAssigned To => caristu
2015-12-09 17:26caristuModules => Core
2015-12-09 17:26caristuRegression level => Production - Confirmed Stable
2015-12-09 17:26caristuRegression date => 2015-04-13
2015-12-09 17:26caristuRegression introduced in release => 3.0PR15Q3
2015-12-09 17:26caristuRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/ac68a43ce6569746a77f67d78906d7addbac841b [^]
2015-12-09 17:26caristuTriggers an Emergency Pack => No
2015-12-09 17:26caristuRelationship addedcaused by 0029566
2015-12-10 09:37alostaleRelationship addedrelated to 0031648
2015-12-10 09:37alostalePriorityhigh => immediate
2015-12-10 09:38alostaleStatusnew => scheduled
2015-12-14 16:28hgbotCheckin
2015-12-14 16:28hgbotNote Added: 0082728
2015-12-14 16:28hgbotStatusscheduled => resolved
2015-12-14 16:28hgbotResolutionopen => fixed
2015-12-14 16:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7c6686c849289aee3d72d86dc1f9ab5397c6adcb [^]
2015-12-14 16:32caristuNote Added: 0082729
2015-12-14 16:34caristuNote Edited: 0082729bug_revision_view_page.php?bugnote_id=0082729#r10456
2015-12-14 16:34caristuAssigned Tocaristu => alostale
2015-12-14 16:35caristuAssigned Toalostale => caristu
2015-12-14 16:35caristuReview Assigned To => alostale
2015-12-14 16:35caristuIssue Monitored: alostale
2015-12-14 17:18caristuProposed Solution updated
2015-12-14 17:21caristuNote Edited: 0082729bug_revision_view_page.php?bugnote_id=0082729#r10457
2015-12-15 08:43caristuNote Edited: 0082729bug_revision_view_page.php?bugnote_id=0082729#r10462
2015-12-15 09:19alostaleNote Added: 0082747
2015-12-15 09:19alostaleStatusresolved => closed
2015-12-15 09:19alostaleFixed in Version => 3.0PR16Q1
2015-12-15 09:53caristuNote Added: 0082752
2015-12-15 10:06caristuRelationship addedrelated to 0031710
2015-12-15 23:49hudsonbotCheckin
2015-12-15 23:49hudsonbotNote Added: 0082791
2016-08-23 08:33caristuRelationship addedrelated to 0033743

Notes
(0082728)
hgbot   
2015-12-14 16:28   
Repository: erp/devel/pi
Changeset: 7c6686c849289aee3d72d86dc1f9ab5397c6adcb
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Dec 14 16:26:16 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7c6686c849289aee3d72d86dc1f9ab5397c6adcb [^]

fixes issue 31676: Some values are not shown in XLS format using MS Office

The detect cell type feature was not working properly for BigInteger values in Office after the Jasper Library Upgrade. A personalized format was applied causing the data not be shown when opening the report.

To solve this problem the detect cell type feature has been disabled. This way, by default, all the values in the XLS will be exported as strings.

This default configuration can be overriden at report level. As an example, the General Ledger Report and Trial Balance report have been updated properly. With this configuration, those reports are now using number formatting for the cells showing the BigDecimal values.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/report/ReportingUtils.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
---
(0082729)
caristu   
2015-12-14 16:32   
(edited on: 2015-12-15 08:43)
Now the detect cell type feature is disabled by default. The XLS report content is exported as string now.

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.
(0082747)
alostale   
2015-12-15 09:19   
code reviewed

Tested:
-General Ledger and Trial Balance reports are correctly exported, numeric values are seen as numbers in spreadsheet (both libreoffice and office)
-Reports can be exported to PDF
-Other reports (ie. Purchase Order Report) are correctly exported to XLS but their numeric columns are seen as string (both libreoffice and office)
(0082752)
caristu   
2015-12-15 09:53   
Wiki page updated: http://wiki.openbravo.com/wiki/How_to_create_a_Report#Configuring_Cell_Type_in_XLS_Reports [^]
(0082791)
hudsonbot   
2015-12-15 23:49   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ecd185534f50 [^]
Maturity status: Test