The information in this chapter builds upon the information given in Chapter General Differences in Use between and Microsoft Office.

xlsx files created with Microsoft Office 2007 or Microsoft Office 2008 for Mac OS X.This chapter summarizes the differences in use between Calc 2.0 and Microsoft Excel (various versions). Since version 3.0, Calc has been able to read. If all they want to see is your results, then use Portable Document Format (.pdf) - no need to buy any extra software. Of course, you are free to use your old Microsoft Excel spreadsheets, or save your work in Excel format for sending to people who are still locked into Microsoft products. You can access your spreadsheets from any OpenDocument compliant software. This XML based format means you’re not tied in to Calc. Save your spreadsheets in OpenDocument format, the new international standard for office documents. This collaboration feature helps avoid editing conflicts. The spreadsheet owner can then easily integrate the new data with a few clicks. By sharing a spreadsheet other users can easily add their data to the spreadsheet. compare profitability for high / medium / low sales forecasts.Ĭalc’s solver component allows solving optimization problems where the optimum value of a particular spreadsheet cell has to be calculated based on constraints provided in other cells.Įncourage collaborative working on spreadsheets with Calc’s multiple users support.

Scenario Manager allows “what if …” analysis at the touch of a button - e.g. You can be your own spreadsheet expert thanks to templates with built-in functions, allowing you to concentrate on your real work. Styles and Formatting makes it easy to apply flexible cell formatting options, including freely rotating contents, templates, backgrounds, borders, and many more. Wizards guides you through choosing and using a comprehensive range of advanced spreadsheet functions, or download templates from our Extensions repository for ready-made spreadsheet solutions. The Intelligent Sum Button inserts a sum function or a subtotal automatically, depending on context. Natural language formulas let you create formulas using words (e.g. Newcomers find it intuitive and easy to learn professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.Īdvanced DataPilot technology makes it easy to pull in raw data from corporate databases cross-tabulate, summarize, and convert it into meaningful information. Calc is the spreadsheet program you’ve always wanted.

Apache openoffice excel