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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027369
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2014-08-19 10:302014-12-30 23:26
ReporteregoitzView Statuspublic 
Assigned Tofsoto82 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision2bfc159d026f
ProjectionnoneETAnoneTarget Version3.0PR15Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Topramakrishnan
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027369: 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"));

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 
related to defect 0035145 newTriage Omni OMS Review limitation in maximum number of rows when exporting to excel some standard reports 
blocks feature request 0029862 closedcaristu Ability to generate excel reports with more than 65532 rows 
causes design defect 0031864 newTriage Omni OMS The trial balance report can't manage more than 45000 rows 

-  Notes
(0071916)
hgbot (developer)
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 (developer)
2014-11-24 09:53

Code review + Testing - OK.
(0073124)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2014-08-19 10:30 egoitz New Issue
2014-08-19 10:30 egoitz Assigned To => dmiguelez
2014-08-19 10:30 egoitz Modules => Core
2014-08-19 10:30 egoitz Resolution time => 1410732000
2014-08-19 10:30 egoitz Triggers an Emergency Pack => No
2014-09-29 16:12 jonalegriaesarte Target Version 3.0PR14Q4 => 3.0PR15Q1
2014-10-31 13:09 dmitry_mezentsev Assigned To dmiguelez => Sandrahuguet
2014-11-05 19:29 jecharri Issue cloned 0028101
2014-11-17 16:23 fsoto82 Status new => scheduled
2014-11-17 16:23 fsoto82 Assigned To Sandrahuguet => fsoto82
2014-11-17 16:23 fsoto82 fix_in_branch => pi
2014-11-24 09:28 hgbot Checkin
2014-11-24 09:28 hgbot Note Added: 0071916
2014-11-24 09:28 hgbot Status scheduled => resolved
2014-11-24 09:28 hgbot Resolution open => fixed
2014-11-24 09:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2bfc159d026faa36d28b419be78b648a7b19959c [^]
2014-11-24 09:53 pramakrishnan Review Assigned To => pramakrishnan
2014-11-24 09:53 pramakrishnan Note Added: 0071922
2014-11-24 09:53 pramakrishnan Status resolved => closed
2014-12-16 12:49 egoitz Relationship added related to 0028421
2014-12-30 23:26 hudsonbot Checkin
2014-12-30 23:26 hudsonbot Note Added: 0073124
2015-05-13 13:07 caristu Relationship added blocks 0029862
2016-01-15 09:14 vmromanos Relationship added causes 0031864
2017-02-02 17:31 caristu Relationship added related to 0035145


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker