Text Columns having numeric values are not exporting as Text

Tags: #<Tag:0x00007f8b28d9e5a8>
#1

Hi Team,

We are using the HandsOnTable Pro version and we have implemented export functionality using the exportFile plugin. In our table we have one Text column which have numeric values for example:

123987456212
012345678912
123456789012
983645838212

We have set type of this Column as Text. But while exporting the data as CSV file this column data gets exported as Numeric values as per the below:

1.23987E+11
12345678912
1.23457E+11
9.83646E+11

In that case we are losing the trailing 0 on each values. Could you please help us to get this column as Text in export functionality?

Thanks!

#2

Hi @ketan.navadiya

Here https://jsfiddle.net/AMBudnik/c2ywp5hs/ I’ve made a demo with your data. When I export it, it looks the same

08

You might check if the tool that you’re using to open that file changed formatting.

#3

Hi Aleksandra,

Thanks for the quick response.
But if you check second number have 0 as first digit ( 012345678912). But in export 0 is missing. That is the issue we are facing. I am using the Microsoft excel to open downloaded file & it is showing same format as i have shared with you.

Thanks!

#4

Aaa, yes - here’s the demo https://jsfiddle.net/AMBudnik/wb04kv3p/
If those values are text they need to have quotes

#5

Hi Aleksandra,

Thanks!
It’s working when I am opening file in notepad.
But If I open the file in Excel it is showing in numeric format only and without including the 0 as first digit. Is there any way we can achieve this in excel file as well?

#6

It means that you need to check the formatting. Notepas does not format the data.

#7

Even I format it to Text in Excel file, I am not able to see the trailing 0 in the numbers.
It compliantly losing the trailing 0.

#8

I do not have Excel on my device but it looks like you can enable leading zeros while using this tutorial https://www.techrepublic.com/blog/microsoft-office/entering-leading-zeroes-in-excel/

#9

Thanks Aleksandra!!
It’s working for me.

#10

Great. Thank you for the update.

#11