Spreadsheets are a fundamentally important tool—the original "killer app" for personal computers such as cellphones, and the best way that has been found so far to put computational power in the hands of end-users. Last I checked, there was no spreadsheet in F-Droid, largely because it's a relatively small ecosystem, and most Android users still aren't using F-Droid. Instead they are subjected to the outrageously abusive apps that fill the Play Store, as described for example in https://news.ycombinator.com/item?id=45411897. And many Android phones ship with non-uninstallable malware and shovelware. Backing up an Android phone without a Google account—indeed, even activating an Android phone without a Goolge account—is challenging. From my point of view, these are imperfections.
It's nice to know that you use spreadsheets all the time.
I use them rarely, and often end up regretting that I didn't write a real program instead. And I'd definitely never see myself using one on a phone; it's too painful to type, and the screen is usually too small.
I'd guess that maybe one percent of mobile phone users have spreadsheets of any kind installed, or would want them. Maybe.
What I'm getting at here is that you seem to have a pretty skewed idea of "fundamentally important".
Admittedly an awful lot of mobile users do have a lot of game and eye candy apps that have no F-Droid counterparts. And some users have professional apps that also don't have F-Droid counterparts. But spreadsheets aren't the center of the Universe.
As I showed in https://news.ycombinator.com/item?id=45413633, which I hadn't posted when you posted your comment, about 10–25% of mobile phone users have the Google Sheets app installed, because it has over a billion downloads. So it seems like your atypical personal experience is leading you into orders-of-magnitude errors.
I also use spreadsheets rarely, most recently three weeks ago, and often end up regretting it, but I do occasionally find them very valuable. I would find them even more valuable if I didn't know more powerful programming languages, which presumably is what you are alluding to with "write a real program".
I agree that cellphone screen input methods are clumsy. On the other hand, I've written probably ten thousand words of prose on this one, plus a fair bit of Python, Lua, and C, so a few spreadsheet formulas would hardly be an obstacle.
That's the download count from the Google Play Store. I don't think it counts preinstalls. If it's preinstalled on many phones, the number of Google Sheets users could be much larger than my number suggests.
> Spreadsheets are a fundamentally important tool—the original "killer app" for personal computers such as cellphones
I do not agree with your supposition. Like the parent using the G1 as I did (and still have it), never used a spreadsheet app on any of my many, many phones both personal and work. I am/was a systems engineer by trade.
> Last I checked, there was no spreadsheet in F-Droid
The most popular viewer is the LibreOffice one[1], which can handle ODS and XLS (amongst many others) formats. You may have meant editing/creating which I agree they're not around. See item (1) above though.
> largely because it's a relatively small ecosystem, and most Android users still aren't using F-Droid
Or possibly, a large number of users simply do not need or use generic spreadsheet apps on their mobile devices, which is why I disagree with your opening statement as I am a direct counterexample.
I think they just got carried away with the term "personal computers such as cellphones". I believe they were referencing the common recognition of VisiCalc as one of the first "killer apps" for personal computers.
I'm sorry my comment was so unclear. I'll try to explain in more detail.
1. Cellphones are a kind of personal computer.
2. Numerical computation is something that computers, personal or otherwise, are very good at. Conservatively, your cellphone is ten orders of magnitude faster (ten billion times faster) than you are at tasks like averaging a set of numbers.
3. The spreadsheet user interface is expressive enough for many numerical computations† that are impractical to carry out with more limited user interfaces such as pocket calculators, but it is simple enough to understand that large masses of people can take advantage of that expressivity. (The popularity of VisiCalc on early personal computers such as the Apple ][ is one piece of evidence for this.) It is the "low-code development platform" that inspired all the current no-code and low-code platforms.
4. Such numerical computations are so commonplace in many people's lives that they do them on their cellphones, despite the small display and lack of a keyboard; one reason is that many people have cellphones as their only programmable computers. When they do such complex numerical calculations on their cellphones, they often use spreadsheets to do them.
5. Therefore, we should regard the availability of spreadsheets as a central indicator for the viability of a computer software ecosystem, even on cellphones.
I think all of these claims are obviously correct, stipulating the ones before them, except for #4. As evidence for #4, https://www.youtube.com/watch?v=RCpJ441g-Y4 shows that the Google Sheets app for Android was at the time #7 in their "productivity" category with 793000 ratings and 4.8 stars. https://play.google.com/store/apps/details?id=com.google.and... says that it has been downloaded more than a billion times and has 1.27 million ratings. The fact that people exist who do not use their cellphones for spreadsheets does not constitute evidence against this claim.
What I believe is happening, to elaborate a bit more, is that F-Droid users who need numerical computation that goes beyond what calculator apps can do are mostly just using the Google Sheets app. The radical fringe of F-Droid users like me who do not have Google accounts often make do with Termux programs such as Python, LuaJIT, PARI/GP, bc, Racket, or the C compiler, even though for many purposes a spreadsheet would be much more convenient.
______
† Spreadsheets are also used as simple databases, in fact more frequently than they are used for numerical calculations, but numerical calculations alone are a strong enough argument for my purposes here, and F-Droid does have a number of adequate simple database apps.
I think this just fundamentally does not track, because the vast, vast majority of phone users are not regularly using a spreadsheet app.
When we imagine phone applications, we think messaging, social media, web browsing, and email. That's 99% of stuff people do on their phone.
The statistic of "how many people have this app installed" is fundamentally flawed. Why? Most apps are worthless. Throwaways, single purpose.
Its entirely possible, and dare I say extremely likely, that people install (or it came installed!) Google sheets for one document that was shared one time, then forgot about it.
It seems improbable to me that photography, video recording, video games, phone calls, digital payments, video calls, tethering, and charging the battery would all be outside of that 99%. Possibly you don't know very much about how the vast, vast majority of phone users use their phones, for example because your friends and family aren't typical of Indonesians, Nigerians, Indians, and Chinese people.
Or because you aren't especially interested in whether what you're saying is true or false, since it is—to me at least—obviously wrong. And you're surely somewhat aware of how atypical your circle of friends is among, for example, either Malaysians or Texans, and probably both.
None of those are spreadsheets... And a lot of those are built into the phone. Like phone calls, digital payments, video, photography.
I just think using spreadsheets as a measure of an application repository for phones is obviously stupid.
Please bear in mind that things like the playstore aren't android phone stores. They're Android stores. Meaning, they also target tablets and chromebooks.
Now, I'm sure Google sheets on an android tablet is perfectly mediocre. But I can assure you, on a phone, it is downright painful.
