Printing Rows or Columns on Every PageIf you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page.
As an example, If you want to print the top two rows of the sheet as well as the first column (A)on all pages, do the following:
- Choose Format - Print Ranges - Edit. The Edit Print Ranges dialog appears.
- Click the icon at the far right of the Rows to repeat area.The dialog shrinks so that you can see more of the sheet.
- Select the first two rows and, for this example, click cell A1 and drag to A2.In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows to repeat.
- Click the icon at the far right of the Rows to repeat area. The dialog is restored again.
- If you also want column A as a column to repeat, click the icon at the far right of the Columns to repeat area.
- Click column A (not in the column header).
- Click the icon again at the far right of the Columns to repeat area.
|Rows to repeat are rows from the sheet. You can define headers and footers to be printed on each print page independently of this in Format - Page.|
The all-purpose spreadsheetCALC is the spreadsheet program you've always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.
Advanced DataPilot technology makes it easy to pull in raw data from corporate databases; cross-tabulate, summarise, 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.
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.
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 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 OpenDocument 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 OpenDocument 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 or Microsoft Office 2008 for Mac OS X.
Screenshot of OpenOffice.org Calc
|Developer(s)||Oracle Corporation in association with the Open Source community|
|Stable release||3.3 / January 25, 2011; 2 months ago (2011-01-25)|
|License||GNU Lesser General Public License|
Calc is similar to Microsoft Excel, with a roughly equivalent range of features. Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. It provides a number of features not present in Excel, including a system that automatically defines series for graphing based on the layout of the user's data. Calc is also capable of writing spreadsheets directly as PDF files.
The default file format for OpenOffice.org Calc (versions 2.x and 3.x) can be set to either Microsoft Excel's native file format or the international standard OpenDocument Format (ODF) ISO/IEC 26300:2006. Calc also supports a wide range of other file formats, for both opening and saving files, such as CSV, HTML, SXC, DBF, DIF, UOF, SLK, SDC and others.
As with the entire OpenOffice.org suite, Calc can be used across a variety of platforms, including Mac OS X, Microsoft Windows, Linux, FreeBSD and Solaris. Available under the GNU Lesser General Public License, Calc is free software.
 Special capabilitiesCapabilities of Calc include:
- Open source software
- Available on many platforms, including Windows, MacOS, Linux, Unix, etc.
- Ability to read/write OpenDocument (ODF), Excel (XLS), CSV, and several other formats.
- Support for a large number of functions, including those for imaginary numbers, as well as financial and statistical functions.
- Additional capabilities are easily added as extensions, which includes such capabilities as being able to call functions from the R statistical package, calculations based upon textual representations of number, database access, and use of external BI tools
 Missing featuresIn some cases, Calc lacks a GUI wizard to access certain advanced features associated with competing products, such as statistical capabilities like error bar support on graphs, and polynomial regression analysis. However, many of these calculations can be performed by manually entering the functions and relationships, plus a few macros. Another FOSS application called Gnumeric provides easier access to these statistical analysis features by presenting them to users with a wizard.
 DataPilotThe feature DataPilot provides similar functionality to that of Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis. Unlike Excel, however, OpenOffice.org does not support Pivot charts.
With OpenOffice.org 2.0, the DataPilot feature has added support of Page fields - you can sort data on their fields.
- When editing a date, the date is displayed in the user's locale default date format irrespective of the user's system setting. Users can enter ISO 8601 dates, but may only edit them in another format.
 In comparison to Microsoft ExcelSee also the Comparison of spreadsheets article.
|This article's tone or style may not be appropriate for Wikipedia. Specific concerns may be found on the talk page. See Wikipedia's guide to writing better articles for suggestions. (April 2011)|
- An advantage of Calc over Excel is that it directly uses metrics when defining the width of a cell or column, or the height of a cell or row. This number can be expressed in either cm, mm, inches, picas or points.
- Calc also has some additional functions, like EASTERSUNDAY, which works most years. Other ones, like DAYS and YEARS (which calculate date differences) can be replaced by Excel's DATEDIF function.
- Calc fully supports the conditional formatting of Excel 97-2003, but it supports neither the changes implemented from the 2007 version of Microsoft's software, nor the "data bars" that can be associated to specific cells.
- Unlike Microsoft's product (even Excel 2010), Calc offers a more sophisticated function wizard, that lets the user navigate through nested formulas. This feature is particularly useful when working with some complex sheets, to debug nested functions.
- It is possible in Calc to undo the "Delete Sheet" operation, which Excel is incapable of.
- Although Calc offers a feature similar to Excel's PivotTables (called DataPilot), it doesn't have an equivalent for PivotCharts, which somewhat limits the possibility to share spreadsheets between these applications when used for data analysis.
- OpenOffice also allows users to save files in the .dbf (the old dBASE database file) format, support for which has been removed from Excel 2007. Although the .dbf is a legacy format, some programs (e.g. ESRI's ArcGIS) use the .dbf as the basis for handling all spreadsheet data. OpenOffice allows you to directly edit and save changes to GIS spreadsheet files, while Excel only offers import of .dbf files to be saved in a different format.
- Calc does not have any add-ins for real-time stock quotes. However, live streaming financial data can be provided with two commercial packages for Mathematica, CalcLink and DDFLink.
- Calc did not have the "Solver" add-in until version 3.0, while Excel has had this since Office 97 as an add-in or perhaps earlier.
- In relation to macros, Calc's BASIC functions are basically like those of its competitor, although it lacks a few of them, like InStrRev (which reversely looks up a substring within a string). Calc's object model however, is rather different from Excel's, and it doesn't support the easy-editing feature of Microsoft's product, via the object.property or object.procedure (object.method) "smart" characteristic (inherited from the Visual Studio programming environment).
- Calc doesn't have XLM macros that are embedded in Excel.
- Calc supports use of regular expressions in find and replace operations, whereas Excel only supports limited wildcard searching.
- Calc supports use of complex numbers which Excel doesn't.
 See also
- ^ File formats OOo can open, December 1, 2008
- ^ Issue 5556: Date format is not consistent, for ISO 8601 input a corresponding cell format should be applied and input line should match
- ^ http://office.microsoft.com/en-us/help/HA011609811033.aspx
- ^ CalcLink Lauschke Consulting
- ^ DDFLink Lauschke Consulting
- ^ "Installing Microsoft Excel's Solver". University of South Carolina. http://hadm.sph.sc.edu/courses/J716/SolverInstall.html.
 External links
|Wikimedia Commons has media related to: OpenOffice.org Calc|
- Calc information page
- OpenOffice.org Spreadsheet Project
- Spreadsheet FAQ
- Official OpenOffice Documentation Wiki. Select any of the Calc sections
- Free lessons for OpenOffice.org Calc
- CalcLink (a bi-directional link between Calc and Mathematica)
- OpenOffice.org Calc
- openoffice calc - Google Search
- Calc - OpenOffice.org Wiki
- Spreadsheet Project
- OpenOffice.org Calc - Wikipedia, the free encyclopedia
- Tutorials For OpenOffice: CALC (spreadsheets) Category
- Free Calc 1.1 Tutorial at GCFLearnFree.org
- OpenOffice Calc - OpenOffice Calc Spreadsheet Tutorials
- OpenOffice.org Calc In Pictures
- openoffice calc - Google Search
- OpenOffice.org - The Free and Open Productivity Suite