EarthSoft.EDP.UseNumberFormatting

The UseNumberFormatting setting in Professional EDP can be configured to specify a default setting for the entire format, default settings for specific section(s), and/or default settings for individual columns in a section. When importing data from a Microsoft Excel file, EDP will do the following based on the setting:

•If set to “True”, then if the cell has Number formatting applied in Microsoft Excel, EDP will import the formatted value.

•If set to “False” then EDP will import the value without formatting, regardless if the cell has Number formatting applied in Microsoft Excel.

Settings configured in this way will take precedence over the Use_Number_Formatting option in the Backstage.

EQuIS Version: 7

Namespace: EarthSoft.EDP.UseNumberFormatting

Products Affected: Professional EDP

Required Modules: Professional

ST_CONFIG	VALUE	REMARK	VALID VALUES
CONFIG_SECTION	EarthSoft.EDP.UseNumberFormatting	Required
CONFIG_KEY	<format name>	Required	The name of the format to configure.
OBJECT_TYPE
OBJECT_VALUE
STRING_VALUE	<JSON Configuration String>	Required	A JSON string (not case-sensitive).

JSON string structure:

The JSON string should contain the following values for the UseNumberFormatting option:

Format

•Use the “"Format” tag to set a default value for the entire format.

•This will be overridden by any Section or Column specific setting.

•This is not required.

Specific Section

oSpecify values for a specific EDD Section of the Format by adding the Section name followed by the Section setting. See example below for formatting.

oTo set a Section default value, use the “Section” tag. This is not required.

Specific Column in Section

▪Within the Section settings above, specify the value for a specific column by adding the column name followed by the Column setting. See example below for formatting.

Example:

CONFIG_SECTION	CONFIG_KEY	OBJECT_TYPE	OBJECT_VALUE	STRING_VALUE
EarthSoft.EDP.UseNumberFormatting	EQEDD			{“format”: “true”, “TestResults_v1”: {“section”: “false”, “result_value”: “true”}, “TestResultsQC_v1”: {“section”: “false”}}

This would configure the EQEDD Format to import Microsoft Excel files using the following settings for UseNumberFormatting:

•EQEDD Format Default: True

oTestResults_v1 Section Default: False

▪Result_value Column Default: True

oTestResultsQC_v1 Section Default: False