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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035145
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminorN/A2017-02-02 17:032018-02-21 13:18
ReportercaristuView Statuspublic 
Assigned ToTriage Omni OMS 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035145: Review limitation in maximum number of rows when exporting to excel some standard reports

DescriptionCurrently some standard reports limit the maximum amount of rows that can be exported to excel (65532). This was done to prevent errors when generating the xls file which contains the report. In core there are the following reports:

- ReportGeneralLedger
- ReportGeneralLedgerJournal
- ReportTrialBalance

With issue 0029862 now it is possible to export excel reports in xlsx format which can store more than 65532 rows. Also, it is possible to export into xls format by setting a preference, in order to keep backwards compatibility. So, those reports must be reviewed and decide what to do when the output format is xlsx:

a) Do not set any limit
b) Set as limit the maximum number of rows allowed by xlsx (1,048,576). Note that this could be risky, in terms of performance.
c) Make a configurable limit (for example based on another preference)
Steps To ReproduceIn description
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00240143.0MP28 closedjecharri Export to excel in general ledger when the maximum of rows in exceeded is not showing a message 
related to defect 0028421 closedaferraz Numer of rows exceded when exporting the journal entries to excel 
related to defect 00273693.0PR15Q1 closedfsoto82 Numer of rows exceded when exporting the report trial balance to excel 
depends on feature request 0029862 closedcaristu Ability to generate excel reports with more than 65532 rows 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2017-02-02 17:03 caristu New Issue
2017-02-02 17:03 caristu Assigned To => Triage Finance
2017-02-02 17:03 caristu Modules => Core
2017-02-02 17:03 caristu Triggers an Emergency Pack => No
2017-02-02 17:19 caristu Description Updated View Revisions
2017-02-02 17:26 caristu Relationship added depends on 0029862
2017-02-02 17:28 caristu Relationship added related to 0024014
2017-02-02 17:29 caristu Relationship added related to 0028421
2017-02-02 17:31 caristu Relationship added related to 0027369
2017-02-02 17:44 caristu Description Updated View Revisions
2018-02-21 13:18 Practics Issue Monitored: Practics

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker