Strings such as "0050" are entered into Google Sheets as the number 50. Changing the c

Strings of numbers with leading-zeros are truncated when commited about hyou HOT 2 OPEN

google commented on September 1, 2024

Strings of numbers with leading-zeros are truncated when commited

from hyou.

Comments (2)

nya3jp commented on September 1, 2024

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.

from hyou.

nya3jp commented on September 1, 2024

The situation can be different with new Sheets API v4.

from hyou.

Recommend Projects