Applications

 

Getting Started with Calc

• Start OpenOffice Calc
• Start OpenOffice Calc using the command line
• Create a new spreadsheet
• Save As…
  • Microsoft Excel Document
  • Export as Portable Document Format (PDF)
  • Text CSV file (.csv)
  • HTML file (.html)
• Print spreadsheet
• Close Spreadsheet
• Exit OpenOffice.org Calc

Watch a screencast about "Find using wildcards in regular expressions"

Working with Spreadsheets

Sheets

• Create a new spreadsheet using the toolbar
• Create a new spreadsheet from a template
• Open a spreadsheet
• Open recent spreadsheets
• Open a spreadsheet using the toolbar
• Open a spreadsheet directly from its file
• Open a Microsoft Excel spreadsheet
• Open a Google spreadsheet
• Download and open a Google spreadsheet
• Save a new spreadsheet
• Save a spreadsheet
• Save a spreadsheet using the toolbar
• Set the default save file format to Microsoft Excel
• Save a spreadsheet as a template
• Set a template as the default spreadsheet template
• Reset the default spreadsheet template
• Change a row's height
• Change a column's width
• Adjust row height to fit contents
• Adjust column width to fit contents
• Insert a column
• Insert a row
• Insert multiple columns
• Insert multiple rows
• Delete columns
• Delete rows
• Select multiple columns
• Select multiple columns that are not connected
• Select multiple rows
• Select multiple rows that are not connected
• Freeze panes
• Select all cells in a sheet
• Protect a sheet with a password
• Page Styles
  • Overview of page style options
  • Filter or select the page styles in the styles and formatting window
  • Assign a page style

Printing

• Define the print range
• Add cells to the print range
• Clear the print range
• Print landscape
• Print portrait
• Print only the current sheet
• Enable page header on printed pages
• Enable page footer on printed pages
• Insert the date and time into the page header
• Insert the filename into the page header
• Insert the page number and page count into the page header
• Change the content of the page header
• Set the background color of the page header
• Set a border for the page header
• Set the shadow for the page header
• Hide the page header
• Print/View the page header
• Format the page into landscape orientation
• Format a page using the page preview
• Insert the filename into the page footer
• Hide cells from printing
• Modify a page style to print column and row headers
• Modify a page style to print grid lines
• Modify a page style to print cell notes

Cells and Formulas

Cells

• Manipulating Cells
  • Select a range of cells using the keyboard
  • Select a range of cells by dragging the mouse
  • Select and add cells to a range using the keyboard
  • Subtract cells in a selected range
  • Insert cells
  • Insert cells using the context menu
  • Delete cells
  • Delete cell contents
  • Delete cells using the context menu
  • Delete cells using the keyboard
  • Cut cells using the toolbar
  • Copy cells using the toolbar
  • Paste cells using the toolbar
  • Move cells
  • Move cells using the drag and drop method
  • Move cells using the toolbar
  • Sort data with column headings in ascending order
  • Sort data in ascending order using the toolbar
  • Sort data with column headings in descending order
  • Sort data in descending order using the toolbar
  • Undo actions
  • Undo actions using the toolbar
  • Redo actions
  • Redo actions using the toolbar
  • Protect a cell against unauthorized changes
• Formatting Cells and Cell content
  • Format cell alignment center
  • Format cell alignment justified
  • Format cell alignment left
  • Format cell alignment right
  • Format cell alignment top
  • Format cell alignment vertically in the middle
  • Format cell alignment bottom
  • Align the text in cells in an angle
  • Align the text in cells vertically
  • Stack the text in cells vertically
  • Shrink text to fit in cells
  • Change the font of text in cells
  • Change the font size of text in cells
  • Change the font size of selected text in cells
  • Format the text in cells to bold
  • Italicize text in cells
  • Underline text in cells
  • Change the color of text in cells
  • Set the font color of text for rows and columns
  • Add fill colors into cells
  • Add fill colors into cells using the toolbar
  • Format cells to default
  • Format cell numbers into currency figures
  • Format cell numbers into currency figures using the toolbar
  • Format cell numbers into percent values
  • Format cell numbers into percent values using the toolbar
  • Format cell numbers into fractions
  • Format percent/currency/fraction numbers into standard numbers
  • Format percent/currency/fraction numbers into standard numbers using the toolbar
  • Format numbers in cells into boolean values and back
  • Format dates in cells into another date format
  • Format numbers in cells into scientific notation
  • Increase the decimal places in numbers using the toolbar
  • Decrease the decimal places in numbers using the toolbar
  • Format cell time values to display time duration
  • Format cell time values to display the time of day
  • Place borders in cells
  • Place borders in cells using toolbar
  • Change the line color of cell borders
  • Change the line style of cell borders
  • Add shadows to cell borders
  • Edit cell values
  • Merge cells
  • Wrap text in a cell
  • Wrap text in a cell with hyphenation
  • Fill cells with character values
  • Fill cells with date values
  • Fill cells with numeric values
  • Define increment of numeric values in cells
