title: Using Google Sheets API, adding and updating Column Formatting is not honoured when I entered the data
body: <p>So, it is really a follow-up question based on my last attempt  </p>
  
  <p><a href="https://stackoverflow.com/questions/57259399/how-to-add-the-column-to-google-sheets-using-api-and-provide-the-name-and-type-o">How to add the column to Google Sheets using API and provide the name and type of the column in the same call?</a></p>
  
  <p>So, I thought to use <code>batchUpdate</code> command to do the following in a <strong>single</strong> API call  </p>
  
  <ul>
  <li>Add a new column.  </li>
  <li>Give a name to the column at <code>A1:A2</code> (using <code>A1 notation</code>)  </li>
  <li>Provide the formatting for the column values <code>A2:A</code> (for all the values that will fall into this column.  </li>
  </ul>
  
  <p>I structured my API call and executed as following  </p>
  
  <pre><code>curl -v \
  -H 'Authorization: Bearer ya29.GlxUB-UnpiYLeMzdAYyz_kVvNIVwmlMvxauAfiklslphd60INbgOQEr2eUwdx4smOSirde63hW2CvR17AMfj1P5iGw1Q3dRgGBHGZ92JKoFWozSxjbJh0wEZJKvDUQ' \
  -H 'Content-Type: application/json' \
  -d '{
        "requests": [
          {
            "insertDimension": {
              "range": {
                "sheetId": 2052094881,
                "dimension": "COLUMNS",
                "startIndex": 0,
                "endIndex": 1
              }
            }
          },
          {
            "repeatCell": {
              "range": {
                "sheetId": 2052094881,
                "startRowIndex": 0,
                "endRowIndex": 1,
                "startColumnIndex": 0,
                "endColumnIndex": 1
              },
              "cell": {
                "userEnteredValue": {
                  "stringValue": "discretionary"
                }
              },
              "fields": "userEnteredValue.stringValue"
            }
          },{
            "repeatCell": {
              "range": {
                "sheetId": 2052094881,
                "startRowIndex": 1,
                "startColumnIndex": 1,
              },
              "cell": {
                "userEnteredFormat": {
                  "numberFormat": {
                      "type": "DATE_TIME",
                      "pattern": "dddd, m/d/yy at h:mm"
                  }
                }
              },
              "fields": "userEnteredFormat.numberFormat"
            }
          },
        ],
      }' \
  https://sheets.googleapis.com/v4/spreadsheets/1mHrPXQILuprO4NdqTgrVKlGazvvzgCFqIphGdsmptD8:batchUpdate
  </code></pre>
  
  <p>This seemed to work fine as I could see a new Column at index <code>0</code> which is <code>A</code> and the API response was also good</p>
  
  <pre><code>&lt; HTTP/2 200
  &lt; content-type: application/json; charset=UTF-8
  &lt; vary: X-Origin
  &lt; vary: Referer
  &lt; vary: Origin,Accept-Encoding
  &lt; date: Mon, 29 Jul 2019 20:09:29 GMT
  &lt; server: ESF
  &lt; cache-control: private
  &lt; x-xss-protection: 0
  &lt; x-frame-options: SAMEORIGIN
  &lt; alt-svc: quic=":443"; ma=2592000; v="46,43,39"
  &lt; accept-ranges: none
  &lt;
  {
    "spreadsheetId": "1mHrPXQILuprO4NdqTgrVKlGazvvzgCFqIphGdsmptD8",
    "replies": [
      {},
      {},
      {}
    ]
  }
  * Connection #0 to host sheets.googleapis.com left intact
  </code></pre>
  
  <p>So, I thought to verify that if now I put any value into this column (starting from <code>A2</code>), the formatting <code>dddd, m/d/yy at h:mm</code> would be applied. So I inserted a value which looks like following command</p>
  
  <pre><code>curl -v \
  -H 'Authorization: Bearer ya29.GlxUB3ad1mGpbFBT1raZx2C76kmiSPBDX6_epAWNd3hwWC7EMtzgVBPB34JAK543N7g2Y1cYeFc_VWjTpmeU7LSE4nDGiyCUafqhqPTJHUg5UmrfjVxH5pcmeJXK4Q' \
  -H 'Content-Type: application/json' \
  -X POST \
  -d '{
    "valueInputOption": "USER_ENTERED",
    "data": [
      {
        "range": "Sheet1!A2:A3",
        "majorDimension": "COLUMNS",
        "values": [
          ["7/29/2019 12:56:31"]
        ]
      }
    ]
  }' \
  https://sheets.googleapis.com/v4/spreadsheets/1mHrPXQILuprO4NdqTgrVKlGazvvzgCFqIphGdsmptD8/values:batchUpdate
  </code></pre>
  
  <p>When I executed, the response seemed fine</p>
  
  <pre><code>&lt; HTTP/2 200
  &lt; content-type: application/json; charset=UTF-8
  &lt; vary: X-Origin
  &lt; vary: Referer
  &lt; vary: Origin,Accept-Encoding
  &lt; date: Mon, 29 Jul 2019 20:09:58 GMT
  &lt; server: ESF
  &lt; cache-control: private
  &lt; x-xss-protection: 0
  &lt; x-frame-options: SAMEORIGIN
  &lt; alt-svc: quic=":443"; ma=2592000; v="46,43,39"
  &lt; accept-ranges: none
  &lt;
  {
    "spreadsheetId": "1mHrPXQILuprO4NdqTgrVKlGazvvzgCFqIphGdsmptD8",
    "totalUpdatedRows": 1,
    "totalUpdatedColumns": 1,
    "totalUpdatedCells": 1,
    "totalUpdatedSheets": 1,
    "responses": [
      {
        "spreadsheetId": "1mHrPXQILuprO4NdqTgrVKlGazvvzgCFqIphGdsmptD8",
        "updatedRange": "Sheet1!A2",
        "updatedRows": 1,
        "updatedColumns": 1,
        "updatedCells": 1
      }
    ]
  }
  </code></pre>
  
  <p>However, when I looked at the Sheet from the browser, the literal value <code>7/29/2019 12:56:31</code> was available. I found this incorrect, because I expected formatting <code>dddd, m/d/yy at h:mm</code> to have applied  </p>
  
  <p><a href="https://i.stack.imgur.com/pFpi1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pFpi1.png" alt="enter image description here"></a></p>
  
  <p>I am looking to find out the answers to the following questions<br>
  - First, what am I doing wrong here? 
  - How do I fix this issue?<br>
  - How can I know the formatting of a column when looking at the column using the browser view?  </p>
  
  <p>Thank you very much for reading this far!</p>