# Spreadsheet 'Get All Data' crashes app

**URL:** https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533
**Category:** Questions about Thunkable X
**Tags:** spreadsheets
**Created:** [June 21, 2018, 11:05am UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533 "2018-06-21T11:05:17Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![MuckYu](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@MuckYu](https://community.thunkable.com/u/MuckYu)
#### Post date: [June 21, 2018, 11:05am UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533/1 "2018-06-21T11:05:17Z")

</div>

I have now tried multiple spreadsheets with data and empty ones to simply have a button activate the ‘Get All Data’ call. A few seconds after pressing the button the app just crashes.

Earlier today it seemed to work fine for a couple of hours though. Why is this happening?  
I am able to upload data through the app - just not read it.

---

<div class="post-metadata">

### Author: ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 21, 2018, 11:16am UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533/2 "2018-06-21T11:16:40Z")

</div>

It is difficult to name the reason without viewing the application. During the last time you did not change anything in the project? Does this happen on Android?

---

<div class="post-metadata">

### Author: ![MuckYu](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@MuckYu](https://community.thunkable.com/u/MuckYu)
#### Post date: [June 21, 2018, 11:27am UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533/3 "2018-06-21T11:27:13Z")

</div>

I indeed changed some stuff - however. Even when I try and make a completely fresh app - add 1 button and add the call.Spreadsheets1.Get All Data function it just crashes the app.

I assume it’s either the Spreadsheet extension problem or maybe a problem on the other end at cloudstitch. But I am not sure how to fix it. Or is there maybe a log somewhere that I am missing?

And I am using android yes.

---

<div class="post-metadata">

### Author: ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 21, 2018, 11:52am UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533/4 "2018-06-21T11:52:16Z")

</div>

Unfortunately, while Thunkable X for Android is unstable. You added a new component, block or changed the property after debugging the project and this can lead to crash.

To find errors more quickly, I recommend that you use the “adb logcat” debugger and look at logs file.

---

<div class="post-metadata">

### Author: ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [June 21, 2018, 11:26pm UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533/5 "2018-06-21T23:26:03Z")

</div>

Hi @MuckYu,

In my experience this is the main cause of this error:

[http://community.thunkable.com/t/handling-and-in-cloudstitch-data/1879?u=domhnall](http://community.thunkable.com/t/handling-and-in-cloudstitch-data/1879)

---

<div class="post-metadata">

### Author: ![MuckYu](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@MuckYu](https://community.thunkable.com/u/MuckYu)
#### Post date: [June 22, 2018, 10:33am UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533/6 "2018-06-22T10:33:09Z")

</div>

Hi @domhnallohanlon thanks for the suggestion. I went through my blocks and spreadsheet again and it seems that the LAT and LNG from the GPS coordinates are the issues. They are displayed with dots.  
For example: “22.33944”

I tried to use the ‘Replace all text’ block to replace those dots with something else. However it does not seem to accept those. I always get an error such as:

> The operation format as decimal cannot accept the arguments: , [22;33942], [5]  
> Note: You will not see another error reported for 5 seconds.

I tried multiple different characters such as: & A 1 \_ - ? ! …

Any ideas how I could handle this?

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:02pm UTC](https://community.thunkable.com/t/spreadsheet-get-all-data-crashes-app/32533/7 "2024-11-08T12:02:21Z")

</div>


