Search My Blog

Saturday, April 16, 2011 Calc Help, Printing Rows or Columns on Every Page

I need to use this feature often and often forget how to do this simple task. So, here it is directly from Calc Help...


Printing Rows or Columns on Every Page

If 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:
  1. Choose Format - Print Ranges - Edit. The Edit Print Ranges dialog appears.
  2. 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.
  3. 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.
  4. Click the icon at the far right of the Rows to repeat area. The dialog is restored again.
  5. If you also want column A as a column to repeat, click the icon at the far right of the Columns to repeat area.
  6. Click column A (not in the column header).
  7. 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 spreadsheet

CALC 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.
screen dump           of Calc 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.

Read More.... Calc

From Wikipedia, the free encyclopedia
Jump to: navigation, search Calc
OOoCalc.png Calc.png
Screenshot of 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)
Development status Active
Operating system Cross-platform
Type Spreadsheet
License GNU Lesser General Public License
OOoCalc22.png Calc running on Mac OS X Calc is the spreadsheet component of the software package.
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 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.[1]
As with the entire 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.



[edit] Special capabilities

Capabilities 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

[edit] Missing features

In 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.

[edit] DataPilot

The 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, does not support Pivot charts.
With 2.0, the DataPilot feature has added support of Page fields - you can sort data on their fields.

[edit] Criticism

  • 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.[2]

[edit] In comparison to Microsoft Excel

See also the Comparison of spreadsheets article.
  • 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.[3]
  • 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[4] and DDFLink.[5]
  • Calc did not have the "Solver" add-in until version 3.0, while Excel has had this since Office 97 as an add-in[6] 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 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.

[edit] See also

[edit] References

[edit] External links

Go there... Calc
openoffice calc - Google Search
Calc - Wiki
Spreadsheet Project Calc - Wikipedia, the free encyclopedia
Tutorials For OpenOffice: CALC (spreadsheets) Category
Free Calc 1.1 Tutorial at
OpenOffice Calc - OpenOffice Calc Spreadsheet Tutorials Calc In Pictures
openoffice calc - Google Search - The Free and Open Productivity Suite

No comments: