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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029862
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminoralways2015-05-13 13:062017-03-15 20:18
ReportercaristuView Statuspublic 
Assigned Tocaristu 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revision00086d9062b4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029862: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0028421 closedaferraz Numer of rows exceded when exporting the journal entries to excel 
depends on defect 00273693.0PR15Q1 closedfsoto82 Numer of rows exceded when exporting the report trial balance to excel 
has duplicate design defect 0034163 closedplatform Ability to export reports of +65000 lines 
related to defect 0034571 closedalostale Cannot attach xlsx files 
blocks design defect 0031864 newTriage Omni OMS The trial balance report can't manage more than 45000 rows 
blocks defect 0035145 newTriage Omni OMS Review limitation in maximum number of rows when exporting to excel some standard reports 

-  Notes
(0094031)
hgbot (developer)
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 (manager)
2017-02-10 07:23

 reviewed within project scope
(0095154)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2015-05-13 13:06 caristu New Issue
2015-05-13 13:06 caristu Assigned To => platform
2015-05-13 13:06 caristu Modules => Core
2015-05-13 13:06 caristu Triggers an Emergency Pack => No
2015-05-13 13:07 caristu Relationship added related to 0028421
2015-05-13 13:07 caristu Relationship added depends on 0027369
2016-01-15 09:15 vmromanos Relationship added blocks 0031864
2016-11-16 09:44 caristu Proposed Solution updated
2016-11-16 10:06 caristu Proposed Solution updated
2016-11-16 10:12 ngarcia Relationship added has duplicate 0034163
2016-11-16 10:16 ngarcia Relationship deleted has duplicate 0034163
2016-11-16 10:16 ngarcia Relationship added related to 0034163
2016-11-21 18:14 caristu Relationship added related to 0034571
2016-11-21 18:16 caristu Relationship deleted related to 0034163
2016-11-21 18:16 caristu Relationship added has duplicate 0034163
2017-01-12 12:27 pradeepvarma Issue Monitored: pradeepvarma
2017-02-02 13:15 caristu Description Updated View Revisions
2017-02-02 17:26 caristu Relationship added blocks 0035145
2017-02-03 10:15 hgbot Checkin
2017-02-03 10:15 hgbot Note Added: 0094031
2017-02-03 10:15 hgbot Status new => resolved
2017-02-03 10:15 hgbot Resolution open => fixed
2017-02-03 10:15 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/00086d9062b4888c4902954b88c90780fd3e61bc [^]
2017-02-03 10:16 caristu Assigned To platform => caristu
2017-02-03 10:16 caristu Review Assigned To => alostale
2017-02-10 07:23 alostale Note Added: 0094191
2017-02-10 07:23 alostale Status resolved => closed
2017-02-10 07:23 alostale Fixed in Version => 3.0PR17Q2
2017-03-15 20:18 hudsonbot Checkin
2017-03-15 20:18 hudsonbot Note Added: 0095154

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker