Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformminoralways2015-12-09 17:262015-12-15 08:51
ReportercaristuView Statuspublic 
Assigned Tocaristu 
PriorityimmediateResolutionfixedFixed in Version3.0PR15Q4.1
StatusclosedFix in branchFixed in SCM revisione2a3526d0bf7
ProjectionnoneETAnoneTarget Version3.0PR15Q4.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
Regression levelProduction - Confirmed Stable
Regression date2015-04-13
Regression introduced in release3.0PR15Q3
Regression introduced by commit [^]
Triggers an Emergency PackNo

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

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0031676 closedcaristu Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 

-  Notes
hgbot (developer)
2015-12-14 16:51

Repository: erp/backports/3.0PR15Q4.1
Changeset: e2a3526d0bf7fb20be2ce13c8615844a2eeb04db
Author: Carlos Aristu <carlos.aristu <at>>
Date: Mon Dec 14 16:48:42 2015 +0100
URL: [^]

fixes issue 31683: 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/
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
alostale (developer)
2015-12-15 08:51

code reviewed

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

- Issue History
Date Modified Username Field Change
2015-12-10 09:38 alostale Type defect => backport
2015-12-10 09:38 alostale Target Version => 3.0PR15Q4.1
2015-12-14 16:50 caristu Review Assigned To => alostale
2015-12-14 16:51 caristu Issue Monitored: alostale
2015-12-14 16:51 hgbot Checkin
2015-12-14 16:51 hgbot Note Added: 0082731
2015-12-14 16:51 hgbot Status scheduled => resolved
2015-12-14 16:51 hgbot Resolution open => fixed
2015-12-14 16:51 hgbot Fixed in SCM revision => [^]
2015-12-14 17:19 caristu Proposed Solution updated
2015-12-15 08:51 alostale Note Added: 0082746
2015-12-15 08:51 alostale Status resolved => closed
2015-12-15 08:51 alostale Fixed in Version => 3.0PR15Q4.1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker