Integer field detected for numbers started with zero

turicas / rows

A common, beautiful interface to tabular data, no matter the format

GNU Lesser General Public License v3.0

869 stars 134 forks source link

Closed pinheiro-bruno closed 5 years ago

pinheiro-bruno commented 5 years ago

Rows is identifying a column as integer when the data on a column is a number that starts with zero.

When a number starts with zero, that number is more likely to be an registration number than an amount.

Let's supose that we are dealing with Brazilian CPF. If a cell contains a CPF started with zero, that would lead to data loss.

09340192213 would be converted to 9340192213

anapaulagomes commented 5 years ago

I'm facing the same issue with rows 0.4.1.

I have the string 00798360000180 and it's turning it into 798360000180.

anapaulagomes commented 5 years ago

Never mind! :)