Strings of numbers with leading-zeros are truncated when commited

[craftycorvid]

Strings such as "0050" are entered into Google Sheets as the number 50. Changing the cell format to Plain Text in Sheets and then resubmitting via hyou does not fix this issue, you end up with a string "50".

[nya3jp]

Hmm, this conversion seems happening in gdata api server. I looked at the request setting "0010" to a cell, but the value was not converted to 10 at least here:

<ns0:feed xmlns:ns0="http://www.w3.org/2005/Atom" xmlns:ns1="http://schemas.google.com/gdata/batch" xmlns:ns2="http://schemas.google.com/spreadsheets/2006">
  <ns0:id>https://spreadsheets.google.com/feeds/cells/a/b/private/full</ns0:id>
  <ns0:link href="https://spreadsheets.google.com/feeds/cells/a/b/private/full/batch" rel="edit" />
  <ns0:entry>
    <ns1:operation type="update" />
    <ns2:cell col="1" inputValue="0010" row="1" />
    <ns0:id>https://spreadsheets.google.com/feeds/cells/a/b/private/full/R1C1</ns0:id>
    <ns1:id>0</ns1:id>
  </ns0:entry>
</ns0:feed>

So gdata api server should be doing conversion, but I'm not sure if it's intentional or a bug.

[nya3jp]

The situation can be different with new Sheets API v4.