Open Office

 OpenOffice and StarWriter

OpenOffice is an office software package. It is used to create documents, perform calculations, make charts, and prepare presentations. It is open-source software and can be used free of charge.It works on Windows, Linux, and other supported operating systems.OpenOffice is available for Linux. It can be installed on Linux to perform office-related tasks. It allows users to create documents, spreadsheets, and presentations. Its open-source nature makes it suitable for the open-source Linux environment.

1. OpenOffice developed from a software package called StarOffice.
2. StarOffice was developed by Sun Microsystems.
3. In 2000, Sun Microsystems made its source code open-source.
4. In 2002, the first official version of OpenOffice.org was released.
5. In 2011, the OpenOffice.org project was transferred to the Apache Software Foundation.

 Main Software Applications of OpenOffice

Software	Use
Writer	To create letters, applications, and documents
Calc	To perform calculations and create spreadsheets and charts
Impress	To create slide presentations
Draw	To create drawings and diagrams
Base	To create and manage databases
Math	To write mathematical formulas

Word Processing

Word processing is the process of creating, editing, formatting, and printing text documents using a computer.

Examples: Letters, applications, reports, and question papers.

StarWriter

StarWriter was the old word-processing software of StarOffice. Its modern equivalent in OpenOffice is Writer. It is used to create and edit text documents.

Main Features of Word Processing

1. Typing and editing text.
2. Cutting, copying, and pasting text.
3. Changing font, font size, and font colour.
4. Making text bold, italic, and underlined.
5. Changing page size and margins.
6. Inserting tables and pictures.
7. Checking spelling.
8. Saving and printing documents.

Starting StarWriter / Writer

1. Open the Applications menu.
2. Select the Office or related software category.
3. Click OpenOffice Writer.

Main Elements of the Writer Window

1. Title Bar: Displays the document name.
2. Menu Bar: Contains menus such as File, Edit, View, and Insert.
3. Toolbar: Contains buttons for common tasks.
4. Ruler: Helps set margins and indents.
5. Document Area: The area where text is typed.
6. Status Bar: Displays page numbers and other information.
7. Scroll Bar: Helps move up and down through the document.

Working in Writer

Writer is used to type text, edit content, format documents, insert pictures, save files, and print documents.

 Creating and Saving a New Document

1. Select File → New → Text Document.
2. Type the required text.
3. Click File → Save.
4. Choose the file name and location.
5. Click Save.

Shortcuts: New Document — Ctrl + N, Save — Ctrl + S

Opening an Existing Document

1. Click File → Open.
2. Select the document location.
3. Choose the file.
4. Click Open.

Shortcut: Ctrl + O

Formatting a Document

Formatting means changing the appearance of text and pages in a document.

Main formatting tasks:

• Changing font and font size.
• Applying Bold, Italic, and Underline.
• Changing text colour.
• Aligning text Left, Centre, Right, or Justified.
• Setting line spacing and paragraph spacing.
• Changing page size and margins.

14. Changing the Background of a Document

1. Open the Format menu.
2. Select Page Style or the relevant page settings option.
3. Go to the Background option.
4. Select an available colour or other option.
5. Apply the changes.

Note: The option names may differ according to the Writer version.

Finding and Replacing Words

The Find command is used to search for a word, while Replace is used to change it to another word.

Steps:

1. Open Edit → Find or Find and Replace.
2. Type the word to search for in the Find box.
3. Type the new word in the Replace box.
4. Click Replace or Replace All.

Shortcuts: Ctrl + F — Find a word; Ctrl + H — Find and Replace.

Printing a Document

1. Click File → Print.
2. Select the printer.
3. Set the pages and number of copies.
4. Click Print.

Shortcut: Ctrl + P

OpenOffice Calc

Spreadsheet

A spreadsheet is software that organizes data into rows and columns. It is used for calculations, data analysis, and creating charts.

Examples: Students' marks, fee records, and monthly budgets.

Calc

StarCalc was the old spreadsheet software of StarOffice. Its modern equivalent in OpenOffice is Calc. It is used for mathematical calculations and data management. Formulas and functions can be used in it. Charts can be created from data.

Starting StarCalc / Calc

1. Open the Applications menu.
2. Select the Office category.
3. Click OpenOffice Calc.

Main Elements of the Calc Window

