While the GNOME desktop does not have a specific office suite, there are a number of office application optimized for GNOME. These applications include Abiword, a word processing application that has plug-ins to make presentations and graphs, Gnumeric, a spreadsheet application, and gLabels, a program for creating labels and business cards.
Remember that any office application or suite will run on any Fedora desktop environment. The recommendation is only the office suite best optimized for a specific desktop environment, such as GNOME or KDE. Once installed, all office tools are available from the Applications > Office menu in GNOME, the Kickoff Application Launcher > Applications > Officemenu in KDE, or as icons located in the menu bar or on the desktop.
OpenOffice.org creates documents in open standards formats, such as OpenDocument (.ODF), Rich Text Format (.RTF), and HyperText Markup Language (HTML). It can also read, edit, and write documents in Microsoft Office formats, such as Word (.DOC), Excel (.XLS), and PowerPoint (.PPT), with a high degree of compatibility. Files can be exported in PDF format without the need of additional software. The most used Openoffice.org programs are: Impress, Calc, and Writer.
For the most up-to-date information on all of OpenOffice.org's office program offerings, visit the official site at
http://www.openoffice.org
For more information on using
OpenOffice.org, refer to the following documentation and support pages:
10.1.1. OpenOffice.org Impress
OpenOffice.org Impress Creates and performs presentations.
Start the application with Applications > Office > OpenOffice.org Impress in GNOME, or Kickoff Application Launcher > Applications > Office > Presentation in KDE.
The first window asks you to choose
Empty presentation,
From template or
Open existing presentation.
If you chose to create a presentation from scratch or from a template, OpenOffice.org Impress helps you to set up your new presentation.
Click the Next button to Select a slide design and Select an output medium. Another click on Next opens the Presentation Wizard to set up your presentation. You can select the Effect and Speed of slide transition, and either Default or Automatic for the Type of Presentation you want. When building a presentation from a template there may be additional pages of questions such as the subject of the presentation or company name or the number of starting slides.
The Create button opens your presentation.
The application opens with the work area, top menu and a drawing menu on the bottom. When you roll your mouse over the icons a description of its function pops up. Click Help or press the F1 key, to open the OpenOffice.org Impress help manual.
10.1.2. OpenOffice.org Calc
OpenOffice.org Calc is a full-featured spreadsheet program.
Start the application with Applications > Office > OpenOffice.org Calc in GNOME, or Kickoff Application Launcher > Applications > Office > Spreadsheet in KDE.
The top bar contains the following menus:
lets you create New documents, Open Close, Export and Print a file. This menu also contains the Wizards option that lets you create different templates.
allows you to Cut, Copy, and Paste data, or to Delete Cells
lets you select Toolbars, see Page Breaks, and Zoom in and out.
lets you insert Cells, Rows, Sheets, Files, Pictures, Sounds, Functions, Special Characters, and Links.
lets you format Cells, Rows, Columns, and the Sheet. These controls also let you set up the Page and Print Ranges, and Change Case and Styles. They also let you Anchor, Align, Arrange, Flip, Group, and manipulate Graphics.
let you check Spelling, access the Thesaurus, use the Detective, Goal Seek, Solver, and Scenarios filters, configure AutoCorrect, Share, Merge, and Protect the document. You can run Macros, Extension Manager, Customize the application, and set-up various Options.
lets you manipulate the data such as Define or Select Range, Sort, Filter, and Group and Outline.
lets you open a New Window, Close Window, and Split or Freeze the current window. It also lists any open files on the bottom of the drop-down menu.
opens the OpenOffice.org Calc, which you can also access with the F1 key.
The row of icons under the top menu bar contains the most frequently used functions plus a few icons for data manipulation.
The third menu panel allows you to configure the appearance of your data, such as font selection, text alignment, bullets, indentations, bolding, and italics.
The fourth panel shows the address of the cell you are pointing to and the data window shows what the cell contains.
The panel at the bottom of the spreadsheet shows which spreadsheet is currently selected and how many worksheets are in the file.
You can add new worksheets by clicking Insert > Sheet in the top menu panel. A dialog box opens which lets you choose the name of the new sheet and where it will be placed in relation to your existing worksheets. You can also add a new worksheet by right-clicking on a spreadsheet tab. This action opens a menu that allows you to Insert, Delete, Rename, Move/Copy, Select All, Cut, or Copy the spreadsheet.
10.1.3. OpenOffice.org Writer
OpenOffice.org Writer is a word processing program.
Start the application with Applications > Office > OpenOffice.org Writer in GNOME, or Kickoff Application Launcher > Applications > Office > Word Processor in KDE.
The top bar contains the following menus:
lets you create New documents, Open Close, Export and Print a file. This menu also contains the Wizards option that lets you create different templates.
allows you to Cut, Copy, Paste, Compare, or Select Text, and to turn on and configure Auto-Text, Find and Replace, and recording, protecting, comparing and merging Changes.
lets you select the type of Layout, Status Bar, Ruler, Toolbars, Text Boundaries, Field Names, Non-printing Characters, Hidden Paragraphs, Full Screen and Zoom in and out.
lets you insert Manual Breaks, Fields, Special Characters, Formatting Marks, Hyperlinks, Headers, Footers, Footnotes, Bookmarks, Note, Scripts, Cross-reference, Indexes, Tables, Envelopes, Horizontal Ruler, Pictures, Movies and Sound, Objects, Floating Frames, and Files.
lets you format Characters, Paragraphs, Bullets and Numbering, Page, Title Page, Change Case, configure Columns, Styles and Formatting. You can also Anchor, Wrap, Align, Flip, and Group text, and format Objects, Frames, and Pictures.
allows you to Insert, Delete, Select, and manipulate the Table's Cells. You can also format a Table's cells, rows and columns, add Formulas and access a Table's Properties.
gives you access to Spelling and Grammar, Language (which includes Thesaurus), Word Count, Auto correction, Outline Numbering and Line Numbering, Footnotes, Gallery, Media Player, Bibliography Database, and Mail Merge Wizard You can also Sort, Calculate, change and format Macros and Filters, Customize Menus, Keyboard, Toolbars and Events. Options lets you configure your User Data.
lets you open a New Window, Close Window, and lists any open files on the bottom of the drop-down menu.
opens the OpenOffice.org Writer, which you can also access with the F1 key.
The row of icons under the top menu bar contains the most frequently used functions plus a few icons for data manipulation.
The third menu panel allows you to configure the appearance of your document, such as font selection, text alignment, bullets, indentations, bolding, and italics.
The fourth panel shows the address of the cell you are pointing to and the data window shows what the cell contains.
The panel at the bottom of the document contains inset windows, some of which have menu access by double clicking on the window. This panel showns the number of pages the document contains, the page style being used, the language, an indicator of type over or insert, page layout view, and a zoom in and out bar.
The KOffice suite is optimized for the KDE desktop environment. The KOffice applications also create documents and files in open standards formats including OpenDocument (.ODF), Rich Text Format (.RTF), and HTML. Officially, the KOffice FAQ recommends using .RTF or .PDF formats for compatibility with Microsoft Word.[] KOffice does support Microsoft file formats, but there are issues with compatibility.
For the most up-to-date information on all of
KOffice's program offerings, visit the official
KOffice site at
http://www.koffice.org/. This site also includes detailed documentation and help for each individual
KOffice program.
KPresenter is the KOffice application for creating and performing presentations.
Open KPresenter by selecting the Kickoff Application Launcher > Office > Slide Presentations entry for KPresenter.
The first window contains options for opening Recent or Existing documents, the type of Template or Screen Presentation you want, as well as a menu bar.
On the menu bar,
choose File to create a New file, Open or Import a file, or Quit the application.
choose the Settings drop-down menu select Show Toolbar, Configure Shortcuts or Configure Toolbars.
click Helpto open the KPresenter Handbook or Report a Bug. You can also access the KPresenter Handbook by pressing the F1 key.
After selecting a template click the Use This Template button and check the box Always use this template if you want to make it the program default.
The next window has three menu panels on the top, a workspace with three windows, and a panel running along the bottom.
The first menu row consists of:
- File
allows you to create a New file, Open, Save, Import, Export, and Mail files. You can Create an HTML Slideshow or Memory Stick Slideshow, use the Template Manger, Use Current Slide as Default Template, Print, Preview, Close or Quit the presentation.
- Edit
lets you Undo, Redo, Cut, Copy, Paste, Delete, Select All, Deselect, Find, Replace, Copy Slide, Duplicate and Delete a Slide and to Duplicate an Object.
- View
lets you select a New View, Close All Views, Split View, Remove View, Hide the Sidebar, Notebar, or Slide Master. It also allows Formatting of Characters, to show or hide Guide Lines, Grid, and the Snap to Grid, and Zoom in or out. When you select these options they appear in the work area windows.
- Insert
allows you to add a Special Character, Variable, Link, Comment, Slide, File, Text, Chart, Table, Object, Picture, Line, Shape, or Scan Image.
- Format
lets you select Rotate, Zoom, adjust the Properties, Arrange, Align, Group, Ungroup and Shadow Objects. Here you can also change the Page Layout, Slide Background, and Enable Document Headers and Footers.
- Text
lets you switch to the Default Format, select Fonts, configure Paragraphs and color. The Style Manager lets your create your own styles or you can choose Style which lists the available styles. You can also Align the text, chose to add Numbers or Bullets by selecting Type. There are options to manipulate an Object, Change Case, turn on, or off, the Auto Spellcheck and Autocorrection.
- Slide Show
allows you to configure the Slide Show, Objects, and Slide Transition. In this menu you can Start and Customize the slide show, and navigate the presentation manually.
- Settings
lets you choose the Toolbars you want to use, you can Configure Autocorrection, Completion, Shortcuts, Toolbars, and KPresenter.
- Help
opens the KPresenter Handbook (which you can also access by pressing the F1 key), lets you Report a Bug and offers general information about KPresenter and KDE.
The second row contains icons that are shortcuts of the top menu panel for File, Insert, Drawing, and Object formatting. Rolling your mouse over an icon opens a small window that lists its function.
The third menu panel is also made up of shortcut icons to work with Text and Slideshow configuration and navigation. Many of the icons in the menu panels are grayed out until a selection is made on the slide in the work area window.
The bottom panel shows the Slide number currently being worked on and the number of slides in the presentation, Main Slide Content or attributes, the Zoom percentage, and current measurement, Centimeters or Inches.
KSpread is the KOffice spreadsheet program.
Open KSpread by selecting the Kickoff Application Launcher > Office > Spreadsheet entry for KSpread.
The first window contains options for opening Recent or Existing documents, and the type of Template, as well as a menu bar.
On the menu bar,
choose File to create a New file, Open, Close or Import a file, or Quit the application.
choose the Settings drop-down menu select Show Toolbar, Configure Shortcuts or Configure Toolbars.
click Helpto open the KSpread Handbook or Report a Bug. You can also access the KSpread Handbook by pressing the F1 key.
After selecting a template click the Use This Template button and check the box Always use this template if you want to make it the program default.
The next window has four menu panels on the top, the spreadsheet, and spreadsheet tabs running along the bottom.
The first menu row consists of:
- File
lets you create New documents, Open and Close a file, Save, Export, Import, Mail, Create a Template From Document, Print, and Quit the application.
- Edit
allows you to Cut, Copy, and Paste, Fill, Find, and Replace, Delete, Remove Links and change Cell Attributes.
- View
opens a new spreadsheet with New View, or allows access to Close All Views, Split or Remove View, Goto a Cell, Show Page Borders, and Zoom in and out.
- Insert
lets you insert Cell Comments, Functions, Series, Links, Special Characters, Objects, Charts, Pictures, or External Data such as information from a Database, Text File or the Clipboard.
- Format
lets you format the Cells, Rows, Columns, can be formatted, the Sheet can be Removed, Hidden and the Sheet Properties changed. Format can also be used to set up or create Styles, change the Page Layout and Print Ranges.
- Data
lets you manipulate the data such as Sort bring Text to Columns, Insert columns, Rows, Delete Columns or Rows, Insert, Remove, Merge, or Disassociate Cells, Show an Area, insert Subtotals, Goal Seek, or Consolidate formulas.
- Tools
can check Spelling, create Custom Lists, Protect Sheet and Document, Recalculate Sheet or Document, Insert Calendar. Tools can also access the Script Manager and Editor, and Export to HTML File.
- Settings
provides Hide the Status Bar, Tab Bar, and Formula Bar. Also use Settings to choose which Toolbars you want open, Configure Shortcuts, Toolbars, and KSpread.
- Help
opens the KSpread Handbook (which you can also access by pressing the F1 key), lets you Report a Bug and offers general information about KSpread and KDE.
The row of icons under the top menu bar contains the most frequently used functions plus a few icons for data manipulation.
The third menu panel allows configuration of the appearance of your data, such as font selection, alignment, font, bullets, indentations, bolding, and italics.
The fourth panel shows the address of the current cell and the data window shows what the cell contains.
The panel at the bottom shows in bold which spreadsheet is currently selected and how many worksheets are in the file. Worksheets can be added with a right mouse click on a worksheet tab. This pop-up window allows Rename the Sheet, Insert, Remove, Hide or Show the Sheet and provides access to Sheet Properties.
KWord is the KOffice word processing program.
Open KWord by selecting the Kickoff Application Launcher > Office > Word Processing entry for KWord.
The first window contains options for opening New Recent or Existing documents, the type of Template, as well as a menu bar.
On the menu bar,
choose File to create a New file, Open, Close or Import a file, or Quit the application.
choose the Settings drop-down menu select Show Toolbar, Configure Shortcuts or Configure Toolbars.
click Helpto open the KWord Handbook or Report a Bug. You can also access the KWord Handbook by pressing the F1 key.
After selecting a template click the Use This Template button and check the box Always use this template if you want to make it the program default.
The next window has three menu panels on the top, Frame shortcut icons on the left, the Document Structure window, the document work area, and an information panel running along the bottom.
The first menu row consists of:
- File
lets you create New documents, Open and Close a file, Save, Export, Import, Mail, Create a Template From Document, Print, and Close the file or Quit the application.
- Edit
allows you to Undo, Redo, Cut, Copy, Paste, Select All, All Frames or a single Frame. You can also Find, Replace, and Delete Page.
- View
lets you open a new document with New View, Close All Views, Split or Remove View, Display Mode for Page, Preview, and Text Modes. You can Format Characters, choose Frame Borders, Hide Doc Structure and Rulers, Show Grid, Snap to Grid, and Zoom in and out.
- Insert
lets you insert Special Characters, Page Breaks, Pages, Footnotes/Endnotes, Table of Contents, Variables, Expressions, Links, Comments, Files, Bookmarks, Tables, Pictures, Text Frames, Object Frames, or Scan Images.
- Format
lets you choose the Default Format, Font, Paragraph, Footnotes, Formulas, Styles, use the Style Manager, Import Styles, or Create a Style From a Selection. Page Layout can also be formatted and you can Enable Document Headers and Footers.
- Frames
allows you to set Frame/Frameset Properties, Raise and Lower Frames, Bring to Front, Send to Back, Create a Linked Copy, Convert to Text Box, and to use the Frame Style Manager, Create Framestyle From Frame, change the Framestyle, Text Backgound Color, and Configure the Frame Border.
- Table
allows you to change the Table's Properties, Insert and Delete, Rows, and Columns, Join, Split and Protect Cells, Ungroup the Table, Delete a Table, use the Table Style manager and choose from several Tablestyles.
- Tools
gives you access to Spellcheck, Autocorrection, Change Case, Sort Text, Edit Personal Expressions, Add Expressions, set Custom Variables, Select Bookmarks, and Configure Mail Merge.
- Settings
lets you choose which Toolbars you want open, Configure Autocorrection and Completion, Configure Shortcuts, Toolbars, and Kword.
- Help
opens the KWord Handbook (which you can also access by pressing the F1 key), lets you Report a Bug and offers general information about KWord and KDE.
The row of icons under the top menu bar contains the most frequently used functions plus a few icons for text manipulation.
The third menu panel allows configuration of the appearance of your text, such as font selection, alignment, font, bullets, indentations, bolding, and italics.
Next to the work area is the Document Structure window which shows its structure, and icons for shortcuts to configure Frames.
The bottom panel shows the number of pages in the document, which page is in the work area window, whether Insert or Typeover is turned on, the Zoom in percentage, and the chosen measurement units.
Although GNOME does not have an office suite specifically designed for it, a number of office applications optimized for GNOME are available.
AbiWord is a word processing application optimized for the GNOME desktop.
Start AbiWord by clicking on Applications > Office > AbiWord in GNOME or the Kickoff Application Launcher > Applications > Office > Word Processor menu entry for AbiWord in KDE.
The functions of the top menu are:
- File
lets you create New documents, New using a Template, Open and Import Files, Save and Revert a file, Page Setup and Print, Close a file, or Quit the application. This menu will also show a list of recently opened files.
- Edit
allows you to Undo,Redo, Cut, Copy,and Paste, Clear, Select All, to Remove Headers and Footers, Find and Replace, Goto and to change the Preferences.
- View
lets you select the type of Layout, Toolbars, Ruler and Status Bar, Enable Formatting Tools, Show Formatting Marks, view a Presentation, Full Screen and Zoom in and out.
- Insert
lets you insert Breaks, Page Numbers, Date and Time, Fields, Text Box, Mail Merge Field, Symbols, Headers and Footers, Files, Bookmarks, Hyperlinks, Table of Contents, Footnotes, Endnotes, Equations, Clip Art, Pictures. Objects such as GNOME Office Charts, and Direction Markers.
- Format
lets you format Fonts, Paragraphs, add Bullets and Numbering, Text Box, Images, Columns, Tabs, Headers/Footers, Footnotes and Endnotes, Table of Contents. You can also Align and Format text, add a Page Background and Create and Modify Styles.
- Tools
lets you Check Spelling, Set the Language, Word Count, access the Thesaurus, GDict Dictionary, Translators, Edit an Image via GIMP, Google Search, Summarize the document, URL Dictionary, Wiki Encyclopedia change style with the Stylist, access the Document History and Revisions. You can also see the installed Plug-ins and install new ones, execute helper Scripts that you have created, and perform Mail Merge.
- Table
allows you to Insert, Delete, Select, and manipulate the table's Cells. You can also format and merge a table's Cells, Rows and Columns, Convert Text to a Table, Convert a Table to Text and turn on Autofit Table.
- Collaborate
lets you Share a Document or Documents and manage the collaboration Accounts.
- Documents
lets you open a New Window that lists any open documents.
- Help
opens Help Contents, Search for Help, Check for Updates, Report a Bug, and see general information About GNOME Office and About AbiWord.
The row of icons under the top menu bar contains the most frequently used functions that are listed in the top menu.
The third menu panel allows you to configure the appearance of your text, such as font selection, alignment, font, bullets, indentations, bolding, and italics.
The panel at the bottom of the document contains a window that shows the number of pages in the document and which page is currently displayed, an indicator that Type-Over or Insert is turned on, page layout view, and language in use.
Gnumeric is a spreadsheet optimized for the GNOME desktop.
Start Gnumeric by clicking on Applications > Office > Gnumeric Spreadsheet in GNOME or the Kickoff Application Launcher > Applications > Office > Spreadsheet menu entry for Gnumeric in KDE.
Major functions of the top menu are:
- File
lets you create New documents, Open, Save, Page Setup, Set, Clear and Show the Print Area. File also provides options to Print, Send To an email address, view and add to the program's Properties, set Preferences, access a Full History, and Close a file, or Quit the program.
- Edit
allows you to Undo and Redo actions, Cut, Copy, and Paste and Fill, Clear, and Delete Rows, Columns, and Cells. Edit also provides options to Find, Replace or Goto a Cell, manage the Sheets, Select various ranges in the spreadsheet, and Recalculate.
- View
allows you to create a New View of the workbook, to Freeze Panes, select a different Workbook, choose Toolbars, View Statusbar, Full Screen and Zoom in and out.
- Insert
lets you insert Cells, Columns, Rows, Charts, Images, Functions, Names, Comments, Hyperlinks and Special fields such as Current Date, Current Time and Current date and time.
- Format
lets you format the Cells, Rows, Columns, Sheets and Workbook can be formatted and Preferences changed. Use Autoformat to format a region of cells according to a pre-defined template.
- Tools
provides Auto Correct, Auto Save, Goal Seek, Solver, View and Add Scenarios, Simulation, Statistical Analysis and manage Plug-ins.
- Data
allows manipulation of the data such as Sort, Filter, Validate, Consolidate, create a Table, Group and Outline, convert Text to Columns and Get External Data.
- Help > Contents
opens the Gnumeric help manual (as does the F1 key), Gnumeric on the Web, Live Assistance, and Report a Problem.
The row of icons under the top menu bar contains the most frequently used functions that are listed in the top menu.
The third menu panel allows you to configure the appearance of your data, such as font selection, alignment, font, bullets, indentations, bolding, and italics.
The fourth panel shows the address of the cell you are pointing to and the data window shows what the cell contains.
The panel at the bottom of the spreadsheet shows which spreadsheet is currently selected, how many worksheets are in the file, and a function's result in the cell to which you are of the cell you are pointing. You can add or change a worksheet by:
a right mouse click on one of the tabs, then choosing from the menu.
clicking on Edit > Sheet in the top menu.
gLabels is a light-weight GNOME application for creating labels, business cards, and labels for CD and DVDs.
Start gLabels by clicking on Applications > Office > gLabels Label Designer in GNOME or Kickoff Application Launcher > Applications > Office > gLabels Label Designer in KDE.
The major functions of the top menu are:
- File
lets you create a New project, Open, Open Recent files, Save, Save As, Print, change Properties open the Template Designer Close a file, or Quit the program.
- Edit
allows you to Cut, Copy, and Paste, Delete Select All, Unselect All and change the Preferences.
- View
lets you choose Toolbars, customize the toolbars, turn on the Grid and Markup, and Zoom in and out.
- Objects
lets you Select Mode, Create Text, a Box, Line, Ellipse, Image, a Barcode define the Order, Rotate/Flip, Align Horizontal or Vertical and Merge Properties.
- Help > Contents
opens the gLabels help manual (as does the F1 key), or lets you see general information About the program.
The row of icons under the top menu bar contains the most frequently used functions that are listed in the top menu.
The third menu panel is grayed-out until you select a New project or Open an existing file. These icons allow you to Select, move and modify objects, Create text object, Create box/rectangle object, Create a line object, Create ellipse/circle object, Create Image Object, Create a Barcode, Zoom in and out, and Edit merge properties.
The panel at the bottom of the work window allows you to configure the appearance of your data, such as font selection, alignment, bolding, and italics, as well as text and line color.