Like Excel, Calc can handle multiple worksheets, manage data in lists with super-efficient AutoFilters for sorting and filtering your data, and it can create many different types of charts. In terms of raw functionality, it’s a real match for Excel, but without the polish, the content and the hand-holding for beginners. On the other hand, Writer is quite good at handling revisions and author comments, and it now displays them as colour-coded notes in the margin.Ĭalc is the OpenOffice rival to Excel, and it’s a similar story here.

It might work well enough with straightforward documents, but it made a pig’s ear of a more elaborate Word 2007 newsletter layout we tried it on. OpenOffice Calc has an automated function that creates a subtotal for data that resides in any column that has a label. It would also be unwise to rely to heavily on the. A graph showing this sites review totals. And Writer doesn’t even attempt to match Word’s range of document templates or its excellent clip-art collection. Shop for Alera Alera Open Office Desk Series Low File Cabinet Credenza ALELS583020MY.

It does duplicate Word’s excellent Outlining mode up to a point with its nested headings, but the process is far less fluid. To remove the space between the bars, as required for a histogram, double click on the graph to enter edit mode, right click on the bars and choose Object Properties. Writer’s Styles and Formatting and Navigator panels are effective, but look crude. The chart is inserted into the open sheet.

Openoffice calc graph count