Number Formatting

An additional “Format” field may be included in either the Defaults or Formulas data tab during import.  When displaying values for a given attribute, the application will first check and see if the Formulas tab provided a format, if not the Defaults tab is checked.  If none exists, the number is formatted using Scientific Notation (E2) with a few exceptions.

Default Field Formats

  • BeginMeasure – “F”
  • EndMeasure – “F”
  • From – “F”
  • To – “F”
  • “len” – “0.00”
  • RECORDID – “F0”

Fields that contain the following key phrases are automatically displayed with three decimal places (“F”)

  • pipe wall nom
  • pipe diam

Fields that contain the following key phrases are automatically displayed as an integer (no decimal places (“F0”))

  • id
  • begin
  • end
  • maop
  • nop
  • haz zone
  • test press
  • date smys

Specifying a Field Format

To set your own format, use an entry in the defaults tab or formulas tab and in the “Format” field use the following information to generate a C# format string: Using Standard Numeric Format Strings.

 

Knowledgebase