Project:
| View Revisions: Issue #35145 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0035145: Review limitation in maximum number of rows when exporting to excel some standard reports | ||
| Revision | 2017-02-02 17:44 by caristu | ||
| 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) |
||
| Revision | 2017-02-02 17:19 by caristu | ||
| 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. These reports are: - 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) |
||
| Revision | 2017-02-02 17:03 by caristu | ||
| 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. 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) |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |