Apache OpenOffice is an open source office application, and is available for a range of operating systems including Linux, Mac and Windows. This makes it attractive for a small business that uses a mix of operating systems. The program includes a word processor, a spreadsheet, a presentations tool, database manager and a drawing tool.
The spreadsheet component of OpenOffice is called Calc. Like Google Sheet, it provides most of the tools that you would need in a spreadsheet program including charts, a PivotTable tool and macros. OpenOffice is popular with organizations seeking quality small business software with built-in Microsoft compatibility but without the high price of licensing actual Microsoft products.
OpenOffice is a downloadable program that you install on your local computer, and there is also Apache OpenOffice Portable—an app that you can load onto a Flash drive to take it with you.
Because Calc runs locally, you don't need an Internet connection to access the spreadsheet. Calc supports up to 1,024 columns of data and 1,048,576 rows, it can export worksheets as .pdf files, save to the Excel 2003 format; and it can open the newer .xlsx format files.
While charts in Calc don't have the look of Excel's, more sophisticated formatting options -- including plotting charts using two axes—are available for them than for the other applications in this roundup.