Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029862Openbravo ERPA. Platformpublic2015-05-13 13:062017-03-15 20:18
Reportercaristu 
Assigned Tocaristu 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029862: Ability to generate excel reports with more than 65532 rows
DescriptionCurrently processes that generate excel reports should control by itself the number of generated rows. And in case a limit (65532) is reached, then an error message is thrown.

This limit control is done because there exists a limitation in the jxl library used for generate this kind of reports, when that limit is reached then a jxl.write.biff.RowsExceededException is thrown.

It would be nice if the application would have the ability of generate excel reports with more that 65532 rows.

Project page: http://wiki.openbravo.com/wiki/Projects:Support_Xlsx_Export_Format [^]
Steps To ReproduceIn description
Proposed SolutionIncrease ReportingUtils API to allow exporting excel files into XLSX format (available since Excel 2007[1]). This format has a bigger working area (1,048,576 rows and 16,384 columns)[2].

It would be nice to have a preference to indicate the format to be used to export the excel files by default (XLS or XLSX).

We will need to use the JRXlsxExporter[3] class inside our reporting engine to generate the XLSX reports.

[1] http://superuser.com/a/366473 [^]
[2] http://www.excel-exercise.com/xls-xlsx-file/ [^]
[3] http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/export/ooxml/JRXlsxExporter.html [^]
Additional Information
TagsNo tags attached.
Relationships
related to defect 0028421 closed aferraz Numer of rows exceded when exporting the journal entries to excel 
depends on defect 00273693.0PR15Q1 closed fsoto82 Numer of rows exceded when exporting the report trial balance to excel 
has duplicate design defect 0034163 closed platform Ability to export reports of +65000 lines 
related to defect 0034571 closed alostale Cannot attach xlsx files 
blocks design defect 0031864 new Triage Omni OMS The trial balance report can't manage more than 45000 rows 
blocks defect 0035145 new Triage Omni OMS Review limitation in maximum number of rows when exporting to excel some standard reports 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-13 13:06caristuNew Issue
2015-05-13 13:06caristuAssigned To => platform
2015-05-13 13:06caristuOBNetwork customer => No
2015-05-13 13:06caristuModules => Core
2015-05-13 13:06caristuTriggers an Emergency Pack => No
2015-05-13 13:07caristuRelationship addedrelated to 0028421
2015-05-13 13:07caristuRelationship addeddepends on 0027369
2016-01-15 09:15vmromanosRelationship addedblocks 0031864
2016-11-16 09:44caristuProposed Solution updated
2016-11-16 10:06caristuProposed Solution updated
2016-11-16 10:12ngarciaRelationship addedhas duplicate 0034163
2016-11-16 10:16ngarciaRelationship deletedhas duplicate 0034163
2016-11-16 10:16ngarciaRelationship addedrelated to 0034163
2016-11-21 18:14caristuRelationship addedrelated to 0034571
2016-11-21 18:16caristuRelationship deletedrelated to 0034163
2016-11-21 18:16caristuRelationship addedhas duplicate 0034163
2017-01-12 12:27pradeepvarmaIssue Monitored: pradeepvarma
2017-02-02 13:15caristuDescription Updatedbug_revision_view_page.php?rev_id=14441#r14441
2017-02-02 17:26caristuRelationship addedblocks 0035145
2017-02-03 10:15hgbotCheckin
2017-02-03 10:15hgbotNote Added: 0094031
2017-02-03 10:15hgbotStatusnew => resolved
2017-02-03 10:15hgbotResolutionopen => fixed
2017-02-03 10:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/00086d9062b4888c4902954b88c90780fd3e61bc [^]
2017-02-03 10:16caristuAssigned Toplatform => caristu
2017-02-03 10:16caristuReview Assigned To => alostale
2017-02-10 07:23alostaleNote Added: 0094191
2017-02-10 07:23alostaleStatusresolved => closed
2017-02-10 07:23alostaleFixed in Version => 3.0PR17Q2
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095154

Notes
(0094031)
hgbot   
2017-02-03 10:15   
Repository: erp/devel/pi
Changeset: 00086d9062b4888c4902954b88c90780fd3e61bc
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Feb 03 10:12:21 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/00086d9062b4888c4902954b88c90780fd3e61bc [^]

fixes issue 29862: Ability to generate excel reports with more than 65532 rows

---
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MESSAGE.xml
M modules/org.openbravo.client.application/src/org/openbravo/client/application/report/BaseReportActionHandler.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/report/ReportingUtils.java
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
M src/org/openbravo/erpCommon/ad_process/JasperProcess.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.html
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJRFilter.html
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.html
M src/org/openbravo/erpCommon/utility/DownloadReport.java
---
(0094191)
alostale   
2017-02-10 07:23   
reviewed within project scope
(0095154)
hudsonbot   
2017-03-15 20:18   
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/54e102bef53e [^]
Maturity status: Test