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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0035145

Openbravo ERP

09. Financial management

public

2017-02-02 17:03

2018-02-21 13:18

Reporter

caristu

Assigned To

Triage Omni OMS

Priority

high

Severity

minor

Reproducibility

N/A

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

Currently 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 Reproduce

In description

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0024014	3.0MP28	closed	jecharri	Export to excel in general ledger when the maximum of rows in exceeded is not showing a message
related to	defect	0028421		closed	aferraz	Numer of rows exceded when exporting the journal entries to excel
related to	defect	0027369	3.0PR15Q1	closed	fsoto82	Numer of rows exceded when exporting the report trial balance to excel
depends on	feature request	0029862		closed	caristu	Ability to generate excel reports with more than 65532 rows