• Using Cell Styles
  • Open the styles and formatting window
  • Open the styles and formatting window using the toolbar
  • Close the styles and formatting window
  • Filter the different styles in the styles and formatting window
  • Overview of cell style options
  • Format cells by applying a cell style
  • Apply styles to cells using the toolbar
  • Assign styles to cells using the fill format mode
  • Apply a cell style using the styles and formatting window
  • Use the fill format mode to assign a style
  • Create cell styles from selected cells
  • Create a new style using the drag and drop method
  • Link styles using the style organizer
  • Set the next style using the style organizer
  • Update the formatting of a style and apply it
• Formulas and Cell references
  • Enter formulas into cells
  • Enter a cell reference
  • Enter cell references across multiple sheets
  • Enter cell references across multiple sheets using the toolbar
  • Insert name reference for a cell
  • Delete name reference for a cell
  • Insert a name reference into a formula
  • Insert absolute reference for a cell
  • Fill cells with formulas that have name references
  • Fill cells with formulas that have relative references
  • Enter the sum function
  • Enter the sum function using the keyboard
  • Enter the sum function using the wizard

Cell Notes

• Insert a note attached to a cell
• Permanently display a note attached to a cell
• Display the note of one cell
• Enable help tips and notes

Sheets

• Insert a new sheet
• Copy a sheet
• Move a sheet
• Move a sheet to a new document
• Move a sheet using the mouse
• Rename sheet
• Remove sheet
• Format cells or sheets using autoformat

Charts

• Insert an area chart
• Insert a bar chart
• Insert a line chart
• Insert a net chart
• Insert a pie chart
• Change a chart's type
• Change a chart's variant
• Copy and paste a chart
• Cut a chart
• Paste a chart
• Resize a chart
• Move a chart
• Enter the edit mode of a chart
• Enter the edit mode of a chart using the context menu
• Edit the chart area
• Change the legend's position
• Format the chart title
• Change symbol size in a line chart
• Insert an object name for a chart

Page Previews

• Preview a page in full screen
• Go to the first or last page while at the page preview
• Go to the next or previous pages while at the page preview
• Zoom-in at the page preview
• Zoom-out at the page preview

Customizing OpenOffice.org Calc

Options

• Print only the selected sheets
• Enable help tips
• Enable the first character capitalization auto correct feature
• Disable the first character capitalization auto correct feature
• Enable the auto correction feature for two initial capital characters
• Disable the auto correction feature for two initial capital characters
• Set memory options to improve application performance and responsiveness
• Enable and choose a Java Runtime Environment for OpenOffice.org
• Disable Java Runtime Environment for OpenOffice.org
• Edit the author field value
• Display the gallery
• Display the media player

Toolbars

• View the formula toolbar
• Display the formula toolbar
• Hide the formula toolbar
• View the status bar
• Hide the status bar
• Adjust the horizontal scrollbar
• Using Toolbars
  • Detach toolbar window
  • Dock toolbar window on any border
  • Dock toolbar window at recent position
  • Resize toolbar window
  • Access the excess buttons in the toolbar
  • Hide a toolbar button
  • Hide a toolbar button using the customize dialog window
  • View hidden toolbar buttons
  • View hidden toolbar buttons using the customize dialog window
  • Change a button's position in the toolbar
  • View toolbar buttons as icons only
  • View toolbar buttons as text only
  • View toolbar buttons as text and icons
  • Reset toolbar buttons to default values
  • Access the extra buttons in the toolbar (with bug report)
  • Save toolbar changes to a document or template (with bug report)

OpenOffice.org™ is a trademark of OpenOffice.org.