search

usdigitalresponse / usdr-gost

USDR-hosted grants management tools
http://grants.usdigitalresponse.org
Apache License 2.0
27 stars 19 forks source link

Update Input Template to support 1200 Rows of input including Import Data functionality #2943

Open jcomeau1 opened 4 months ago

jcomeau1 commented 4 months ago

Why is this issue important?

The partners have several instances where they have over 200 rows of data in a single upload, specifically around Subawards and Expenditures. This complicates things for the partners as they have to apply their own changes. Additionally, the Import Data function only copies the first 200 rows of data.

Current State

The Input Template currently only supports 200 rows of data. This includes formatting (dates, currency, etc.), validation (like dropdowns), and conditional formatting. Additionally, the Import Data function only copies the first 200 rows.

Expected State

Increase the row limit for all EC and supporting sheets from 200 to 1200. This includes, cell formatting, conditional formatting and validations. Additionally, the Update Validation and Import Data functions must be altered to account for this change.

Implementation Plan

No response

Relevant Code Snippets

No response

jcomeau1 commented 4 months ago

This work has been applied and the version number was NOT increased (v20240404) as this has no affect on the backend or direct impact on the end users.