Apache OpenOffice vs. Google Sheets

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.

Incentivized

Google Sheets is perfectly suited for collaborative documentation, it's been really easy for us in situations like cost tracking, permission matrix etc, where no complex third party tools needs to be setup! Just sign in with your google account, and start doing effortless work. But keep in mind about it's performance, it's not so suitable for thousands of rows worth of data as it will start to become sluggish.

Incentivized

• 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.

Incentivized

• It is a great way to collaborate in real-time with any member across the organization.
• It easy very easy to create formulas, data validation options, and pivot tables for data analysis.
• It is a great way to see the revision history and changes that other collaborators have made on the document.

• Some people used to Microsoft products can feel it's a little bit old in its style
• I saves documents in its native format, which is incompatible with MS Word or Excel, unless you change that in the preferences tab
• The UI is not very pretty

Incentivized

• Pivot tables are different but could be improved upon; sort, totals, filters
• When entering negative numbers as the first in a formula you need to remember to "+-100+25" instead of "-100+25"
• The power of the internet of course makes it easy to find solution, but the help function is not easily available
• Color coding changes on the cell, but there is not an easy way to click on a cell and use the selected color; like excel

Incentivized

It is a cheap alternative; however, with Microsoft 365 licenses also dropping significantly, we might opt to go in that direction to maintain uniformity.

Incentivized

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.

Incentivized

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.

Incentivized

It can easily handle most uses and functions. It is only for very large datasets or advanced analysis that it either lacks the proper functions or performance begins to slow. Most employees who continue to use competitors' products do so out of preference, familiarity with the user interface, or other surface-level reasons.

Incentivized

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.

Incentivized

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.

Incentivized

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.

Incentivized

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.

Incentivized

We found that it is possible to use Open Office to accomplish everything we need. Some tasks required searching for steps on Google.

Incentivized

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.

Incentivized

Microsoft Excel in terms of singular user continues to be the best one in my opinion, but for collaboration I don't agree in that position, Google Sheets are better. Libre Office and WPS Office unfortunately are far away from the quality of Microsoft Excel and Google Sheets, they are good solutions if you don't want to trust the data on external services, other than that they are not good.

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.

Incentivized

• Moving to OpenOffice will save the company the cost of 500+ of Microsoft Office licenses in our company.
• Because it is cross-platform, we could also save 500+ of Microsoft Windows licenses if we move everyone to Linux.
• On the negative side, the lack of online collaboration and browser support may be an issue when you use clouds like Box, Workboard etc.

Incentivized

• Client outreach; it has helped me make a list of customers to reach out to.
• Accounting; it has made accounting SO much easier and smoother, so I have more time to focus on clients and projects.
• Cost formulas - it's allowed me to make comfortable margins with fair customer pricing by making breakeven formula sheets.

Incentivized