Strips leading zeroes from text that looks like a number in a google sheets source

[dobesv]

I have a google sheet that has a column containing identifiers that happen to numeric most of the time, but some of the identifiers have leading zeroes or letters. When I load this into google sheets, even though the numbers have a backtick in google sheets to preserve leading zeroes, in redash it strips them.

A summary of the issue and the browser/OS environment in which it occurs.

Steps to Reproduce

1. Setup Google Sheets integration
2. Create a google sheet
3. Enter values like:

ID	Value
'0001	4
'0002	3
A009	9
BBBB	11

Note the single quote tells sheets to treat the number as a string

4. Import the sheet into redash
5. Bug: strings that look like numbers are truncated even with the leading quote; fields with letters initially show up as zero. You can change the visualization to display the column as text, but that will not restore the leading zeroes.

Screenshot of sheet I tested with:

Screenshot of results inside Redash:

Technical details:

Redash Version: 10.1.0 (2589bef1)