Data from App to Spreadsheets

[Panos_42 (DigitalBox Studios)]

Hello hope you are all doing well! So I am trying to send some data (Longitude & Latitude) from my app to google spreadsheets.The correct format that these data must be sent looks like this : 34.65623
When a user inputs long&lat these are being sent to a google spreadsheets file where for some reason they are displayed like this :

Which causes problem as you can imagine, when trying to use these coordinates to display a marker in the app.
I have also formated index 2& 3 to appear as plain text.

Any ideas would be appreciated since I am a beginner with spreadsheets and many functions differ from excel.
Have a great day

[_FTTX (Ali Abo Wardi 0 iraq)]

I sent you a verification message

[dora_paz (Dora)]

Check format. Is number set to automatic ?

[sugarlesscreator]

Set all cell to plain text

//Add this after appendRow

var range = sheet.getRange(2, 1, sheet.getMaxRows(), sheet.getMaxColumns());

    range.setNumberFormat("@");

[Panos_42 (DigitalBox Studios)]

I had it set to plain text , then I tried automatic but the problem remained.

[dora_paz (Dora)]

Do you use a script in order to post data to spreadsheet ?

[Panos_42 (DigitalBox Studios)]

Yes, here it is :

[Panos_42 (DigitalBox Studios)]

I dit it , but the results are the same.

[dora_paz (Dora)]

Try to clear format and see what happens, mark column B and C

[TimAi2 (metricrat)]

Try:

• remove the format instructions from the script
• set locale of spreadsheet to en
• set all columns in sheet to automatic

[Panos_42 (DigitalBox Studios)]

Ok, I tried again with automatic and figured the mistake. Formatting the whole columns led to changing the old info in the wrong way. As I understand I should have formatted the columns to automatic from the beginning. Anyways ,thanks for all the help everyone!

[Panos_42 (DigitalBox Studios)]

So I created a new sheet and formatted column B & C to automatic from the beginning.And still had the same problem. When sending the data from the app like this: 79.68964
7968964 formats it to this : 7.968.964
Also I should mention that when I click again on the formatted cell to check what format it uses it does not have anything selected even if I had set it to automatic from the beginning.

[dora_paz (Dora)]

Go to file → Spreadsheet Settings and change Locale to United States

[Panos_42 (DigitalBox Studios)]

Managed to do it! Thanks!