1. Title Bar: Displays the file name.
2. Menu Bar: Provides different commands.
3. Toolbar: Contains buttons for common tasks.
4. Formula Bar: Displays the contents or formula of a cell.
5. Name Box: Displays the address of the active cell.
6. Rows: Horizontal lines of cells.
7. Columns: Vertical lines of cells.
8. Cell: The intersection of a row and a column.
9. Sheet Tabs: Help select different sheets.
10. Status Bar: Displays the sheet status and other information.

Difference Between Workbook and Worksheet

Workbook	Worksheet
It is the complete spreadsheet file.	It is a single sheet inside a workbook.
It can contain multiple worksheets.	It contains rows and columns.
Example: Marks.ods	Example: Sheet1, Sheet2

Working in Calc

Calc is used to enter data, edit cells, apply formulas, create tables, organize data, and prepare charts.

Creating a New File

1. Select File → New → Spreadsheet.
2. Enter the required data into cells.
3. Apply formulas or formatting as needed.

Shortcut: Ctrl + N

Saving a File

1. Click File → Save.
2. Enter the file name.
3. Select the location.
4. Click Save.

The standard file extension of Calc is .ods.

Shortcut: Ctrl + S

Editing an Existing File

1. Select File → Open.
2. Open the file.
3. Select the cell you want to change.
4. Enter new data or edit the existing data.
5. Press Ctrl + S to save the changes.

Performing Calculations Using Formulas

In Calc, a formula always begins with the = sign.

Examples:

Operation	Formula
Addition	=A1+B1
Subtraction	=A1-B1
Multiplication	=A1*B1
Division	=A1/B1
Sum	=SUM(A1:A5)
Average	=AVERAGE(A1:A5)

Example: If cell A1 contains 10 and cell B1 contains 20, the result of =A1+B1 will be 30.

Creating a Chart

A chart displays data in a graphical form.

Steps to create a chart:

1. Enter the data in a table.
2. Select the data.
3. Click Insert → Chart.
4. Select the chart type.
5. Set the title and other options.
6. Click Finish.

13. Main Types of Charts

1. Column Chart

It compares data using vertical columns.

2. Line Chart

It shows changes in data over time.

3. Pie Chart

It shows the proportion of different parts of a whole.

4. Bar Chart

It compares data using horizontal bars.

5. Area Chart

It shows changes in data by filling the area below a line.

6. XY Scatter Chart

It shows the relationship between two numerical values.

OpenOffice Impress

What is Presentation Software?

Presentation software is used to present information in the form of slides. Text, pictures, charts, audio, video, and animations can be added to slides.

Examples: School projects, classroom teaching, and presentations on different topics.

Introduction to StarImpress

StarImpress was the old presentation software of StarOffice. Its modern equivalent in OpenOffice is Impress. It is used to create and display slide presentations. Text, pictures, charts, and animations can be added to slides.

Main Elements of the Impress Window

1. Title Bar: Displays the presentation name.
2. Menu Bar: Provides different commands.
3. Toolbar: Contains buttons for common tasks.
4. Slides Pane: Displays small previews of all slides.
5. Workspace: The area used to edit the current slide.
6. Task Pane: Provides layouts and other slide options.
7. Status Bar: Displays slide status and other information.

Main Elements of the StarOffice / Impress Window

The main elements of the Impress window are the Title Bar, Menu Bar, Toolbar, Slides Pane, Workspace, Task Pane, and Status Bar.

Creating a New Presentation File

1. Select File → New → Presentation.
2. Choose a layout or template from the available options.
3. Type the title and text on the slide.
4. Add pictures and other content as required.

Shortcut: Ctrl + N

Opening an Existing Presentation File

1. Click File → Open.
2. Select the presentation file.
3. Click Open.
4. Make the required changes.

Shortcut: Ctrl + O

Saving a Presentation

1. Click File → Save.
2. Enter the file name.
3. Select the location.
4. Click Save.

The standard file extension of Impress is .odp.

Shortcut: Ctrl + S

Creating a Presentation

1. Open a new presentation.
2. Write the topic title on the first slide.
3. Add new slides.
4. Write the main points on each slide.
5. Add pictures, tables, and charts as required.
6. Choose a slide layout and design.
7. Apply transitions and animations if needed.
8. Save the presentation.
9. Run the Slide Show to display the presentation.

Common shortcut to start the slide show: F5