TrustRadius: an HG Insights company

Apache OpenOffice Calc

Score9.1 out of 10

9 Reviews and Ratings

What is Apache OpenOffice Calc?

Calc is the spreadsheet application associated to the open source OpenOffice productivity suite. Developers say professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.

Categories & Use Cases

Affordable spreadsheet software

Use Cases and Deployment Scope

We used open office to analyze general ledger files. Find the outage between the balance for every day. The files were huge and would have around 100K records and hence open office was our go to software. The software helped with formula, vlookup, pivot and other mathematical formulas that were required for making our life easy. Our boss was happy because the software is free of cost and didn't need approval from higher level for reimbursement.

Pros

  • Vloolup
  • Pivot
  • Autofill
  • Mathematical formulas

Cons

  • Not many functions as compared to MS office
  • Can't integrate to some external sources like Google stocks
  • Sometimes have formatting issues

Return on Investment

  • Fast debugging
  • Positive financial impact
  • Can be installed on all workstations becusse it's not paid

Alternatives Considered

Microsoft Excel

Other Software Used

Microsoft 365, Microsoft Excel

The best review that you need read!

Use Cases and Deployment Scope

My company doesn't have the signature for a paid Office Software, because of this I work with this platform opensource. Is good to know that the Apache OpenOffice Calc is much better that the others available to download, the reason behind it is the multiples formulas, charts, dinamic table and graphics available to use. I think that only problem to reported is when you need use the macro, I think that it dont work much better like the Microsoft Excel.

Pros

  • Nice interface
  • Best user experience
  • Constant evolution
  • Better than others opensources

Cons

  • Fuction with Macro
  • Fuction like PowerQuery
  • Multiple users using the same file on the cloud
  • Backup automatic in case of bug or crash

Return on Investment

  • Significant return with saving of signatures
  • All team work with the same app
  • Improvement process and get the routine workflow

Other Software Used

Microsoft 365

A great lightweight software that helps you make calculations and create lists with ease

Use Cases and Deployment Scope

I was looking for a lightweight software for

making calculations and creating lists, and Apache OpenOffice Calc turned out to be the best choice. Not only it requires less storage space, but it has the same commands I could find in Microsoft Excel. In addition, I can export a spreadsheet as a .pdf file, which is great for me, since I use this software mostly for creating and modifying lists. Finally, Apache OpenOffice Calc allows me to open various file types, including .xls. The only defect is the fact that I can export only one spreadsheet as a .pdf file, in case my document consists of two or more spreadsheets.

Pros

  • It allows you to open, view and edit various file types, including .xls
  • You can export any document you're working on to .pdf
  • Its Function Wizard is easy to use

Cons

  • It allows you to export the only current page you're working on to .pdf

Return on Investment

  • The software is free to download and use, but if I invested anything, I think it would be worth its price, and I don't plan to change it anytime soon.