LibreOffice Calc = Microsoft Office Excel
LibreOffice Calc
Advanced DataPilot technology makes it easy to pull in raw data from corporate databases; cross-tabulate, summarize, and convert it into meaningful information.
Natural language formulas let you create formulas using words (e.g. “sales – costs”).
The Intelligent Sum Button inserts a sum function or a subtotal automatically, depending on context.
Styles and Formatting makes it easy to apply flexible cell formatting options, including freely rotating contents, templates, backgrounds, borders, and many more. You can be your own spreadsheet expert thanks to templates with built-in functions, allowing you to concentrate on your real work.
Scenario Manager allows “what if …” analysis at the touch of a
Microsoft Office Excel 2010
button – e.g. compare profitability for high / medium / low sales forecasts.
CALC’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.
Encourage collaborative working on spreadsheets with CALC’s multiple users support. By sharing a spreadsheet other users can easily add their data to the spreadsheet. The spreadsheet owner can then easily integrate the new data with a few clicks. This collaboration feature helps avoid editing conflicts.
Save your spreadsheets in Open Document format, the new international standard for office documents. This XML based format means you’re not tied in to CALC. You can access your spreadsheets from any Open Document compliant 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. If all they want to see is your results, then use Portable Document Format (.pdf) – no need to buy any extra software. Since version 3.0, CALC has been able to read .xlsx files created with Microsoft Office 2007 – 2010 or Microsoft Office 2008 for Mac OS X. -Newcomers find it intuitive and easy to learn.
