LIBREOFFICE CALC
LibreOffice Calc is the spreadsheet component of the LibreOffice software package.
After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix a large number of defects in formula calculations involving external references, and to boost data caching performance especially when referencing large data ranges.
Additionally Calc now supports 1 million rows in a spreadsheet with macro references to each cell.
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Calc is also capable of saving spreadsheets asPDF files.
After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix a large number of defects in formula calculations involving external references, and to boost data caching performance especially when referencing large data ranges.
Additionally Calc now supports 1 million rows in a spreadsheet with macro references to each cell.
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Calc is also capable of saving spreadsheets asPDF files.
Collaborate with others
You can do collaborative work on spreadsheets, thanks to Calc's multiple-user support. You can share a spreadsheet, so that other users can easily add their data to it. The spreadsheet owner can then easily integrate the new data, in just a few clicks. This collaboration feature helps avoid editing conflicts.
The spreadsheet for everyoneCalc is the spreadsheet program you've always needed. Newcomers find it intuitive and easy to learn. Professional data miners and number crunchers will appreciate the comprehensive range of advanced functions. Wizards can guide you through choosing and using a comprehensive range of advanced spreadsheet functions. Or you can download templates from the LibreOffice template repository, for ready-made spreadsheet solutions.
|
Excel at Excel®While Calc can save spreadsheets in its native, OpenDocument Format (.ods), you can also open Microsoft Excel spreadsheets, and can also save your work in Excel format for sending to people still locked into Microsoft products. If you only need to make your data readable, but on a wide range of devices and platforms, you can export to Portable Document Format (.pdf). Calc can read .xlsx files created with Microsoft Office 2007 for Windows or Microsoft Office 2008 for Mac OS X.
|
professional features you needStyles and direct formatting makes it easy to apply flexible cell formatting options, including freely-rotating contents, templates, backgrounds, borders and much more. Become a spreadsheet expert, using templates with built-in functions, so that you can re-use a pre-prepared sheet and just focus on the immediate work. *
The Scenario Manager allows "what if ..." analysis at the touch of a button. For instance, you can compare profitability for high, medium and low sales forecasts. Calc's solver component lets you solve optimization problems in which the optimum value of a particular spreadsheet cell has to be calculated based on constraints provided in other cells. |
Unleash your dataAdvanced DataPilot technology makes it easy to pull-in raw data from corporate databases, and then cross-tabulate, summarise, and convert it into meaningful information. Real time data streams can now be integrated in sheets and reports, and factored in calculations.
|