We have been using Google sheets a fair bit recently as our spreadsheet of choice. The kids can use their phones for data gathering in the field (eg how many keepy uppyies they do) and then we can fire up the tomputers and do some proper data analysis on it. Again using Google sheets.
This has worked well for trivial stuff but the other day I decided to combine Maths, IT and spreadsheets and it didn’t end well.
In maths we have been doing equations, in IT, programming – so name a couple of variables x and y, create a scary looking equation, loop through a load of numbers and print out x and y, copy and paste into Google sheets and draw a nice chart. Well that’s what happened on the macbook, on the Android tablet the Google sheets app appears so completely hobbled that it does not offer the choice to parse a string into multiple columns. And I could find no way to use the more powerful browser version.
I wouldn’t claim to have done an exhaustive search but initial indications are that the app versions of google apps offer only a fraction of the features of the browser versions (bit weird if you ask me – but hey, I’m old school). And you can’t seem to keep the browser version on android devices. As soon as you click anywhere you are launched into Google drive and its game over, shit versions only. As far as I can tell??
If anyone has a solution to this I would be very interested. I would like to use the more powerful browser versions of google apps on an android tablet please.
ps the Excel app has the same limitation as far as I can tell.
Or if you have a suggestions for a better spreadsheet for Android I’m all ears…