Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027369Openbravo ERP09. Financial managementpublic2014-08-19 10:302014-12-30 23:26
Reporteregoitz 
Assigned Tofsoto82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027369: Numer of rows exceded when exporting the report trial balance to excel
DescriptionWhen exporting more than 65532 rows on the report trial balance to excel an exception is raised:

Caused by: jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
Steps To Reproduce-ON an environment whit a big amount of data export the trial balance to excel exporting more than 65532 rows.
Proposed SolutionTwo options:
1-Execute a count before getting the data to see if the result will exced 65532 rows
2-Count the number of rows on the data object
if (data.length > 65532)


Then raise an exception if the number exced the maximum:

        throw new IOException(Utility.messageBD(this, "numberOfRowsExceeded", vars.getLanguage()));

or

throw new ServletException(OBMessageUtils.messageBD("numberOfRowsExceeded"));

Additional Information
TagsNo tags attached.
Relationships
related to defect 0028421 closed aferraz Numer of rows exceded when exporting the journal entries to excel 
related to defect 0035145 new Triage Omni OMS Review limitation in maximum number of rows when exporting to excel some standard reports 
blocks feature request 0029862 closed caristu Ability to generate excel reports with more than 65532 rows 
causes design defect 0031864 new Triage Omni OMS The trial balance report can't manage more than 45000 rows 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-19 10:30egoitzNew Issue
2014-08-19 10:30egoitzAssigned To => dmiguelez
2014-08-19 10:30egoitzModules => Core
2014-08-19 10:30egoitzResolution time => 1410732000
2014-08-19 10:30egoitzTriggers an Emergency Pack => No
2014-09-29 16:12jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-10-31 13:09dmitry_mezentsevAssigned Todmiguelez => Sandrahuguet
2014-11-05 19:29jecharriIssue cloned0028101
2014-11-17 16:23fsoto82Statusnew => scheduled
2014-11-17 16:23fsoto82Assigned ToSandrahuguet => fsoto82
2014-11-17 16:23fsoto82fix_in_branch => pi
2014-11-24 09:28hgbotCheckin
2014-11-24 09:28hgbotNote Added: 0071916
2014-11-24 09:28hgbotStatusscheduled => resolved
2014-11-24 09:28hgbotResolutionopen => fixed
2014-11-24 09:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2bfc159d026faa36d28b419be78b648a7b19959c [^]
2014-11-24 09:53pramakrishnanReview Assigned To => pramakrishnan
2014-11-24 09:53pramakrishnanNote Added: 0071922
2014-11-24 09:53pramakrishnanStatusresolved => closed
2014-12-16 12:49egoitzRelationship addedrelated to 0028421
2014-12-30 23:26hudsonbotCheckin
2014-12-30 23:26hudsonbotNote Added: 0073124
2015-05-13 13:07caristuRelationship addedblocks 0029862
2016-01-15 09:14vmromanosRelationship addedcauses 0031864
2017-02-02 17:31caristuRelationship addedrelated to 0035145

Notes
(0071916)
hgbot   
2014-11-24 09:28   
Repository: erp/devel/pi
Changeset: 2bfc159d026faa36d28b419be78b648a7b19959c
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Fri Nov 21 09:54:43 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/2bfc159d026faa36d28b419be78b648a7b19959c [^]

Fixed bug 27369: No of rows exceed when export the report trial balance to excel

Modified ReportTrialBalance class to chek if the data contains more than 65532 rows

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
---
(0071922)
pramakrishnan   
2014-11-24 09:53   
Code review + Testing - OK.
(0073124)
hudsonbot   
2014-12-30 23:26   
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/6525fe229e06 [^]
Maturity status: Test