[FINERACT-930] Excel Imports Fail with more than 4000 records

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 1.4.0
• Component/s: Organization
• Labels: easyfix
• Assignee: Sidney Wasibani
• Reporter: Sidney Wasibani
• Created: 05/May/20 13:46
• Updated: 05/May/20 20:33
• Resolved: 05/May/20 20:33

Description

When a bulk import is performed, an output report is generated with a status field that indicates whether the record was successfully imported or not. The field is styled to visually represent failure and success by color.

At the moment, each record is given its own style. This runs into Excel's limitation of at most 4000 styles in a Work Book once there are 4000 rows in the import/output and the import never completes (crashes due to an exception)

Issue Links

• links to: GitHub Pull Request #822