Skip to content

Add an option to determine the format of the columns while writing the google sheet from json file  #2

@SamuelLaheux

Description

@SamuelLaheux

Add an option to determine the format of the columns while writing the google sheet from json file.

An example:

  {
    "pName": "param1",
    "pDesc": "",
    "pref": "",
    "pVal": 0.00001,
    "pMinValue": 0.0000903,
    "pMaxValue": "",
    "pIsDeprecated": "False"
  },
  {
    "pName": "param2",
    "pDesc": "",
    "pref": "",
    "pVal": 1e-15,
    "pMinValue": 1e-15,
    "pMaxValue": "",
    "pIsDeprecated": "False"
  }
]

gives us:

pName   | pDesc  | pref | pVal    | pMinValue | pMaxValue | pIsDeprecated
--      | --     | --   | --      | --        | --        | --
param1  |        |      | 0.00001 | 0.0000903 |           | FALSE
param2  |        |      | 0       | 0         |           | FALSE


and we want to determine the format of the table (or for pVal, pMinValue and pMaxValue column) to be "Scientific format" instead of "Automatic format":

pName | pDesc | pref | pVal | pMinValue | pMaxValue | pIsDeprecated
-- | -- | -- | -- | -- | -- | --
param1 |   |   | 1.00E-05 | 9.03E-05 |   | FALSE
param2 |   |   | 1.00E-15 | 1.00E-15 |   | FALSE


Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions