<< Click to Display Table of Contents >> Navigation:  Configuration > ST_CONFIG Entries > Formats > 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

 

 

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:

 

 

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