Apache OpenOffice is a free open source office suite that includes six applications: Writer (word processor), Calc (spreadsheets), Impress (presentations), Draw (diagramming and graphics), Base (database), and Math (formulas).
N/A
Google Sheets
Score 8.8 out of 10
N/A
Google Sheets is the spreadsheet app available on Google Workspace, or standalone, with a free plan for personal use and accessible via mobile apps for iOS and Android.
In my opinion, Apache OpenOffice is best suited for writing, editing and proofreading texts in any language. You can also download additional language packages that really take up little space in your PC's storage. Of course, Apache OpenOffice is comprehensive of spreadsheet-/drawing-/database-related softwares and so on, but I primarily use it for writing and editing my own texts. I don't see any scenarios where it is less appropriate, at least so far.
Google Sheets is a great tool mostly for people in the finance department such as accountants who have to analyze hundreds of transactions. The software makes it easy to organize data and handle some analysis. Also, when it comes to data presentation, Google Sheets offers some of the best features. However, this is not to sat people outside the finance docket cannot benefit from this software. It is a great tool to have when handling data.
OpenOffice is ideal to have as an application on your PC versus utilizing an online word archive application like Google Docs.
OpenOffice can deal with an assortment of document types like [.doc, .rtf, .xml] , making it a fundamental apparatus for the individuals who don't approach Microsoft Word.
OpenOffice is a more profound programming than Word and is more open. I know, openness for a record composing programming, I know. In any case, OpenOffice takes into account rapidly evolving edges, typeface, size, and so forth, and I think shows improvement over Word, and in a simpler arrangement.
OpenOffice can deal with bookkeeping pages, essential information bases, introductions, and fundamental drawings. It handles the entirety of the typical Microsoft Office instruments inside one application.
Shifting to Sheets after years and years of Excel is like learning to crawl after I've been running for years. Some sort of translator document. Such as if you use XYZ in Excel, the same function can be found here in Sheets
Functionality shuts down after 5K or so lines are used. I work in finance. We have hundreds of thousands of transactions we need to analyze.
If Big Query is the answer to large amounts of data, it needs to be as easy to use as Sheets is.
It is a cheap alternative; however, with Microsoft 365 licenses also dropping significantly, we might opt to go in that direction to maintain uniformity.
I am not involved in the purchase/selection process, but my organization is a Google shop, and Sheets meets most of our spreadsheet needs and works seamlessly with our other tools. I don't anticipate our switching anytime soon.
It's good overall, just the UI it's not the prettiest, feels like an older version of MS office, but gets the job done. Once get the hang of it it's easy to use, besides it has great documentation on how to use it and there are many forums that discuss many related topics.
Overall the formula functions could improve but there's workarounds for them. Utilzing different formulas or approaches for building out accounting schedules. While collebrating with multiple team members and different departments being able to go in and see where others are on the sheets is helpful. Google Sheets overall is a great product
Like most Google products, Google Sheets rarely has outages or slowness, and when it does, connection is always momentarily restored. I can't recall a time when I've been unable to access Google Sheets but able to access other sites just fine. That said, errors aren't uncommon when handling large data volume. You know what they say about using spreadsheets as databases, but sometimes it's just the most convenient option, especially for smaller or one-off projects, and not being able to store large amounts of data hampers our ability to move quickly with scrappy prototypes or full solutions. It would be great if we could better integrate our data manipulation (Apps Script) with big data in the sheet.
Again, Google Sheets is no exception to Google's general high speed and reliability, but load times can be slow for larger amounts of data. I've used Sheets with Zapier and have used the Python API, and speed has never been an issue.
Is there really support? There is a user forum but I do not see much developer input. Support options are limited. The most recent (Sept 2019) version of the product seems to have issues operating under Windows 10, yet there are few recent comments in the community forum, most comments are regarding older versions.
I have never contacted Google Sheets support, but Google Sheets makes it very easy to report an issue or suggest a feature from Sheets itself (Help > Help Sheets improve), and I've had mostly good experiences with support for other Google products.
The big benefits that OpenOffice gives us is the flexibility, the cost, and the ease of licensing. We do have some Office users, and we keep licenses for them. We looked at Office 365, and that was a good way to work for some people, but the requirement to be constantly connected to the internet was difficult for some of our field staff. Same with Google Drive, though that was more popular than Office 365. We don't do a ton of collaborative work, so the lack of online collaboration wasn't a dealbreaker for us, though I can see how 365 or Google Drive would be much more helpful for a team of people working on a single document.
Microsoft Excel and Numbers on Mac. Used the first reiteration of the Windows 365 and was terrible. It stacks up well against excel due to power of two other Google products 1) Google search and 2) YouTube. If you cannot find an article or video to help you might be disappointed but keep looking.
Google Sheets works very well with multiple users. It's convenient to see in real-time who is collaborating in a sheet, down to the specific cell that they're viewing/editing. Linking Sheets across departments is convenient with the IMPORTRANGE function.
