Data Entry Excel - dates that appear in the schema conformant section appear as Excel DateValue ( ) and not formatted according to an ISO specification (e.g. YYYY-MM-DD). Suggest that the date entry and associated format from the Data Entry tab is copied directly to the schema conformant section.
Also suggest that we remove protection from the 'schema conformant data' sheet. Data validation cannot ultimately happen within Excel - there are other tools that will do a better job. Instead, the Data Entry Excel should help researchers prepare for validation tools. The development to make Excel work with OCA would be too much.
Data Entry Excel - dates that appear in the schema conformant section appear as Excel DateValue ( ) and not formatted according to an ISO specification (e.g. YYYY-MM-DD). Suggest that the date entry and associated format from the Data Entry tab is copied directly to the schema conformant section.
Also suggest that we remove protection from the 'schema conformant data' sheet. Data validation cannot ultimately happen within Excel - there are other tools that will do a better job. Instead, the Data Entry Excel should help researchers prepare for validation tools. The development to make Excel work with OCA would be too much.