Openoffice org 3 complete user guide. Basic course on OpenOffice. Presentation modes
What is keeping users from switching from commercial to free software? In some cases - the difficulty of finding an alternative that would suit in all respects, in others - just a habit that is hard to part with. For some specialized programs, it is really difficult to find free and at the same time sufficiently functional analogs, but, for example, with the search for an alternative office suite, problems are unlikely to arise. There are quite a few free, as well as several full-fledged office suites that include tools for working with text, spreadsheets and presentations. The most famous free office suite is definitely .org.
In mid-October, a new, third version of this application package was released. The release of the new version of OpenOffice.org is a good reason to take another look at it. It is quite possible that now it meets all the requirements that you put forward for an office suite, and therefore may well replace MS on your computer.
Perhaps one of the main advantages of OpenOffice.org over the many free office applications- full support for the Russian language. Since working with documents is, first of all, working with text, the lack of verification is a very serious drawback. Everything is fine with OpenOffice.org with language support - just download the Russian version and you will get a fully Russified office suite.
As before, OpenOffice.org consists of six main applications: text editor Writer, Calc Spreadsheet Programs, Impress Presentation Applications, Tools for Working with databases Base, the Draw vector art tool and the Math formula editor. After installation, in addition to the shortcuts for launching these six programs, you will notice another one on the Start menu, which is simply called OpenOffice.org. It launches a shell with a greeting, with which you can create or open a document of the desired type, open or load a template, go to the add-on download page and register the program. Registration is optional - it is just a kind of statistical tool for calculating the total number of users of the package.
The shell is only auxiliary tool, and you can open and create documents, as before, immediately after launching applications. By the way, it would not be superfluous to mention one interesting feature of OpenOffice.org, which is absent in MS Office - the document opening window is common for all applications. In other words, if you are running, for example, Writer, and you need to open a spreadsheet, you can select this type of document from the open window, after which Calc will be launched. In MS Office, only a Word document can be opened from a Word window, and only Excel can be used to open a table.
The interface of the programs has not undergone significant changes and, as before, resembles MS Office 2003 and earlier versions. Probably, to some people this will not seem modern enough, but, on the other hand, one can argue for a long time about the convenience of the new MS Office 2007 interface, and the fact that it takes a lot of time to master it is beyond doubt. Of the small improvements in the interface of OpenOffice.org 3, a new set of icons for commands rendered on the toolbar can be noted.
However, the developers of the text editor Writer have taken over some of the new MS Office 2007 interface. This is a convenient zoom slider located in the lower right corner of the program window. V previous versions to change the scale, it was necessary to use a special dialog box or menu with several options, but now everything is much more convenient. The user can freely change the scale, but at the same time quickly return to the most optimal variant of viewing the document, using special marks on the scale of zooming.
Next to the new slider, you can find buttons for switching view modes. In the second version of OpenOffice.org, you could see only one page of a multi-page document on the screen, but now you can view several pages at once. This feature is especially useful when you need to get an idea of the general view of the document before printing it, and it will also be useful when working with two monitors.
Unfortunately, the slider for changing the scale for some reason was added only to the text editor, although in other applications of the package it would be no less useful.
Users who collaborate on documents will surely appreciate the improved comment viewer functionality. Notes made by other users in the third version of Writer are much clearer - they are displayed in the margin in small rectangles, from which there is an arrow pointing to the place in the text to which the comment refers. Together with the text of the note, you can see the name of the user who left it, as well as the time. Comments from different users are colored in different colors for clarity.
Among all the applications that are part of OpenOffice.org, the most in demand are Writer, Calc, and Impress. Therefore, it is not surprising that special attention was paid to them. We have already discussed the main innovations in the text editor above, as for the program for working with spreadsheets, then it also has something interesting.
First, Calc tables can now contain up to 1,024 columns, while in the previous version this number was four times less - 256. Of course, before Excel 2007, which supports 16 thousand columns, Calc is still a long way away, but most users will probably never pay attention to the 1024 column limit, since that is quite a lot.
The second useful innovation in Calc will be interesting for those users who work on documents together over the network. The program has a new command that allows you to share a document. After the author of the table has made it available to other users, they can make changes to it and add new data. When joint work completed, the author can preview the changes and save them.
Unfortunately, the table sharing feature has some limitations. So, working in this mode, it is impossible to change number formats, font parameters, edit diagrams and pictures. In addition, when changes are made to the table, they are not reflected in real time for those users who are currently working with it. To view the changes, you need to refresh the document or reopen it.
The main innovation in Impress is the ability to insert tables. In the second version of OpenOffice.org, it was possible to insert tables into presentations only as embedded Calc objects, which, of course, was not very convenient. Now, in the "Insert" menu, you can find the "Table" item, after selecting which a window appears in which you can specify the required number of rows and columns. After the table has been added to the presentation, it can be freely edited using the Impress tools located on the special "Table" toolbar.
Another improvement in Impress, which applies to Draw as well, is a more convenient image cropping feature. With the crop tool selected, you can now crop by simply dragging the handles located at the corners and sides of the picture.
OpenOffice.org has always worked quite well with MS Office documents, giving users the ability to both open files in "native" Microsoft formats, and save in them. However, this concerned the formats used in MS Office 97-2003. The second version of OpenOffice.org did not support the new Open XML format, in which documents were saved in MS Office 2007 by default, and files with the .docx, .xlsx, .pptx extensions were not opened in the program.
The third version adds support for these formats, albeit incomplete. Users can open Open XML files, but if there is a need to make changes to them, they need to resave the file in a different format, for example, in the "native" for OpenOffice.org ODF format or in the old MS Office formats. Since MS Office 2007 works with doc files, xls and others, this does not cause any particular inconvenience.
Note that the integration with the ODF format in MS Office 2007 is implemented much worse - by default there is no support for the "native" OpenOffice.org format in the Microsoft package, although it is promised to be implemented in the second service pack, which is scheduled for release early next year. MS Office 2007 Service Pack 1 users can use Sun's special ODF Plugin to open and save ODF files, while those who have not yet installed Service Pack 1 can use the plugin.
Another improvement in OpenOffice.org that concerns support for formats is the use of the new version of the ODF 1.2 format for saving documents by default, which has improved metadata support and expanded tools for working with formulas. If necessary, the user can set in the program settings to use the old ODF 1.1 format, in which documents were saved in OpenOffice.org 2.
Conclusion
In general, there are not too many innovations in the third version of OpenOffice.org, however, some of them are important in themselves so that they are a reason for updating. For example, the ability to open MS Office 2007 documents is a very important innovation, thanks to which users who work with latest version office suite from Microsoft and having a lot of documents saved in the new format can now safely switch to OpenOffice.org without fear that they will not be able to access their data.
The distribution kit of the program is about 140 MB in size, can be downloaded from the official website
Leave your comment!
Anton Ionov, Yuri Konovalov, Alexey Novodvorsky, Daniil Smirnov, Ilya Trunin, Anatoly Yakushin
General information about the office suite OpenOffice.org
OpenOffice.org is a free office suite that includes the following components:
OpenWriter (word processor and HTML editor);
OpenCalc (spreadsheets);
OpenDraw (graphics editor);
OpenImpress (presentation system);
formula editor OpenMatch;
data access module.
OpenOffice.org is a complete free office suite that rivals popular proprietary software such as Microsoft Office. It contains components for working with text, spreadsheets, works with databases, processes graphics, creates complex documents for Internet publications.
The developers of OpenOffice.org, introducing advanced document processing technologies, tried to make the work of ordinary users as easy as possible. Therefore, upon first acquaintance, you find yourself in a familiar environment, familiar from MS applications, and you can start working right away. There is no need to retrain - the skills of working with Microsoft Office are quite enough. If you have books on Microsoft Office, then they are fine for the first acquaintance with OpenOffice.org - the basic methods of work are extremely similar.
Once you start using OpenOffice.org, you can still work with all the files that you prepared earlier in the Microsoft Office environment, and easily exchange documents with users of other programs.
OpenOffice.org reads and saves documents in most popular formats. These include Word, Excel, PowerPoint, RTF, html, xhtml, DocBook files, plain text files in various encodings. In addition, OpenOffice.org allows you to export complex documents with illustrations and graphics in pdf format. The OpenImpress presentation system allows you to export presentations in the Macromedia Flash (.swf) format.
OpenOffice.org contains all the necessary components to build complex systems. It supports templates, knows how to work with databases, contains its own programming language OOBasic, much like MS Visual Basic for Application, and executes programs written in the Java programming language.
OpenOffice.org runs on multiple platforms: Microsoft Windows, Linux, FreeBSD, Solaris, Mac OS X and many more. At the same time, the appearance of applications and the format of the files used remain unchanged, which allows users of various operating systems to collaborate on documents.
This guide describes programs from the OpenOffice.org package version 1.1. However, a new, as yet unstable version of the package has already been released - 2.0. In version 2.0, some fundamental changes have been made: in particular, document formats have been changed; the Open Document standard is now used, file extensions have changed. Version 2.0 is still available alongside 1.1 in a separate package; they can be installed in parallel.
Launching OpenOffice.org
OpenOffice.org can be launched both from the main menu (there it appears in the "Office" section), and by the command ooffice - key ... You can view the available launch keys using the key -help... When launched without a key, the main OpenOffice.org window starts. For each application from the kit there is also a separate command of the form oo application , for example oowriter .
Table 1. Main keys for starting OpenOffice.org
Using the parameters command line, it is easy to create icons for launching OpenOffice.org applications.
In file managers that support MIME file types (for example, Konqueror), you can establish a link between a file with a specific extension and one of the OpenOffice.org applications: in this case, when opening a file in file manager the desired application will automatically start.
OpenOffice.org 1.1 accepts the following file extensions:
OpenWriter text editor
Appearance
The main window of the OpenWriter text editor after launch looks something like the one shown in Figure 1, "The appearance of the OpenWriter text editor"... Currently, active work is underway on a new translation of the OpenOffice.org interface, so some Russian names of interface elements may differ from those given in this manual.
Figure 1. Appearance of the OpenWriter text editor
You can change the appearance of OpenWriter using the View menu, or by right-clicking over the required element. Thus, you can add or remove an element from the screen, or change the set of standard buttons. The most complex interface settings can be made through the Service → Settings menu.
The user can choose one of three options for displaying the document - standard, full-screen and web-markup mode. Switching modes is done in the menu View → Full Screen or View → Web page mode... In addition, you can switch between standard and full screen modes using the keyboard shortcut Ctrl -Shift -j .
Figure 2. OpenWriter Full Screen Mode
The scale of the displayed text is indicated in the document status bar. You can change the scale in different ways:
select the menu item View → Scale;
double-click the left mouse button over the scale size in the status bar to open a dialog window;
if you have a mouse with a scroll wheel, press the key Ctrl and while holding it, rotate the scroll wheel.
Entering text
When entering text, you don't need to worry about line breaks, OpenWriter will do it automatically. The enter key should only be pressed when a new paragraph begins.
The most convenient procedure is when you first enter the entire text, then correct typos, and only then format the text.
Some time after the document is filled with text, OpenWriter starts to suggest options for the continuation of long words. One of the most convenient features of OpenOffice.org - autocomplete - has started to work. To accept the proposed option, just click Enter; if the proposed word continuation option does not suit you, just continue typing. This feature is very helpful when entering long terms or words in another language, especially for those who have not yet learned how to type quickly.
If the text contains several words that begin with the same combination of letters, then using the key combinations Ctrl -Tab or Shift -Ctrl -Tab, you can select the words you want from the list of words that OpenWriter has memorized.
To set up autocomplete, select Tools → AutoCorrect / AutoFormat → Word completion... In the same section of the menu, by going to the Substitute item, you can configure the automatic correction of the most common typos. Now, even if you misspell a word, OpenWriter will change it without waiting for the spell check. In the Exceptions item, you can assign abbreviations after which the sentence does not automatically begin with a capital letter.
Figure 3. Dialog box AutoCorrect / AutoFormat
Move through text
You can use the cursor keys in conjunction with the key Ctrl- in this case, the left and right arrow keys move the cursor one word (up to space or punctuation marks) to the left or right, and the PageUp and PageDown- at the beginning or end of the document.
When working with large documents, there are often problems with orientation in the text and fast movement through it. To facilitate the work with multi-page texts in OpenWriter there is a special tool - "". It can be called with the function key F5, by pressing the "" button on the function bar or by double-clicking the page number in the status bar.
Figure 4. Navigator
The navigator is an interactive table of contents of the document, in which all the elements that make up the document are presented in a hierarchical manner.
In the Navigator window, there is a function panel at the top, possible document objects are listed in the center, and a list of all open documents is contained in the drop-down list at the bottom.
To quickly move between document objects, it is convenient to use the "Navigation" window, which can be invoked by the button on the Navigator's function panel or by the button located at the bottom right on the vertical scroll bar.
Figure 5. "Navigation" window
Selecting in this window the necessary element of the document, for example "Page" or " Graphic object", You can click on the" up "or" down "arrows to move between the selected elements. To move to the required page, type the number of this page in the window on the Navigator's function panel and press Enter .
All possible text elements are listed in the central Navigator window. The objects used in this document are presented as a drop-down list. By double-clicking on it with the left mouse button, you can see the structure of objects and their hierarchy, and using the tool group in the right corner of the function panel, you can change the levels of these objects and move them.
Working with snippets of text
To select text in OpenWriter, there are several alternative ways... The text can be selected character by character by holding down the key Shift and moving the cursor with the keys. Holding Ctrl -Shift, you can select text not character by character, but word by word. Shortcut keys Shift -PageUp selects text one page up, and Shift -PageDown- one page down. Shortcut keys Ctrl -A selects all text in the document. Also, all text can be selected through the menu item Edit → Select All.
You can also select text character by character by holding the left mouse button and moving the cursor. Double-clicking the left mouse button selects a word, and triple-clicking a line of text. With the key pressed Shift Left-clicking will select the text from the position of the text cursor to the position of the mouse cursor.
You can select several fragments of text in different places in the document, for this you need to press and hold the key Ctrl, with the left mouse button select the necessary text fragments. This feature is called " Group text selection».
You can change the selection mode by clicking on the status bar above STD. You can also switch between STAND and ADD modes by pressing F8... The following abbreviations are used for the various modes on this line:
The selected text can be moved by holding the left mouse button and dragging the selection to the desired location, you can also copy it to the clipboard, paste from the clipboard, or delete (cut from the text and place into the clipboard). There are several ways to do this:
via the Edit menu;
via the pop-up menu available by pressing the right mouse button;
key combination: copy - Ctrl -c, insert - Ctrl -v, cut - Ctrl -x .
Document exchange: import and export
You can save the document using the File → Save menu, the "Save" button on the function bar, or the hotkey Ctrl -s... If the document has already been saved, the button on the toolbar will be inactive. When you first save the document, a dialog will open where you need to enter a file name and, possibly, specify the document type (if you are not satisfied with the default document type).
Figure 6. Dialog box for saving a document
The file name is entered in the "File name" field, it can be entered with a relative or absolute path. To switch to another directory, double-click on the directory name in the list. To make it easier to navigate the catalogs, you can sort the list by clicking on one of the column headings. For example, for sorting by file type, this is obviously "Type"; clicking on the same heading again means sorting in reverse order (indicated by an arrow).
The up button is used to go to the parent directory; if you hold it for more than one second, a menu will appear that allows you to go up several levels at once.
The next button is used to create a new directory (in the current directory): you will need to enter the name of the new directory and confirm its creation.
The rightmost button is used to navigate to the directory where all documents will be saved by default. You can change this directory in the dialog: Tools → Options → OpenOffice.org → Paths → My Documents.
Option " Automatic file name extension"Is used to set the extension according to the" File type "field. Option " Save with password»Allows you to save a file that can only be opened by entering a password (at least 5 characters).
In addition to saving in your own format OpenWriter allows you to export and import documents in formats such as:
Portable Document Format (PDF)
in formats for handheld computers with PalmOS and PocketPC operating systems.
Microsoft Word of various versions;
Rich Text Format (rtf);
StarOffice format versions 3-5;
text file;
To export to a simple text file, you must select the file type " Encoded text", Specify the file name and click the" Save "button. In the window " ASCII filter options»You can select the required encoding. To open a plain text file in a non-Latin-1 encoding, you must specify the file type " Encoded text»And select the required file encoding in the dialog box.
Figure 7. Selecting encoding when saving a text file
Portable Document Format (PDF) is a developed by Adobe universal format electronic submission of documents, including type design, layout and graphics. Having created such a document, you can be sure that anyone can see and print it exactly as it was originally intended. The type of document does not depend on which operating system you are viewing the document, no additional fonts or other components are required for viewing and printing - everything needed for display is already included in the document.
To convert the created document into a pdf file, click the "Export to PDF" button on the function bar and specify a file name in the dialog box. To set the parameters of the created file, select the File → Export to PDF menu item, specify the file name in the dialog box, and click the Export button. A dialog box appears where you can select the area of the document to export and the optimization options.
In the Linux operating system, the documents received in PDF format can be viewed with xpdf, GhostView or KghostView programs.
Printing a Document
OpenOffice.org provides a dedicated print command and a printer setup utility. Configuring printers is carried out through the menu File → Print options, where you can select a printer and set its properties.
The quickest and easiest way to send a document for printing is by clicking the button with a stylized image of the printer on the function bar - immediately after clicking the document, the entire document will be printed.
Sometimes you need to set special print options. To do this, use the File → Print menu item or the keyboard shortcut Ctrl -p; in the dialog that opens, select the printer to which you will print and, by clicking on the "Properties" button, set its properties.
Perhaps, before printing, I would like to see on the screen how the document will look on paper. To do this, you can use the File → menu item. The toolbar will display tools for setting the viewing properties, but in this mode, you cannot edit the document. Button " Close preview»On the toolbar is used to return the editor to normal operation.
Figure 8. Dialogue “ Preview pages»
The button for full-screen document viewing hides the menu, toolbars, scroll bars and leaves only the viewing panel. The next two buttons allow you to print the document and set the viewing options accordingly.
In preview mode, you can display multiple pages at the same time. In addition, from the window " Page preview»You can print the text so that there are several reduced copies of document pages on one standard sheet. To do this, set the required number of document pages per sheet by clicking the button Page settings → several pages on the lower contextual pane, and then click the "Print" button with the image of the printer and two sheets on the same contextual pane.
Spell checker
In OpenWriter, spell checking can be performed automatically as you type, or it can be invoked manually. For automatic check, you need to press the button " Auto spell check»On the left of the main toolbar or through the Tools menu → Spellchecking → Auto spell check... In this case, words that OpenWriter could not find in its dictionary will be underlined with a wavy red line. If you click on the highlighted word right click mouse button, correction options will be offered, a dialog for checking spelling will be displayed, adding a word to the dictionary, skipping this word in the entire document and automatically replacing the word with one of the options selected in the submenu.
To check spelling manually, click on the " Spellchecking"On the left of the toolbar, or through the Tools menu → Spellchecking→ Check or by pressing F7; checking starts from the current position of the cursor. The icon behind the "Word" field shows its status.
Figure 9. Dialogue for working with a specific word
A certain word can be omitted if it is spelled correctly. Alternatively, you can set the " Always skip", If this word appears more than once in the document.
If the word is spelled incorrectly, then you can either enter the correct spelling in the "Word" field, or select the appropriate one from the list of options. To replace a word only in this case, press the "Replace" button, to replace in all similar cases (throughout the document) - "Replace always".
The "Thesaurus" button is used to add synonyms to the dictionary; this dialog can also be opened using the Tools → Thesaurus menu or the keyboard shortcut Ctrl -F7... It requires you to enter a replacement word. Please note - not all languages are currently supported.
The "Options" button is used to set options and dictionaries that are used to check spelling and hyphenation. The same parameters are set in the settings dialog Tools → Options → Language settings → Linguistics.
If the word is spelled correctly, but it is not in the dictionary, then it can be added to the dictionary. To do this, select the required item in the "Dictionary" field and click on the "Add" button. In this case, all added words that occur later in other documents will be considered correct.
It is possible to check spelling only in a part of the text - for this, before checking, you will need to select the fragment of the text that you want to check.
Sometimes words that are known to be spelled correctly are highlighted as misspelled. This can be due to the fact that the wrong document language is selected. To change the language, you need to select a word, press the right mouse button, select Font from the drop-down menu and in the Font tab specify the required language of the word. The same dialog is available via the Format → Font menu.
Figure 10. Language selection dialog
There are no words with the letter ё in the standard dictionary, so all words with this letter will be considered incorrect. In order to check texts with the letter ё, you need to install an additional dictionary.
Cyrillic Document Processing
When working with files containing Cyrillic, some problems may arise. One of the most common is the incorrect conversion of files created in Microsoft Office 95 to the OpenOffice.org format.
To display such a file correctly, open it in OpenWriter or OpenCalc and select the entire file. Then open the Macro dialog from the menu bar Tools → Macros → Macro. Select the Tools section in the list of macros, and in this section the macro
For the convenience of working with Cyrillic documents, Vladimir Bukhal and Aleksey Kryukov have developed the CyrillicTools package - a collection of various macros based on OpenOffice.org Basic, designed to work with Cyrillic text in the OpenOffice.org 1.1 environment and higher. This package can be downloaded from the openoffice.ru website. In addition to correcting the encoding of Microsoft Office 95 files, the package allows you to enter the amount in words and correct Cyrillic text that was mistakenly entered in English letters.
Formatting
After the text is typed and checked, it is advisable to give it an appearance that makes it easier to understand what has been written. To do this, it is customary to highlight various semantic parts of the document with fonts of different typefaces (for example, with serifs and sans serifs) or different weights (italic, bold), indents, additional line spacing (skips), and in other ways.
For example, it is advisable to type the title of the document in a larger size and place it in the center of the page, to write captions to figures in italics, and place the page numbers in the lower right corner of each page. The assignment of design parameters to certain parts of the document is called formatting.
Formatting can be hard or soft... At hard formatting of each specific part of the document - a character, word, paragraph or page, certain display parameters are set. At the same time, formatting has nothing to do with the logical structure of the document, and objects that logically belong to the same type may turn out (and almost always turn out to be, as practice shows) decorated in different ways. For example, one of the figure captions will not be italicized, unlike the others.
At soft formatting describes the appearance not of a specific piece of text, but of the logical part of the document - headers, body text, footnotes, headers and footers, and for each specific part of the document, only its role in the document is set: for example, “ figure caption". The description of the design for a certain logical part of the document is usually called a style.
When using styles, it is necessary to logically mark up the document, that is, to indicate its structure. It is noted what is the heading in the document, what is the main text, and what is the other elements. In this case, each element will take on the appearance in accordance with the style that is defined for it.
The use of logical layout of the document and soft formatting makes it easier to work with large and complex documents and allows you to automate many stages of working with text - automatically create tables of contents, easily navigate through large documents, quickly change the design, and much more.
Working with styles
When you create a new document, a set of styles is automatically loaded from the standard template. When you type in a new document, the default style is Normal. In the window of used styles, which is located on the left of the context panel, other styles are not displayed.
For logical (soft) document markup, you need to start "" with the function key F11, using the button on the function bar or from the Format → menu item.
Figure 11. Style wizard
In the Style Wizard, on the toolbar at the top left, there are five buttons for the following style groups: paragraph, character, frame, page, and list. On the right, there are three buttons: style fill, create a style from the selection and update the style from the sample. The window displays the styles of the current group in accordance with the parameter specified in the list at the bottom of the window. If you set the value "Automatic" in this list, the Style Wizard will try to select the appropriate set of styles for the edited document.
To assign a style, you need to place the cursor in the desired paragraph or on the desired page, select the appropriate style in the Style Wizard, click Enter or double-click with the left mouse button - a new style will be assigned. To assign a style to a symbol or a group of symbols, you must select them in a standard way.
Let's show how to work with styles using an example. We have already covered pagination. However, you may notice that after the numbering has been placed, the number is also on the first page. This is inconvenient in many cases. To remove the number from the first page, you need to assign it the First Page style. To do this, call the Style Wizard, go to the Page Styles section, select the First Page style and click Enter .
The standard template contains a large number of styles, and among them you can almost always choose the most suitable one. However, there are times when the standard set is not enough and you need to change the existing style or create a new one.
The easiest way to create a new style is to use the Style Wizard feature Create style from selection... To do this, give the paragraph, symbol or page the desired format using hard formatting, select this fragment and press the button " Create style from selection»On the Style Wizard toolbar. In the window, enter a new name for the style and click OK. A new style has been created. Now you can assign a new style to sections of your document.
Figure 12. Creating a style from a selection
Similarly, you can make changes to any style. Select the required text fragment and set the style to the fragment in which you plan to make changes. Then give it the desired format using hard formatting and in the Style Wizard, click the button " Update style from sample". The style will take on the look you want.
For fine-tuning, open the style editing window. It can be called from the menu Format → Styles → Catalog → Modify or right-click on the required style and select Modify.
Figure 13. Dialog box for editing style
A set of styles created while working on a document can be reused. Styles can be imported from another document or saved in a template.
To import styles from another document, choose Format → Styles → Load from the menu and click the "From File" button. Then select the required document. The loaded styles will be added to the Style Wizard. However, it is more convenient to use templates for reusing styles.
Templates
A template is usually understood as a file that contains document formatting elements, but does not contain the text itself. When you create a new document from a template, the document inherits styles, page settings (size and orientation), built-in macros, margins, and other values. At the same time, the template itself is protected from accidental changes. It is convenient to use templates when creating documents of the same type - letters, memos, reports, etc.
To create a template, select the required document, delete unnecessary text from it, check the styles and delete unnecessary ones. Remember that the default styles cannot be deleted. For the convenience of searching for a template and managing it, give it a name by opening the menu item File → Properties → Description → Title. Then save the new template by choosing File → Templates → Save. In the dialog box that opens, specify the required directory and save the new template in it. To create a new directory, click the "Manage" button. In this dialog box, you can create new catalogs for templates and move templates between catalogs.
Figure 14. Saving a new template
Now the saved template can be used to create a new document. To do this, use the menu item File → New → Templates and documents and select the template you want.
Users are often not satisfied with the options that OpenWriter loads by default. You can change them by loading another template by default. To do this, open the " Template management", Select the template you want, right-click and select" Set as default template". Now, when creating a new document, the required parameters will be loaded.
Figure 15. Defining the default template
Hard formatting
Page formatting
To format a page, call the Format → Page menu item. In the Page Style dialog box, you can set its orientation (portrait or landscape), paper size, the presence or absence of headers and footers, and other parameters.
Figure 16. Page Style Dialog Box
Some difficulties for novice users are caused by pagination in OpenWriter. The fact is that, unlike other editors in OpenWriter, pagination is part of the header and footer.
A header or footer is a reference line above or below the body of a page. In this line, in addition to numbering, you can display other reference information, for example, the title of a section or the entire document.
To arrange pagination, include a header or footer. This can be done using the menu Insert → Page header or Insert → footer as well as through the Page Style dialog box.
After the header is turned on; choose Insert → Fields → Page number from the menu and the page numbers will be automatically placed in the document. If support for headers and footers is not enabled, the page number will appear at the current cursor position.
Formatting a paragraph
Under a paragraph (from the German absetzen - to move aside), it is customary to understand the structural part of the text, which consists of one or more sentences containing a complete micro theme. When typing, one paragraph is separated from another by a carriage return character, which is entered by pressing Enter .
Before formatting paragraphs, it is advisable to remove all unnecessary characters, for example, extra spaces at the beginning of lines. In order to make such symbols descriptive, click the button " Non-printable characters»On the vertical main toolbar.
Figure 17. Display of non-printable characters
To format a paragraph, there is no need to select it, just place the cursor anywhere in the paragraph and select the Format → Paragraph menu item, or the Paragraph item in the drop-down menu invoked by the right mouse button. In the dialog box that appears, you can configure all the paragraph formatting options: line spacing, indentation for the first line (paragraph indentation) and for the entire paragraph, tabs, as well as the border and background of the paragraph. Buttons for aligning a paragraph are moved by default to the contextual panel.
Figure 18. Dialog box "Paragraph"
The button for changing the tabulation mode is to the left of the horizontal ruler. Consecutive clicking on it with the left mouse button changes the type of tabulation:
Left
The text will be limited to the left and typed from this position to the right.
On rightThe text is delimited to the right and output from that position to the left.
CenterText is displayed evenly to the left and right of the tab stop.
DecimalText printed before the separator character (Mark field) will be displayed to the left of the tab stop, and text after it will be displayed to the right. This type is necessary primarily for aligning columns of numbers with an unequal number of digits before and after the decimal point. When using it, all the commas in such numbers will be exactly one above the other. However, if you change the value of the Sign field, you can use this type of alignment for other purposes.
Hyphenation
When using paragraph alignment, in many cases, the distance between words in the text increases, which is especially noticeable in the presence of long words. In this case it is advisable to use hyphenation.
In order for OpenWriter to be able to place hyphenations in the text, you need to set Russian in the language properties (menu Tools → Options → Language settings → Languages, the "Western" field).
Hyphenation can be done automatically or manually. Automatic hyphenation is set in the paragraph properties - in the "Paragraph" dialog on the On page tab in the section Hyphenation you need to enable the "Automatic" option.
You have the opportunity to manually designate the location for the desired transfer: for this you need to put the so-called soft transfer. Place the cursor on the position in the word where you can make a hyphen, and insert a soft hyphen with a key combination Ctrl -- ... You can search for all hyphenable words using the function Hyphenation in the Service menu.
Figure 19. Dialog box " Hyphenation»
The = sign means the place of possible transfer; - indicates the place where it will definitely be produced. To install the transfer, click the "Transfer" button; to terminate hyphenation, use the "Cancel" button. You can go to the next word without setting the hyphenation in the current one by clicking on the "Next" button. Previously set transfer can be canceled using the "Remove" button.
In order for a word to never be hyphenated, you need to add it to the dictionary with an = sign at the end.
Formatting lists
OpenWriter has extensive list formatting capabilities. Numbered and unnumbered lists with deep nesting are supported. To format the list, place the cursor on the paragraph where you want to start the list and click the Numbering or Bullets button on the contextual panel, depending on the type of list you need. All paragraphs following the current paragraph will be converted to a list.
When working with a list, the contextual panel will change its appearance. An arrow-shaped button will appear in the right corner, which calls or hides the contextual numbering panel. Calling this panel, you can adjust the nesting depth of the lists, the appearance and methods of marking the text.
Figure 20. Contextual numbering pane
The contextual numbering bar can also be invoked with the function key F12 and the dialog box Numbering / marking right-click from the drop-down menu, or via the Format menu → Numbering / marking.
Figure 21. Dialog box " Numbering / marking»
Formatting a character, groups of characters
To format a group of characters, you first need to select them. Then you can select the required font, its style and size, design effects, the position of the group of characters relative to the line in the Format → Font menu.
Figure 22. Symbol formatting dialog
Some sections of this dialog box have been moved to the context panel to speed up formatting. From the contextual panel, by default, you can select the name of the font, its size, main styles and color. You can add or remove a button from the contextual panel by right-clicking above it and selecting Show Buttons from the drop-down menu.
Spreadsheets
OpenCalc main window
After loading OpenCalc, the main window appears on the screen. The main difference between this window and the similar one in OpenWriter is that an input line appears under the context menu. It is intended for entering values and formulas into table cells.
Figure 23. The main OpenCalc window
Working area of the sheet
The sheet field consists of cells. A cell is the smallest structural unit in a spreadsheet; it has an address defined by vertical and horizontal coordinates. The first is the column name (the first part of the address); it can range from A to IV. The second is the line number (the second part of the address) and has a value in the range from 1 to 32000.
To the right and top of the worksheet are rulers with column and row names. To select an entire column, click on the cell with its name on the top ruler; to select the entire row - by the cell with its name on the left ruler. The selected row or column name is displayed in bold; if you select one cell, then both parts of the address located on the rulers will be displayed in bold.
V status bar information about the operating modes of the table is displayed.
The selection of a sheet for work is carried out by clicking the left button; if you right click on sheet navigator, a dialog box will open where the following operations will be available:
Insert - creates a new sheet.
Delete - used for unnecessary sheets.
Rename - allows you to assign a different name to the sheet.
Moving / copying - allows you to make copies of sheets, transfer existing sheets to other documents, change their order.
Select All - selects the entire sheet.
Data input
Data is entered into a specific cell: before entering anything, you need to select a cell. The text you type will appear in the cell where you enter your text and in the input line (at the top), which is especially useful given that a cell can contain more characters than its current width can display.
If adjacent cells to the right do not contain values, then the entered line will be displayed in full; otherwise, only part of the row will be displayed and a red arrow will appear in the cell.
To display the entire information, you must either stretch the cell to its width or allow line breaks.
Figure 24. Entering data into a cell
There are several ways to change the width (height) of a line:
Automatically
Double-clicking on the right border of the column name - and OpenCalc will adjust the width for the column, choosing the width necessary to display the cell with the longest content. The same can be done through the menu: Format → Column → Optimal width
ManuallyLeft-click on the border of the column name and, without releasing it, move it to the desired width.
ExactlySelect any cell in the column whose width you want to change, and then the menu item Format → Column → Width; in the window that opens, enter the exact size.
To enable line breaks, click Ctrl -Enter, or right-click on a cell and select Format Cells, or select the Format → Cell menu item and then - the "Alignment" tab; here check the "Line break" checkbox.
Figure 25. Cell Attributes Dialog Box
In the same window, you can set the vertical and horizontal alignment of the text and the direction of writing (the angle of rotation of the text). Alignment allows you to define the position of text in a cell (left, right, center, bottom, top) Writing direction allows you to write in cells at a given angle.
It should be noted that if the text starts with an = sign, then it is not displayed in the cell, because OpenCalc treats such text as a formula. If you need to print text starting with the = sign, then you must put the single quotation mark as the very first character. If there is a need to start a line with a quotation mark, then you must enter the quotation mark twice.
Entering formulas
One of the purposes of spreadsheets is computation, so the basic rules for typing formulas will now be covered.
As already noted, entering a formula begins with an equal sign, then the formula itself is written. For example: = 4 + 16. Writing down such a formula and pressing Enter, we will see the number 20 in the cell. Of course, formulas without variables usually do not make much sense, so now let's see how to use variables, which are cell addresses in OpenCalc. For example, if in A1 we wrote down the number 20, then if we write in B1 the formula = A1 ^ 2 and press Enter the number 400 appears in cell B1.
Basic arithmetic operations available to OpenCalc:
In addition to these operations, OpenCalc provides an extensive set of functions in the following categories:
work with databases;
processing of times and dates;
financial;
informational;
brain teaser;
mathematical;
work with arrays;
statistical;
text;
additional.
For the convenience of writing formulas in OpenCalc, "" is developed. To call it, click the "" button to the left of the input line.
In the Wizard window, you can type functions and check the correctness of their set; the list of available functions depends on which category you have selected. In addition to the categories listed above, for convenience, added "All" and " Recently used».
Figure 26. Function Wizard
In the "Formula" edit field, the current formula is displayed, which can be edited directly, or, by placing the cursor in the required position, double-click on the function name from the list, and the selected function will be inserted into the input window. All that remains is to either enter the argument from the keyboard, or click the button with the cell image and select the cell whose value will be the argument.
In the "Structure" tab, the typed formula is expanded into a tree, which helps a lot when editing formulas, allowing you to track the order in which the formula is calculated.
For the case when the formula is simple enough (contains the signs +, -, *, /, ^), but consists of a relatively large number of variables, consider the following example:
Let it be required to calculate A1 + C5 * B4; for this:
Press = and then use the cursor arrows to select cell A1 (the first press of the cursor key will display a red cursor rectangle). Then press + and select C5, press * and finally select B4. In this way, using the keyboard, you can quickly form formulas (cells can also be selected with the mouse pointer).
After entering = and any letter, OpenCalc automatically displays the name of the function starting with that letter. This feature allows you to type not the entire formula, but only its first letters, and then, if the proposed function is exactly the one you need, you just have to press Enter .
It so happens that when entering formulas as their arguments, you need to pass not the address of a cell, but a whole area - for example, you need to sum all the values in column A, starting from address A2 to address A11. Of course, you can write = A2 + A3 + ... + A10 + A11 - but it is much easier and in any case it would be more correct to write = Su, then use the hint (Sum) and by pressing Enter, write the range A2: A11 in brackets.
The area of the worksheet is specified by indicating the address of the upper left cell, then a colon is put and the lower right cell is indicated. The area can also be set using the mouse.
Autocomplete
Sometimes it is required to perform the same type of calculations for a large amount of the same type of data. A spreadsheet allows you to enter a formula only once - when you copy it to another cell, the parameters will be automatically replaced with new values.
Let the task be to calculate cos (x), where x is given in degrees. To solve it, we will perform the following actions:
Enter the text "Angle" in cell A1, the number "0" in cell A2, and "1" in A3. Select cell A2 and, without releasing the mouse button, also cell A3. Cells can also be selected using the cursor keys: select A2, then press Shift -arrow to down .
Next, move the mouse over the lower right corner of the selected area; the cursor changes to a cross. By pressing and holding the left mouse button, select an area of 360 cells with a red rectangle, that is, the last selected cell should be cell A361. In this case, the number 360 will appear in the yellow rectangle of the tooltip.
An example of autocomplete has just been analyzed. OpenCalc, when expanding the red selection area, automatically increases the cell values by one. In principle, it would be enough to just enter "1" and just multiply the cell, since OpenCalc by default multiplies cells in an arithmetic progression with an increment of "1". If you hold Ctrl, then the cell values will be multiplied by simple copying.
Now we can just as easily calculate the values of the cosines of all angles; first, you need to return to the top of the page with Ctrl -Home(return to the beginning of the sheet) either Ctrl -up arrow (go to the top margin of the block).
Enter in B1 "cos (angle)", and in B2 in Latin "= c" and press Enter; further, having switched to Russian, "p"; Enter, left arrow and Enter... So, by pressing just a few buttons, the formula "= COS (RADIANS (A2))" was introduced. Now, with the cross-shaped cursor hooking the lower-right edge of the cell, you can apply the formula to all angle values. The result is the cosine values of all angles.
Cell format
OpenCalc, like any modern spreadsheet, supports various formats of data in cells that determine how it appears in the table. For example, text 3/4/01 will be set to Date format. If we change the format of the cell to a number, then we get 36954.
In order to change the format of a cell, right-click on the cell and in the context menu select Format Cell and in the window that opens, the "Numbers" tab.
In our example with calculating the cosine, change the number of displayed decimal places (the value of the parameter fractional part) by 7. Our format will be automatically entered in the Number and User Defined categories.
Links
Let's go back to the cosine example. Let now it is required to calculate the function "cos (angle + phase)". Let's say the phase is constant and should be stored in cell C2. Then change the formula in B2 from "= cos (radians (A2))" to "= cos (radians (A2 + C2))" and multiply by all 360 values. There will be practically no effect: the fact is that we did not say that our phase is constant, that is, the formula “= cos (radians (A3 + C3))” was written in cell B3. There is no data in C3, so OpenCalc assumes that C3 contains "0". To prohibit changing a variable by column or row, you need to write a $ sign in front of the coordinate. Now we prohibit changing the row coordinate by changing C2 to C $ 2 in our formula.
For quick insert$ in the edited address is convenient to use the keyboard shortcut Shift -F4... If you press this combination once, the $ sign is added to the column coordinate and the row coordinate; two times - only to the row coordinate, three times - to the column coordinate. The fourth press is equivalent to the first.
Since an OpenCalc document contains multiple sheets, it is possible to address between sheets as well. Up to this point, we have considered single-leaf local addressing; the full cell address looks like this:
<Название листа>.<Локальный адрес ячейки>.
Diagrams
Now it remains to insert the diagram of our calculation. This is done very simply: Two columns A and B are selected. From the menu, select Insert → Chart
Figure 27. Chart auto-format
In our case, the first line is the label of the x-axis, so we leave the checkbox “ First line as signature". The range of values recorded in the "Area" field was determined automatically, it is, as expected, equal to "$ Sheet1. $ A $ 1: $ B $ 361".
Our diagram can be placed either on one of the existing sheets, or on a new sheet. If you place a diagram on a new sheet, then it will occupy it completely, which is very convenient for printing diagrams on a whole sheet. In our example, Sheet1 is selected to place the chart.
After filling in each dialog box, you need to click the "Next" button and select the type of diagram in the next window:
2D charts
Lines; with areas; bar graph; ruled; circular; XY chart; mesh; exchange.
3D charts3M chart; with areas 3M; 3M histogram; ruled 3M; circular 3M.
Since in our case the diagram is built on two columns, we will select the XY-diagram. Data series are specified in columns.
Figure 28. Selecting an XY chart
Then we will refine the version of the diagram. Let's indicate the name of the diagram; since there is only one dependency on it, uncheck the legend box. Enter the labels for the X and Y axes. Then you need to click the "Finish" button.
Figure 29. The diagram is built
Using OpenDraw
With OpenDraw, you can provide any OpenOffice.org document with high-quality illustrations - be it a word processing document, spreadsheet, or presentation. In addition, it is possible to export the drawing to other applications using widely used graphic formats.
Types of images
OpenDraw allows you to create both vector and bitmap drawings. Raster images consist of a limited number of dots and the image in such patterns is formed by a combination of dots of different colors. As a result, raster-type pictures are not scaled - more precisely, they do not look good after resizing. At the same time, bitmap images are well transferred from one program to another, since in essence they are reduced to a simple array of points.
Vector drawings are drawings that consist of objects (lines, rectangles, circles, gradients, etc.) and do not have a fixed resolution; however, they can include bitmap images as objects. Vector graphics are perfectly scalable and can be converted to raster form at any given resolution at any time. This property makes vector drawings the preferred choice for document illustrations; at the same time, when exporting a document to any format external to OpenOffice.org, vector images cannot always be used and in such cases they are converted to raster images.
The OpenDraw program is mainly intended for creating vector drawings; to work with bitmaps there are applications like gimp.
The rest of this tutorial will discuss mainly vector art; Bitmap images will be considered only in terms of their use as part of a vector image, as well as in the context of converting vector images to bitmaps.
Principles of working with the program
Figure 30. General form the main OpenDraw window
The menu area is located at the top of the main window; below - panels of functions, hyperlinks, objects; on the left, the toolbar is vertically located, a little to the right - the ruler, even lower - the panel of symbols, colors, and finally, at the very bottom of the main window - the status panel. Any of the listed panels can be turned on or off through the menu View → Symbol Bars.
In the central part of the main window of the program there is a drawing worksheet. The scale of the worksheet display is set through the View → Scale menu or using the "Scale" tool on the toolbar.
Graphic primitives
Under graphic primitives the minimal graphic objects that make up the vector drawing are understood. Graphic primitives in OpenDraw include: lines and arrows; rectangles; circles, ellipses, arcs, segments and sectors; curves; connecting lines; three-dimensional objects (cube, ball, cylinder, etc.); text. More complex objects can be composed of graphic primitives using the combination function and logical operations on forms; more on this later.
To create a primitive of one of the listed types, press and hold the button of the corresponding primitive group on the toolbar. Then, having selected the required primitive from the drop-down list of icons, release the button. As a result, the mode of primitive creation is activated, in which you need to specify with the mouse the location of key points and distances of the primitive. Different primitives have a different number of parameters: for example, a simple line has only two parameters, and a curve has an unlimited number. Below we will talk about the features of creating various primitives.
Lines and arrows
To create a line, specify the start and end points of the line on the drawing sheet: the start point of the line is set with the left mouse button; then, without releasing the button, position the cursor on the end point of the line and release the button - the line is created.
Connecting lineThis object is created in the same way as a regular line. A feature of the connecting line is the ability to snap to objects, therefore, when creating a connecting line, instead of the start or end point of the line, you can specify some object - the program will pick it up best point joining a line to it.
RectanglesHere you need to specify the position of two opposite vertices of the rectangle: specify the first by pressing the left mouse button; then, without releasing it, move the cursor to the second point and fix the shape by releasing the button.
Circles, ellipses, arcs, segments and sectorsTo create a circle or ellipse, it is enough to indicate the size of the primitive with two points: specify the first point by pressing the left mouse button without releasing it, move the cursor to the required distance to the second point and release the mouse button. The circle or ellipse will be inscribed in the rectangle specified by the start and end points. To get an arc, segment or sector, you need to specify two more points on the contour of the circle or ellipse, also pressing and releasing the left mouse button.
3D objectsTo define a three-dimensional object, you must specify its maximum size in one of two dimensions. A three-dimensional object is created in fixed proportions, which can be changed after its creation.
TextA text object is created by simply clicking the left mouse button in the desired place on the sheet: a typing frame with a text cursor will appear.
When creating text inscribed in a frame, first set the frame with two points: press the right mouse button at the first point, move the cursor and release the button at the second point. The font size will be automatically selected so that the text occupies the entire area of the specified frame.
LegendA legend is a box with an arrow that is usually used to explain a part of a drawing. It is set, like a regular frame, with two points using the right mouse button. Then you can insert text inside the legend frame by double-clicking the left mouse button on the frame. As you enter text, the legend frame automatically resizes.
Bezier curvesBased on trigonometric equations, the French mathematician and engineer Pierre Bézier created a special way of describing complex contours in a simple yet flexible way for metal-cutting machines used in the automotive industry; this method was called Bezier curves and, due to its simplicity and flexibility, subsequently became one of the most important methods of computer graphics.
Bezier curves are drawn from multiple points and guide lines. The points along which the curve is drawn are called reference points; each of them is characterized by two line segments located on the tangent to the Bezier curve at the anchor point (they are called guides). The length of each of them sets the steepness of the next or previous segment of the curve, and the angle of the tangent sets the direction in both directions from the anchor point.
When creating a curve in OpenDraw, its control points are sequentially indicated using the left mouse button. If, after pressing the button to create an anchor point, you do not release the button, you can set the angle and length of the guides; if the button is not held down, the length of the guides will be zero, and such a point will be angular. The track of the first anchor point must be specified, otherwise the operation is canceled. Double-clicking with the left mouse button finishes drawing the curve.
Important
Note that when creating a curve, the length of the guides in both directions is the same. You can change the lengths of the guides separately after creating the curve using the point editing tool.
Comment
Holding the button Shift in the process of creating a curve, allows you to specify angles in multiples of 45 degrees; to close the curve, you can use the button Alt .
In the X Window System, the Alt can be used by the window manager, preventing this operation from being performed. For example, KDE uses by default Alt combined with the left mouse button pressed to move the window. However, you can close the line by pressing Alt after the right button. The line will be closed, but the last anchor point will be the corner. This is easy to fix with the Point Editing Tool. You can also change the settings of the window manager by specifying a different modifier instead of Alt .
Hand drawn lineTo create a hand-drawn line, by pressing and holding the left mouse button, draw the desired curve by hand. The drawn line is also a Bezier curve, only the number of anchor points, the values and angles of the guides are automatically determined by the program.
PolygonsPolygon creation consists in specifying all the vertices of the polygon. The first vertex is indicated by pressing the left mouse button to indicate the second - release the mouse button, otherwise the operation will be canceled; the rest of the vertices are indicated by a normal left-click, and the last vertex - by a double click. As with creating a curve, you can use Alt to close the polygon and Shift for drawing with angles in multiples of 45 degrees, respectively.
Properties of graphic objects
Each object - already modified, combined, converted, or just a graphic primitive - has a certain set of characteristics, such as size, color, rotation angle, font family and size, etc. Moreover, from the point of view of modification, objects can be divided into three groups:
graphical objects characterized by an area (most objects);
graphic objects characterized by private properties (lines, connecting lines, legend);
text objects (plain text).
To change the parameters of objects, first select the object by clicking on any part of it. The program will confirm the selection by highlighting the area where the object will be placed with square dots. At the same time, primitives that are characterized by an area, as well as text objects, are highlighted by a field of eight green square dots, the rest are highlighted by turquoise dots, which indicate the key points of the object.
You can select several objects at once using the left mouse button while holding down the button Shift- in this case, the selected objects will be highlighted with one field of eight points and all further operations will affect all selected objects.
The selection area of an object can be stretched, moved, rotated, etc. plain text does not change the size of the text; in all other cases, resizing the selection area causes the object to be scaled.
Resize and move
The vertex points of the rectangular area of the object are used to resize the object in two dimensions at the same time, and the points on the sides are used in only one. To perform these actions, grab the desired point with the mouse, stretch the area and release the button.
For objects of the second type, when resizing, control points are used - in much the same way as when resizing an area, however, in this case, the resizing occurs according to the rules of the object itself: for example, for a Legend, lengthening the pointer arrow does not change the annotation area.
The text object area frame sets the text box and the line width; resizing it does not change the font size. On the contrary, the text inscribed in the frame depends on the size of the specified area, in this case the text is scaled automatically so that all the text fits in the specified area.
To move an object, left-click on any part of the object, move the object without releasing the button, and after releasing it, commit the change.
Text inside objects
Almost all objects (except three-dimensional ones) can contain text in one form or another. For text objects, this is, of course, the main function; for others - additional.
If you do double click with the left mouse button on the object, a cursor will appear, which allows you to enter or correct text inside the object. Its properties can be changed in the same way as for text objects - using the tools of the object panel, the Format menu or using context menu.
Effects
For other operations on objects, such as rotation, mirroring and others, use the effect panel.
With the rotation tool selected in the Effects panel, you will see that the selection points of the object will take on a circular shape. Depending on the type of object selected, each point gives access to different functions. When you hover the mouse over the desired point, the cursor changes its appearance, indicating a possible operation; in addition, when an operation is performed, the title and details of the current operation appear in the status bar. If for the selected object the function corresponding control point, is not applicable, the cursor changes to a circle with a line through it.
The vertices of the object's selection rectangle can be used to rotate the object in the plane of the sheet. Moreover, the rotation will occur relative to the center, shown in the form of a small circle with a cross. By default, the center of rotation is set exactly in the center of the object's selection area, but you can move it with the mouse to any point on the page. For 3D objects, points at the vertices of the marquee allow you to rotate them in the plane of the sheet.
Points on the sides of the object's selection area are used to distort the object in the appropriate direction. For 3D objects, these points allow you to rotate them in a plane that is perpendicular to the sheet plane and parallel to the side of the rectangular marquee containing the selected control point.
The Effects panel allows you to perform other useful operations on objects, such as deformations, mirror reflections at any angle, building an object by rotating a flat prototype, and adjusting transparency.
Using the point editor
The point editing mode can be invoked via the Points edit tool on the objects panel (or options), the context drop-down menu (the Points edit item), or using the keyboard button F8 .
This mode is available for objects constructed from Bezier curves. If you need to change the shape of a different type of object using the point editing mechanism, you will first need to convert the object to Bezier curves using the Convert item of the context drop-down menu (this applies to most objects).
In the point editing mode, you can change the point type, close the curve, add and delete points using the point editor tools that appear on the object panel after you turn on the point editing mode. Select the desired point with the right mouse button - it will be possible to change the angle and dimensions of the guide lines of the selected anchor point. Thus, you can change the degree of bending of the line on different sides of this point.
The control points themselves can be moved, deleted, added and changed their type. In addition, the Edit Points panel contains tools to close or open the curve and convert the line to a Bezier curve.
For convenience, OpenDraw distinguishes between three types of anchor points:
Symmetrical transition
Anchor point with equal-length guide lines. When you change the length of one symmetrical transition guide, the second also changes the length.
Smooth transitionThis is a common anchor point with different lengths and separately adjustable guides.
Corner pointThis is the anchor point at which the curve seems to break. The corner point direction lines may not be on the same line and may vary in length.
Having selected the desired anchor point, you can easily change its type using the tools on the "Edit Points" panel.
Area properties
The area of the object, if it exists, can be very flexibly configured through the tools of the object panel (the Format → Area menu or the Area context menu). It can have different fillings, cast a shadow and be transparent. The fill can be a color fill, a gradient fill, a hatch, or a bitmap texture. Shadow and transparency also have their own settings, which can be found on the corresponding tabs of the area properties window.
Line properties
Every OpenDraw object contains lines - even if it is a text object and its border is not displayed by default. The dialog box that allows you to customize the appearance of these lines can be called through the tools of the object panel, the Format → Line menu, or through the Line context menu. In this case, you can change the color, thickness, set the transparency and provide the ends of the line with arrows of various types.
Text properties
For text and objects containing text, it is possible to change the appearance and properties of the text through the tools on the object panel, the Format menu or the context menu.
Text properties are called using the tools of the object panel, the Format → Text menu or the Text context menu. Here it is determined whether the text will fit into the frame or vice versa - the text will set the size of the frame, as well as whether various creeping line effects will be applied when the text is displayed on the screen.
To change the properties of characters and a paragraph, use other items of the Character and Paragraph menu of the context menu or the same items of the Format menu.
Object naming
To simplify the work with pictures of a complex structure, OpenDraw has the ability to assign names to objects of some types, which then appear in the status bar every time you select an object. In addition, the named objects are displayed by PathFinder as separate elements of the drawing structure.
You can assign a name only:
a group of objects;
inserted objects: bitmap, OLE object, formula, etc.
Graphic Styles
Like a text document, a picture can contain styles, but only of one type - graphic. Graphic style is a comprehensive set of attribute values for a wide variety of graphical objects. When applied to an object, a style overrides the values of the attributes of the given object, substituting the values specified for this style instead.
Graphic styles are especially useful for creating complex drawings with repetitive elements; they are indispensable for drawings, various schemes, diagrams, etc. To create, modify, apply and delete them, it is most convenient to use the Style Wizard, which can be called from the Format menu → by pressing F11 or tool (" On off. Style Wizard») On the function bar.
Having selected an object or several objects using the Style Wizard, it is easy to apply any style: just double-click on the desired item in the Style Wizard window.
To change a style, just select it with a mouse click and select Change from the drop-down menu. Changes to the style will affect all graphic objects to which it was applied.
Converting objects
Any object in OpenDraw can be transformed into one form or another, depending on its type; possible options are contained in the Transform context menu, which displays a list of valid transformations for the selected object. So, for example, for three-dimensional objects there are only two options, and for a rectangle there are already seven. By transforming objects, you can get new objects with completely different properties than the original object, as well as different in appearance.
Positioning objects
OpenDraw has powerful tools for positioning objects. It is often necessary to align objects relative to each other, page or line; to perform these actions, use the tools on the Arrange and Align panels, as well as the Distribute item on the context menu or the Actions menu. The tools in the options bar help you position objects precisely.
Alignment
Any object can be aligned relative to the page margins using the appropriate tools in the "Align" tear-off panel.
There are separate tools for horizontal and vertical alignment - center and edge of the sheet. If you select several objects at once (while holding down the Shift), you can use the same tools to align objects relative to the edges or center of the selection area.
Location
Depending on the order of creation, an object can overlap part of another object (s) or be overlapped by another object (s). To control the position of objects in depth, use the tools of the "Arrange" tear-off panel.
The panel contains tools for moving an object directly to the front or back, sequentially changing its position (behind the object or in front of the object), changing its position relative to a specific object. It is also possible to swap (in depth) two objects.
Distribution
This function makes it possible to align multiple objects with respect to each other so that the distances between the objects relative to the contours or centers of objects are equal. In this case, the outermost objects in the chain do not move.
In order to use this function, you must first select three or more objects, and then select the Distribute item in the context menu or in the Actions menu.
Precise object placement
The OpenDraw options panel has a number of handy tools to help you accurately position objects relative to each other or to the sheet. Precise positioning is carried out by creating special marks or markers in the form of dots or lines on the drawing field, which can later be used to facilitate the alignment of objects. Such labels are called bindings.
OpenDraw supports several types of bindings:
net
A grid is superimposed on the page margin. When this snapping is enabled, objects can be moved or scaled strictly along the grid points.
guide lineIt can be horizontal or vertical. To create this anchor, you need to left-click on the vertical or horizontal ruler and extend the line to the desired location on the sheet.
custom bindingThe user has the ability to set a snap in the form of a line or point anywhere on the sheet with millimeter precision. Such a binding is created using the Insert menu → Line / Anchor Point
To perform actions on several objects at once, it is convenient to use the grouping function. To create a group, you must first mark several objects by holding the button Shift, and then select the Group item of the context menu (or the Actions menu) or use the hot button Ctrl -Shift -G .
Comment
If you are using Ctrl -Shift as a keyboard switcher and noticed that similar combinations are used in many applications, try setting up language switching by Caps lock (in this case, the latching of the register is switched by Shift -Caps lock), it is more productive.
The created group behaves like a permanent selection of several objects. The advantage of a group over the usual selection of several objects is that it eliminates the possibility of forgetting to select an object before the operation.
A group can always be split using the item Ungroup context menu or Actions menu, or using a combination of buttons Alt -Ctrl -Shift -G .
To edit the objects included in the group, there is no need to split the group - the operations of entering and exiting the group are intended for this. You can use the items Enter the group (Exit the group) of the context menu or the Actions menu, or the hot button F3 (Ctrl -F3 ).
You can leave the group by double-clicking the left mouse button outside the group area, and enter, respectively, by double-clicking on the area of any object included in the group.
After you enter a group, objects that are not included in this group are displayed more dimly. This is done in order to make it easier to distinguish objects included in this group from others, as well as to indicate the mode of being in the group.
Combining objects
Unlike grouping, which is mainly necessary to perform a series of identical operations on a large number of objects, when combined, the selected objects are created new object with new properties. The resulting combination inherits the properties of the object created first, or more precisely, the one behind all other objects selected for the combination. You can only combine objects that can be converted to Bezier curves.
It is as easy to create a combination as it is to group objects. To create a combination, you must first mark several objects (while holding the button Shift), and then select the Combine item of the context menu (or the Actions menu) or use the hotkey Ctrl -Shift -K .
At the intersection of objects in combination, transparent holes appear; this property is a payment for being able to split a combination. This method can also be used as a temporary union of objects before performing logical operations on them.
The resulting combination can always be disconnected using the item Disconnect combination context menu (or Actions menu) or using a combination of buttons Alt -Ctrl -Shift -K .
When combining certain types of objects, the object is (irreversibly) converted to Bézier curves, so although the combination can always be uncoupled, the combining operation is not completely reversible.
Logical operations on objects
OpenDraw allows you to logically add, subtract and intersect objects. To perform logical operations, you must select several objects (while holding the button Shift), then use the Merge, Subtract or Intersect items of the Form context menu or the Actions → Form menu to perform the required operation. As a result, a new object is formed, inheriting the properties of the oldest (or, more precisely, located deeper than all the others selected).
Logical operations are irreversible, so if you want to undo an operation, then the only way is to use the OpenDraw undo function, which is available through the Edit → Undo menu or by the hot button Ctrl -Z .
Next time you boot, check the box “ Don't show this dialog again". If you want to have an idea of how the presentation will look, leave a check mark in the "Preview" box.
The transition to the next window is carried out by pressing the "Next" button. In the second step, you need to set the slide style and “ Presentation Shower". In the third window, you can select options for switching between frames in the presentation.
Then click the "Finish" button. A window with a dialog for creating a slide will open. Here enter the name of the new slide, define the layout (view) of the slide and the options "show background" and " show objects in the background».
To add a new slide, right-click in an empty space and select Slide → Insert Slide from the context menu or via the Insert → Slide menu - the slide creation dialog will open.
OpenImpress allows you to make a copy of a specific slide and paste it as a new slide: choose Insert → Duplicate slide.
Presentation modes
On the right side of the control bar, on the scroll bar, there are six tools for controlling the presentation mode.
The top button "Drawing mode" is used to view and edit slides separately. When this mode of operation is selected, the tabs with the names of the slides will be visible at the bottom left of the horizontal scroll bar - to go to the desired one, just click on the tab with its name.
The next tool allows you to switch to the view of the slide structure, which is presented in the form of a hierarchical list; the first level of the hierarchy is the slides (their titles are displayed). To go to any slide, you need to select any element related to it; here you can edit the title. To add a slide, just enter the text and make it the first level of the hierarchy (to change the level, use the keys Shift -Tab , Tab or toolbar).
The next tool, Slide Mode, controls the order of the slides. To change the order, simply drag the slide from one place to another.
Tool " Annotation mode»Allows you to enter text that will only be visible in annotation view.
Abstracts Mode allows you to place slides on one page and enter their descriptions.
In the lower left corner there is a toolbar that allows you to add a background to your slides; you can switch between slide mode and background mode (the first two buttons are used for this).
In "background mode" you can add a background that will be visible on all slides, but it will not be editable. You can add, for example, a text caption or a picture. In order for the background to be visible or not visible on a specific slide, right-click on the slide and in the context menu select Slide → Slide Style and then slide style with or without background. In the same dialog, you can select one of the possible styles by clicking on the "Load" button, and by selecting the desired one, confirm the choice.
Working with a slide
To work with a slide, you can use the tools located on the main toolbar (on the left):
The arrow tool is used to select objects. The next tool in the form of a sheet of paper with a magnifying glass is used to change the scale of the document; in its menu there are several buttons that allow you to select the optimal scale of the document.
The next group of tools is used to insert various objects on the slide - text, rectangular shapes, ellipses and circles, three-dimensional objects, curves, lines and arrows, connecting lines.
The following group of tools is used to change the position of an object. For example, to rotate an object, you can select an object, click on the rotation button and, grabbing the red handles around the object with the mouse, rotate the object in different directions. To align an object on the page (both horizontally and vertically), use the following tool. The Arrange tool lets you change the overlapping ("layering") order of objects.
A group of elements that change the effects of objects to make your presentation more attractive; it "hides" behind the "Effects" button. Buttons for selecting effects allow you to select an object to which they will be applied. The first allows you to choose options for the appearance of the slide, the second - only text effects.
Below in the drop-down list, the category of effects is specified, from which the required one is eventually selected; the speed of its execution is also set. To assess the consequences, click on the " Preview window". To apply the effect to an object, use the Assign button.
After clicking on the "Order" button, a list of the order in which objects appear in the presentation slide appears, you can change it simple drag and drop the selected object to the desired position.
The next button on the left toolbar is Interaction, which allows you to define what action should be taken when an object is clicked. This can be a transition to a slide, the execution of a program, and much more.
The penultimate tool lets you apply 3D effects to an object. The latter tool provides a presentation view mode.
Once you've created a slide, you can always edit it. The title of the created slide can be changed by clicking on the object with the inscription “ Add title with mouse click". The name of the created slide is displayed on a tab next to the scroll bar. If you right-click on it, you can rename the slide, delete it, insert a new one, or change the slide layout. Text properties can be changed by selecting one of the items in the drop-down context menu.
The Text item allows you to set the properties of the text and the creeping line effect. On the “Text” tab, the frame properties are set: the size and position of the text. On the tab "Creeping line" you can set the effects for the animation of the text.
To add a picture, click on the icon with the house and select the picture in the dialog that opens. Right-clicking opens the following properties of the picture:
Text
Effects of text overlaid on an image. (The text can be superimposed on the image by double-clicking the left mouse button).
Position and sizeSets the position, size, rotation, skew of the image.
Original sizeSets the initial size of the image.
Color resolutionAllows you to set the tonal depth of the image, that is, the number of bits allocated for encoding the color of each point. Greater depth means more shades displayed.
LocationDetermines the level of the object in the "stack".
AlignmentSets the position of the object on the slide (left, center, right, top, middle, bottom).
ReflectAllows you to flip the image vertically or horizontally.
ConvertAllows you to transform an image into a polygon, outline, three-dimensional object, body of revolution, bitmap. These properties are not always available.
Give a name to the objectAllows you to name objects for convenience.
the effectAllows you to apply one of the available effects to the object.
In addition to being able to position objects on a slide, you can specify a slide background. To do this, right-click in free space slide and select Slide → Page settings... In the dialog that opens, open the tab “
Slide transition effects
Slide transition effects can be set in the second step of the Presentation Wizard. If this has not been done, correction is needed or you need to make different transitions between slides - use the menu item Demonstration → Slide Transition: the dialog for setting the transition effect to this slide will open.
This dialog is similar to the dialog for setting transition effects, but has an addition - a time control button. With its help, you can set the time between slide changes, which, in turn, can be automatic, semi-automatic and manual. The first option indicates the time after which the transition to the next slide will be made.
You can view the created presentation using the button from the menu Demonstration → Demonstration or a keyboard shortcut Ctrl -F2 .
Working with databases in OpenOffice.org
Now is the time to talk about how OpenOffice.org works with data. Indeed, for any modern office suite, working with data is an absolute must. Indeed, one of the main tasks when using computers in everyday life is precisely the processing of large amounts of data.
It is assumed that the reader has some idea of how database management systems, abbreviated as DBMS, are arranged.
It is usually customary to include your own DBMS and tools for working with it in an office suite. However, it doesn't make a lot of sense. A DBMS is a complex system that requires significant resources, care, systematic archiving of data and special knowledge for such manipulations. The creators of OpenOffice.org chose a different path - they included in their package a mechanism for accessing data from any application, be it OpenWriter or OpenCalc, leaving data storage to other programs.
Let's get to know this data access mechanism in practice. Launch OpenWriter and create new document or open an existing one. Click on function key F4 or select in the main toolbar " Data sources". The data access panel will open at the top of the window. So far, it contains only one source entitled "Bibliography". This is the test base that comes with OpenOffice.org.
Let's work with the data in practice to better understand how the access capabilities are implemented. Let's create a small base for keeping track of books in the school library.
Quit OpenOffice.org and create a directory on disk where you will store your data, such as Documents. Go back to the OpenWriter doc. Right-click in the field where the data sources are listed and select "" or select from the menu Tools → Data sources.
Figure 32. Managing data sources
The "" window will open. Click the " New data source". Give the new source a name - let it be Library. Now let's see what databases we can work with. The list is quite impressive - it's the good old Dbase, access using ODBC and JDBC drivers, text files, spreadsheet documents, as well as ADO for accessing databases created in MS Access. We currently do not have databases connected using ODBC, so we will choose Dbase. This is an old and very popular format, those who have been working with a computer for a long time can remember many programs in which it is used, and data in this format is probably stored on their hard disk. It suits our task perfectly. Select the "Database Type" - Dbase and specify the path to the directory that we have created for the data. Open the "Dbase" tab and select "Encoding".
It should be said right away that if you plan to use the files created by Dbase not only when working with OpenOffice.org but also in other programs, to maintain compatibility with them, you should choose the old encoding " Cyrillic DOS / OS2-866 / Russian»And name fields only in uppercase Latin characters no longer than 8 characters per field name. For us now, this does not matter, so for the sake of simplicity, we will choose the "From system" encoding.
Let's open our project Library and select "Tables", "Labels" and "Queries" we do not need. There are no tables, the folder is empty. And rightly so, the table must be created.
Press the right mouse button to open the "Table Project". We need fields for the serial number, author, book title, subject to which this book belongs. Let's also add the state of the book and a field for notes where the librarian will enter service information.
It is advisable to choose the length of the fields according to the principle of reasonable sufficiency - for an author with a surname, name and patronymic, probably 80–90 characters will be enough, for the title it is better to do 255 (this is the maximum value for a text field).
The type of fields depends on their function - for the number it is DECIMAL, let it be an integer, we do not need digits after the comma, for the rest of the fields CHAR (character), for notes VARCHAR (character variable length). Let's create the fields as shown in the figure and save the table, for example, under the name book. We close the "Project table" and see it in our data source. The structure of the table appeared on the right and you can already enter data into it. We will introduce several books for training. For convenience, the width of the columns can be adjusted as we did in Opencalc Our form is good for everyone, but the names of the fields are presented as they are created in the database (that is, in Latin and in abbreviated form). Let's fix the field names. In the main toolbar, find the item " Form controls". A floating form editing window will open. Activate editing mode by pressing the button with the image of your finger. Now select the field for editing. Right-click and select Group to ungroup the field and text label. Select the text label. Now select " Control element". A control window will open - here you can change the title to the Russian name. Those of you who have worked with Microsoft Office's Visual Basic for Application will find many familiar meanings in these menus. Figure 35. Work to improve the appearance of the form
Now change all the text labels and the form is finally ready. Explore all the controls and try adding new ones to the created form.
For example, for the "item" and "state" fields, you can try replacing a simple field with a combo box so that you do not enter the same values for item names and book states each time. In this way, you can create many simple but useful applications.
In conclusion, I would like to advise what to do if you really need a full-fledged database server. Among the free products, there are quite powerful DBMS, which are in no way inferior to their commercial counterparts. These are MySQL, ADABAS, Postgres, FireBird and other very decent products.
[email protected]> and many others.
To everyone who has worked and continues to improve OpenOffice.org, the authors would like to express their gratitude.
When your work is connected with documents, spreadsheets and presentations, it will not be superfluous to get yourself an electronic assistant who will take over part of the routine office processes. OpenOffice can rightfully be called one of the best office programs. This great tool is completely free and includes a solid set of functions for working with documents and databases. Master the full functionality of this wonderful office assistant, making your work more comfortable and efficient.
Beginner course
We present to your attention a basic course that will introduce the greenest users to the OpenOffice.org program. 22 high-quality video lessons are waiting for you, with a total duration of 1 hour 52 minutes. Upon completion of viewing all materials, you will discover many new tools and become a confident user of the OpenOffice suite.The first lesson will show you how to work with text and create documents in OpenOffice. Contains basic knowledge that will hardly interest experienced users.
Learn to customize the appearance of the printed font. Examining the basic tools used to format text.
How do I insert a picture into my document? The answer is in the video.
Add several columns of text to the document.
Let's take a look at a useful function for creating tables in a document.
Highlights of working with tables in OpenOffice Calc.
We prepare a perfect, graphical report using spreadsheets.
How presentations are created in OpenOffice. An overview of the basic steps for creating a good presentation.
Learn to add new slides to your presentation.
Liven up your presentation with spectacular transitions.
Chapter 1. Basic knowledge
Lesson 1. Typing and editing text
Lesson 2. Changing the alignment
Lesson 3. Basic Formatting
Lesson 4. Saving and Printing Text
Lesson 5. Adding images
Lesson 6. Creating a list
Lesson 7. Text in columns
Lesson 8. Footnotes and Headers and Footers
Lesson 9. Creating tables
Lesson 10. Nested tables
Lesson 11. Features of the Tables tool (Part 1)
Lesson 12. Possibilities of the "Tables" tool (Part 2)
Chapter 2. Tables in "Calc"
Lesson 1. Spreadsheets in OpenOffice Calc
Lesson 2. Cell format and auto-substitution
Lesson 3. Building graphs and charts
Lesson 4. Shopping book
Lesson 5. Sorting data and saving
Chapter 3. Presentations
Lesson 1. Making Presentations (Basics)
Lesson 2. Creating Presentations (Slides)
Lesson 3. Creating Presentations (Effects)
Chapter 4. Additional Resources
Adding formulas to a document
Drawing tools
OpenOffice.org User's Guide A. Ionov, Y. Konovalov, A. Novodvorsky, D. Smirnov, I. Trunin OpenOffice.org: User's Guide A. Ionov, Y. Konovalov, A. Novodvorsky, D. Smirnov, I. Trunin Bolshaya the book was edited by: A. Boyarshinov A. Dobrovolsky A. Prokudin L. Khachaturov M. Shigorin Everyone has the right to reproduce, distribute and / or amend this Document in accordance with the terms of the GNU Free Documentation License version 1.1. This Document does not contain any Unmodifiable Sections; This Document contains the following Text placed on the first page of the cover: "OpenOffice.ru"; This Document contains the following Text placed on the last page of the cover: "http://www.altlinux.ru http://www.openoffice.ru"; The text of the License is included in a section titled "GNU Free Documentation License". An unofficial translation into Russian of the GNU Free Documentation License is placed in this book in the section "TRANSLATION INTO RUSSIAN GNU LICENSE FOR FREE DOCUMENTATION" Part I. Getting Started with OpenOffice.org 2 User Guide Chapter 1. Launching OpenOffice.org, Opening a File Launching OpenOffice .org is accessed from the system menu. Linux On ALT Linux1, the system menu items for loading OpenOffice.org components will appear automatically when OpenOffice.org is installed. In order to create a new document in an already open OpenOffice.org, you can use the New button (tool) on the toolbar. A short press (less than 1 sec) will open a document of the same type, a long press will bring up a menu of possible document types: To open a file or create a new one, you can select the "Templates and Documents" item - this opens a dialog box with which you can select the type a new document or open an existing one. In the list on the left, select the directory from which the document or template is loaded; in the list in the middle, select the type of template or document to open. When you single click on an object, you can see the document properties on the right side of the dialog box; double-clicking opens a document or creates a new document based on a template. New document or open file opens in a new window. The list of recently opened files can be viewed and opened in the File menu; to open a file, select it from the list. You can also open the file by entering the URL, or the path and name of the local file in the URL field on the toolbar, or select the opened file from the list of URLs - in this case, the file opens in the same window. This field is autocomplete, i.e. as you enter the initial letters, the system completes the string with the first option. 1 http://www.altlinux.ru Chapter 1. Launching OpenOffice.org, opening a file Table 1.1. OpenOffice.org Document Types Type Text Document Function Creates a new text document Spreadsheet Document - Creates a new spreadsheet document Presentation Creates a new presentation document Figure Creates a new drawing document HTML document Creates a new HTML document Main document Creates a new main document Formula Creates a new document formula Stickers Opens a dialog for creating a label document Business Cards Opens a dialog for creating a business card document Templates and Documents Opens a dialog for selecting a template, a new document or a previously created document 3 Part II. The basics of working with text documents 6 User's Guide Chapter 2. Navigating through the text Navigation through the text refers to the movement of the text cursor to the desired place in the document, which can be done using the mouse or keyboard. The first method is carried out with the help of scroll bars "grabbing" the slider with the mouse or using the arrows on the scroll bar, you can move a part of the displayed document. If the mouse has additional buttons or the scroll wheel, you can navigate the document using them. With the keyboard, you can move the cursor using the arrows and the PageUp, PageDown, Home and End keys. Pressing the left or right arrow moves the cursor one character left or right, respectively. Pressing the up or down arrow moves the cursor one line up or one line down. The PageUp and PageDown keys move the cursor directly one page up or down; Home and End are used to move to the beginning and end of the line, respectively. You can use the arrow keys in conjunction with the Ctrl key — in this case, the left and right arrow keys move the cursor one word (up to space or punctuation) to the left or right, and the PageUp and PageDown keys move to the beginning or end of the document. Chapter 3. Basic principles of working with text 7 Chapter 3. Basic principles of working with text Entering text To enter text, you need to create a new document, or open an existing OpenOffice.org Writer document, position the cursor at the place of the document where you will enter text and using the keyboard, introduce it. By default, the insert mode is used - the text behind the cursor will move along with the new input. If you want the entered text to replace the existing one, change the insert mode to replace using the Insert key. The current mode is displayed on the status bar. When entering text, the autocomplete function is used: long and frequently typed words are supplemented with a variant of a previously entered word with the same beginning. To end a word, use the autocomplete key specified in the AutoCorrect settings dialog (menu Tools → AutoCorrect Word Completion) in the Apply field (by default, the Ctrl key is used). In the same dialog, you can set the auto-completion properties, such as the minimum number of letters in a word to enable the auto-completion function, the maximum number of words to remember, how auto-completion will be displayed (in the form of a hint or at the end of a word), and some others. Deleting Text To delete text to the right and left of the cursor, use the Del and Backspace keys. To delete characters from the cursor to the beginning or end of the current word, use the Ctrl-Backspace and Ctrl-Del combinations. To delete a fragment, you can select it and press the Del or Backspace key. The different ways to highlight text are outlined in the next chapter. Selecting text To select text using the mouse, move the cursor to the beginning of the selected fragment, press the left button and, without releasing it, move the cursor to the end of the selected fragment of text. 8 User Guide The selected text will be displayed in inverted color (by default - white on black). If you need to select only one word, then it is enough to double-click on it; triple-click to select a full line. To select text using the keyboard, place the cursor at the beginning of the selected text fragment and, while holding down the Shift key, move it to the end. In order to select the entire content of the document, use the keyboard shortcut Ctrl-A. Selection of text is possible in several modes displayed on the status bar: "STAN" - standard (by default), "EXTENDED" - extended (the beginning of the selection will be the current cursor position) and "ADD" - with addition (it is possible to select several unrelated other text fragments). The selection mode can be changed by clicking on the status bar; advanced mode is also toggled with the F8 key. The Shift key turns on the extended mouse selection mode, i.e. the current position of the cursor becomes the start of the selection, and the mouse indicates its end. Pressing the Ctrl key turns on the add mode, when you can select fragments that are not connected to each other. Copying and Moving Text Often you need to copy or move entered text; this can be done with a mouse or keyboard. To move the text with the mouse, you need to select a piece of text and drag it to another location. If you want to copy, hold down the Ctrl key. To move text using the keyboard, you can use the keyboard shortcuts: Ctrl-X or Shift-Del to cut the selected text and place it in the clipboard, and after placing the cursor where you want to place the text - the combination Ctrl-V or ShiftInsert. Copying differs only by using Ctrl-C or Ctrl-Insert - to place the original text on the clipboard - while it will not be deleted from the current position. The key combination Ctrl-Up Arrow (Ctrl-Down Arrow) moves the paragraph in which the cursor is located or the selected paragraphs up (down). Chapter 4. Formatting text 9 Chapter 4. Formatting text Visually highlighting text You can apply formatting to the selected fragments and the entered text - for example, change the way characters are displayed: make them italic or thickened (bold), change the size and font of characters, the color of characters and background ... Formatting is applied to a selection, a word or entered text - for this you can use the buttons (tools) on the toolbar, hotkeys, or the context menu. The toolbar contains the following buttons, where F - Bold K - Italic H - Underlined. You can use hot keys - a combination of the Ctrl key with the first letter of the character format (English name): Ctrl-B - Bold; Ctrl-I - Italic (Italic); Ctrl-U - Underline; And also Ctrl-D - Double underline. If you right-click on a selection or word, a context menu will appear. In the item "Style" you can choose the type of symbols; this item provides access to more options than the toolbar. You can also apply multiple formats to symbols at once, such as Bold-Italic. The use of formatting makes the text more representative, allowing you to highlight the main point in the text, so that the reader will pay attention to certain phrases. In OpenOffice.org Writer, you can also change the font type and size, symbol color, and more; the main properties are moved to the toolbar. 10 User Guide Changing the font, size, color of symbols The size and type of the font are selected in the drop-down lists on the toolbar. In the list of font types, they are shown as they will appear in the document. The font and size are also changed using the context menu - by right-clicking on the selection, in the items "Font" and "Size" you can select the required values. Color change buttons are also placed on the toolbar. With these buttons you can change the color of the font, the background of the selection and the whole paragraph 2. To quickly change the font color, use the button on the toolbar. You can select an area that will be displayed in a different color and click on it, or you can, without selecting an area, click on the button (the cursor will change to a bucket) and "fill" the area by selecting it. The color of the symbol on the tool button corresponds to the color of the text in the document; you can choose it - for this, press the button for more than one second and select the desired color from the menu that appears. The background color changes in the same way; the color around the symbol on the tool button corresponds to the color of the background color in the document. You can change the color of a paragraph using a special tool. 2 The term "Paragraph" and "Paragraph" mean the same Chapter 4. Formatting text 11 Pressing this button opens a form for choosing a color, which will be the background for the current paragraph (the one in which the cursor is located). The toolbar contains only those buttons that are most frequently used. However, the font has many more properties; to access them, the symbol formatting dialog is used, which can be opened using the context menu by selecting an area, right-clicking on it and selecting the "Signs ..." context menu item, you can also use the "Format" → "Signs ..." menu. ". This dialog has several tabs, when selected, a new group of text properties opens. Figure 4.1. Properties of the text On the first tab ("Font") its properties are set: font, size, format, used language, color. The second tab is more interesting - here you can set additional effects applied to the font - you can make it outline, shadow or embossed. 12 User Guide Font settings grouped on the "Position" tab are responsible for the position of the text relative to the line. Here you can specify the case (index - upper or lower, that is, the vertical offset of the line), the angle of inclination (by 0, 90 or 270 degrees) and scaling. The "Hyperlink" tab specifies properties for using text as a link to an Internet resource or a local file; the main field is the URL, where the path to the resource or file is indicated. The display of the text before visiting the link and after visiting is selected in the "Character Styles" field. Formatting paragraphs In addition to manipulating fonts, OpenOffice.org Writer allows you to format paragraphs, which allows you to change the position of text on a page. A paragraph can be left-aligned or right-aligned; you can set automatic numbering for each new paragraph and set its type. The main buttons are moved to the toolbar; they are used in relation to the current paragraph or emphasis. Applies paragraph formatting to the current paragraph or selection. As with formatting characters, you can use the hotkeys: Ctrl-L - align to the left (align to Left) Ctrl-R - align to the right (align to Right) Ctrl-E - align to the center (Center) Ctrl-J - alignment to the left and right edges (Justify). Sometimes it is necessary to insert a space between words, which will not result in a line break - the so-called non-breaking space. This symbol is inserted with the Ctrl-Space combination. Like symbols, a paragraph has many more properties than those controlled by the toolbar; for a finer setting, a dialog is used, which is called through the menu "Format" → "Paragraph ..." or from the context menu (item "Paragraph ..."). Here you can set such properties as the amount of indents to the left and right of the page edge, indentation of the first line, spacing Chapter 4. Formatting text 13 between lines, etc .; each group of properties is on its own tab. If you have to frequently change the alignment method, then it is better to use the "free cursor" function: usually the paragraph is aligned along the edge set on the toolbar, and when this function is enabled, you can use the mouse to specify the edge to which the paragraph text will be aligned. The function is enabled by clicking the Free cursor button on the toolbar. The text is aligned to the edge closer to which the mouse cursor is located - or to the center; this is indicated by a special marker. Table 4.1. Text alignment Left alignment Center alignment Right edge alignment Line spacing Sometimes you need to set a different line spacing (line spacing); this can be done from the context menu by selecting the "Interval" item, or using the following key combinations: Ctrl-1 - Single interval. Ctrl-2 - Double space. Ctrl-5 - One and a half interval. 14 User Guide Using Lists Very often there is a need to create lists, both numbered and unnumbered. The corresponding modes can be switched from the toolbar using the Numbering on / off button. or the F12 key. An unordered list is also created using the button on the toolbar. A number or symbol is automatically inserted at the beginning of numbered lists; unnumbered - special symbol - "bullet". When the cursor is on a paragraph with a list, you can call the list control panel - you can switch it by clicking on the button on the right on the toolbar. You can insert new sections of lists, change the level of the list, move a paragraph, or call the list customization dialog. To increase the level of paragraph numbering, press the Tab key, placing the cursor at the beginning of the paragraph (immediately after the numbering symbol); to decrease the level, use the Shift-Tab combination. Applying Paste Specials You can insert special fields into your document, the content of which will change depending on certain conditions. For example, the date field will change at the moment the document is opened and, thus, this field can be used, for example, when drawing up contracts, orders. To perform such an action, open the field insert dialog or, for frequently used fields, a special menu tool. On the toolbar on the left there is a button, a short press of which will open a dialog, and a longer press will display a menu of possible fields to be inserted into the document. Chapter 4. Formatting Text 15 The tool looks like this: When you press the button for more than one second, a menu will appear: Figure 4.2. Inserting a special field via the menu This selects the type of field that you want to insert into the document (at the current cursor position). If the menu does not contain the required field, or you need to customize the inserted field, then it is more convenient to call the dialog by briefly pressing the button or by selecting the "Other ..." menu from the "Insert" → "Field" → "Advanced ..." , as well as the keyboard shortcut Ctrl-F2. All fields are divided into categories, which are located on the corresponding tabs. After selecting the type, subtype, and setting the properties, click on the insert button - in this case, the field is inserted at the cursor position. Inserted fields can display content or value; switching between display modes is done through the menu "View" → "Fields" or by the key combination Ctrl-F9. Sometimes you need to update fields (for example, date or time) - for this you use the F9 key. Setting up and using tabs Tab (indent at the beginning of a paragraph) is one of the tools traditionally used to format a document; you can change its size and type in the paragraph settings dialog, as well as using the ruler located under the toolbar. If you make a User Manual 16 Figure 4.3. Setting up special fields by double clicking on the ruler, a paragraph setting dialog with tab setting properties will appear. Position - specifies the size of the indent from the left edge of the page; "Type" - can be: "Left" - the text will be limited to the left and typed from this position to the right; "Right" - the text is limited to the right and displayed from this position to the left; "Center" - the text is displayed evenly to the left and right of the tab stop; "Decimal" - the text printed before the separator character (the "Sign" field) will be displayed to the left of the tab stop, and the text after it - to the right; "Sign" - indicates the characters that will be displayed to the left of the entered text. Chapter 4. Formatting Text 17 After setting one or more tab stops, you can move to the next position with the Tab key. You can use a faster way to set and change the type and tab stop. To do this, you can use the ruler under the toolbar. The icon to the left of the ruler changes the type of new tab stop. Table 4.2. Controlling tabs Left tab Right tab Centered tab Decimal tab When you click on the ruler, a symbol appears indicating the type and location of the tab. You can change the type of tab by right-clicking on the tab character and choosing one of the options. If you need to change the tab stop, you can simply move the marker to another place on the ruler; to delete the specified position, drag the tab character down from the ruler. Drawing frames and lines, curly text As mentioned above, you can insert various objects into your document, including graphics. Among them there are straight lines, 18 User Guide rectangles, ovals, polygons, Bezier curves, curves, segments, text (including animated and leader). These tools (located in the toolbar on the left) are very easy to use. Once you've selected the object you want to insert into your document, pick anchor points. For example, to draw a rectangle, you need to specify the opposite corners with the mouse, and as you move the mouse, the outlines of the inserted object will be visible on the screen. By double-clicking on the outline of any object, you can insert text in or near it. You can set properties for inserted objects, such as color, linetype, arrowheads at the ends, and so on. This is done by an additional panel that appears when an object is selected and is available through the Format menu when an object is selected. Chapter 5. Saving, opening and printing documents 19 Chapter 5. Saving, opening and printing documents Saving and opening In order for the entered text to be used more than once, saving and opening documents is applied. Saving is used to reuse a document. Whenever you need to use a document in the future (and this is the most common case), the document is saved on a permanent medium, while it is assigned a unique name within the same directory, consisting of the name itself and the extension. The extension is assigned depending on the type of document; by it you can find out which program is opening the file. For example, XLS files are opened by OpenOffice.org Calc, and SXW or DOC files are opened by OpenOffice.org Writer. You can save the document using the File menu (Save item), the Save button on the toolbar, or the Ctrl-S hotkey. If the document is saved and does not require action, the button on the toolbar will be inactive. When you save the document for the first time, a dialog will open where you need to enter a file name and, possibly, specify the type of document (if it does not suit you by default). The future or new file name is entered in the "File name" field; it can be entered with the indication of a relative or absolute path - the system will, as far as possible, supplement the name with possible options. To go to any directory, double-click on the name of the directory in the list. To make it more convenient to navigate the directories, you can sort the list by clicking on one of the headings - for example, to sort by type, it is obviously "Type"; clicking on the same heading again means sorting in reverse order (indicated by an arrow). 20 User manual Figure 5.1. Saving a document The button to move one level up is used to go to the parent directory; if you press it for more than one second, a menu will appear that allows you to go up several levels at once. The next button is used to create a new directory in the current one; you need to enter the name of the new directory and confirm its creation. The rightmost button is used to go to the default directory for documents - you can configure it in the dialog: "Tools" → "Options ..." → "OpenOffice.org" → "Paths" → "Working folder". Chapter 5. Saving, Opening, and Printing Documents 21 The "Automatic file name extension" option is used to set the extension according to the "File type" field. The "Save with password" option is needed to save a file, which can be opened only if you know the specified password (at least 5 characters), which you will need to enter and confirm. If there is already a file with the same name in this directory, the system will warn about it. Depending on the format of the file being saved, the system may request additional data about the file, such as title, subject, keywords , comments, etc. If you want to create a copy of the file with a different name or in a different format (for example, to save an OpenOffice.org Writer file in MS Word ™ format), select “Save As ...” from the “File” menu. In this case, the same dialog will open as when the file was first saved. In case OpenOffice.org Writer crashes, the next time you start it you will be prompted to try to restore the files that were edited. In order to reduce the likelihood of losing edited files in case of failure, you can use the autosave option - it is available through the menu "Tools" → "Options ..." → "Load / Save" → "Main". Printing documents Often text and graphic documents need to be printed; for this, OpenOffice.org provides a special command and utilities for setting up the printer. The Add Printer Utility is run by the spadmin command in the OpenOffice.org installation directory and is not covered here. Configuring printers is carried out through the menu "File" → "Print settings ...", in which the printer is selected and its properties are set. To quickly print to the printer, use the button with its stylized image on the toolbar - immediately after clicking on it, the document will be printed. 22 User Guide Sometimes you want to print a document other than the default printer or with special settings. To do this, use the menu item "File" → "Print ..." or the keyboard shortcut Ctrl-P; in the dialog that opens, select the printer to which you will print and, by clicking on the Properties button, set its properties. Perhaps, before printing, I would like to see on the screen how the document will look on paper. To do this, you can use the menu item "File" → "Page layout in print". The document will be uneditable and the toolbar will display tools for setting viewing properties. The first four tools are used to move through the pages being viewed: the first and second scroll one page to the left or right, respectively; the third and fourth tools are used to view the beginning and end of the document. Next are the tools for setting the number of viewing pages on one screen: two / four pages and calling the viewing settings dialog, in which you can specify the required number of rows and columns into which the screen will be divided. Next are the tools for viewing the document in full screen and printing the preview. The button for full-screen document viewing removes menus, toolbars, scroll bars and leaves only the viewing panel. The next two buttons allow you to print the document and set the viewing options, respectively. The last tool on this toolbar is used to return the editor to normal operation. Chapter 6. Structural formatting 23 Chapter 6. Structural formatting Structural and physical formatting Physical or rigid formatting refers to the layout of the text, which is directly responsible for the final appearance of the text when printed. Any text has logical parts that correspond to the structure of the information it represents. When creating a document, the final appearance on paper is important. You can achieve the desired appearance of the document using tools such as changing the font, size, etc., however, if the volume of the document becomes more than several pages, then it becomes more difficult to keep track of the correct appearance of the document, since with changes in the design, you have to flip through it every time in search of the desired element and assign a new look to each element. There is another approach to writing a document, in which the logical elements are assigned text of the appropriate type to indicate the role of this object in the document. Each type of object, in turn, can be associated with appropriate physical formatting. Thus, you get a document that is very easy to manage - you just need to assign a different representation (physical formatting) to the required data type, and all elements of this type in the entire document will immediately inherit the new representation. OpenOffice.org Writer provides the ability to structure text formatting using styles. Using them, each structural unit of the document (file name, company name, comments, remarks, list, title, etc.) can be assigned its own appearance when printing (font, indents, framing, numbering, etc.). There is a certain set of standard styles (heading, list, etc.), which you can assign different physical formatting, as well as create your own styles based on them. All changes made to styles are saved with the document. Styles can be applied not only to text objects, but also to pages, frames, numbering. User Guide 24 Important Applying styles in a document allows you to avoid different styling of elements of the same type. Hard formatting apart from styles can be applied to a single selection; in all other cases, styles must be applied. Creating texts with or without styles The above methods of formatting text using the toolbar and keyboard (the so-called hard formatting), but there is a more convenient way - applying styles. For example, when styling is used for all headings, changing the appearance of the corresponding style changes their display. Any commonly used formatting in a document can be styled - this allows more flexibility in changing the appearance of the document. The style dialog is invoked from the toolbar by the On / Off button. Stylist, from the menu "Format" → "Stylist" or by pressing F11. The buttons at the top of the dialog are used to select the element to which the style is applied - this can be a paragraph, a symbol, an area (frame), a page, and a numbered list. The list in the middle lists the possible styles; the drop-down list at the bottom of the dialog is designed to select styles by category. To apply a style, select an area of text and assign it by double-clicking on the name of the desired style in the Stylist window. The user can reconfigure styles, as well as create their own and delete existing ones, however, standard styles cannot be deleted. To open the style settings dialog, you can use the "Format" → "Styles and Templates" → "Catalog ..." menu item or the Ctrl-Y key combination. The first drop-down list contains objects to which you can apply styles; as mentioned above, this can be a paragraph (paragraph), symbols (signs), frames, pages and numbering. When you select an object, the list will contain only the styles for that object. For a more convenient selection of styles, use the lower drop-down list, Chapter 6. Structural formatting 25 Figure 6.1. Stylist Figure 6.2. Customizing styles that allows you to present them in an orderly way. For example, All Styles displays all possible styles for a given object; if you select Applied Styles in it, the list will contain only the styles of the selected object that were used in this document. 26 User Guide The OK button applies the selected style; the New and Delete buttons are used to create a style based on the selected and delete a style, respectively - and to change the selected style, use the Edit button. The New button opens a dialog for creating a new style based on the selected one. The Organize ... button is used to organize styles, i.e. to apply styles from previously saved document templates in a document. When creating a style, a dialog for setting the style of the selected object will open; the style selected in the previous dialog will be taken as a basis (as a parent). In the opened dialog for creating a style, you need to set its properties. For example, for a paragraph, indents and spacing, alignment, position on the page, and others are indicated. Figure 6.3. Setting indents and spacing Each group of properties has a separate tab; only properties on general tabs will be discussed here. On the "Organization" tab, the main properties are: name, category, which style is taken as a basis. Styles are hierarchical and if you change the style of the higher hierarchy (parent), the changes will affect all the styles of the lower level of the hierarchy (based on the changed one). The style category is used to indicate, in fact, to which category the style belongs. For example, heading styles (Chapter Styles) are used to create a table of contents. Categories are also used for selection in the Stylist. Organization is used when you want to use template styles in your document. Clicking on the Organize button opens a dialog where you can apply template styles to the given document using drag and drop; if you select templates in the left list and documents in the right list, you can drag and drop styles from one list to another. To open the styles used, you need to double-click on the object - the tree of the styles used will open. Document structure (Navigator) The Navigator is used to quickly navigate to document elements (objects, pages, or headings). It is called from the toolbar, from the menu, or by pressing the F5 key. Figure 6.4. Navigator The list shows the elements of the document that you can navigate to; they can have a drop-down list (the "+" symbol 28 User's Guide to the right of the name). Expanding the list and double-clicking on an element, you can select the object that is associated with it. There are three tools for navigating through the pages in the Navigator dialog. The first one serves to move one page up, the second one - one page down, the third one - to move to any page. The next tool is used to adjust the DragMode-mode when an object from the navigator is moved to work area document. There are three modes to choose from: Paste as Hyperlink, Paste as Link, and Paste as Copy. When you insert a hyperlink, you can click to navigate to the object. An object inserted as a link will repeat the original one - changes to the last will be reflected on the link. When copying an object, a copy will be created as at the time of its creation; changing the original does not change the copied object. To the right of the Navigator window is a group of four tools for managing content. With these tools, you can move chapters up or down one chapter, and control the chapter numbering level. The top two tools move chapters up or down, and the bottom two move the chapter level. The first two tools of the second line of the panel are used to control the Navigator view - one shows or hides the list of objects, the second is used to display only the content of the document, hiding all other objects. Another important tool is to select the maximum heading level that is shown in the Navigator. Chapter 7. Checking Spelling 29 Chapter 7. Checking Spelling It can be automatic or as needed. For automatic check, you need to enable the Auto spell check button on the left of the toolbar or through the menu "Tools" → "Spelling" → "Auto check". In this case, words that OpenOffice.org Writer could not find in its dictionary will be underlined with a squiggly red line. If you right-click on the highlighted word, you will be offered correction options, calling up a dialog for checking spelling, adding a word to the dictionary, skipping this word in the entire document and automatically replacing the word with one of the options selected in the submenu. To check spelling with a dialog call, click on the Spelling button on the left of the toolbar, or through the menu "Tools" → "Spelling" → "Check" or by pressing F7; checking starts from the current position of the cursor. This dialog is used to work with a specific word. The icon behind the "Word" field shows its status (usually this word is unfamiliar). A certain word can be omitted if it is spelled correctly. Alternatively, you can set the Skip everywhere option if this word appears more than once in the document. If the word is spelled incorrectly, then in the “Word” field you need to enter the correct spelling or select a word from the “Variants” list and click the Replace button to replace this word in this place or Replace always to replace it throughout the document. The Thesaurus button is used to add synonyms to the dictionary; this dialog can also be opened using the menu "Tools" → "Thesaurus" or the keyboard shortcut Ctrl-F7. It requires you to enter a replacement word. Please note that not all languages are supported at this time. 30 User manual Figure 7.1. Spell Checking The Options button is used to set options and dictionaries that are used to check spelling and hyphenation. The same parameters are set in the settings dialog "Service" → "Options ..." → "Language settings" → "Linguistics". If the word is spelled correctly, but it is not in the dictionary, then it can be added to the dictionary. To do this, select the required item in the Dictionary field and click the Add button. In this case, all added words found later in other documents will be considered correct. It is possible to check spelling only in a part of the text - for this you need to select it before checking it. Sometimes correctly spelled words appear as misspelled. This may be due to the fact that the language for the word is incorrectly set. To change the language, you need to select a word and select the language in the drop-down list on the "Font" tab in the "Signs ..." dialog, accessible through the "Signs ..." context menu or the "Format" → "Signs ..." menu. There are no words with the letter "ё" in the standard dictionary, so all words with this letter will be considered incorrect. Chapter 8. Hyphenation 31 Chapter 8. Hyphenation To make your document more readable, you can use paragraph alignment to the left and right, but this is not always acceptable. In this case, the distance between characters in the text increases, which is especially noticeable when there are long words in the text; it is of course best to use hyphenation. For OpenOffice.org Writer to be able to hyphenate the text, you need to set the language properties "Russian" (menu "Tools" → "Options ..." → "Language settings" → "Languages", the field "Western"). Hyphenation can be done automatically or manually. Automatic hyphenation is set in the paragraph properties in the dialog for setting paragraph style properties on the "Position" tab on the page in the "Hyphenation" section, you must enable the "Automatic" option. To place soft (recommended) hyphenation, you need to place the cursor in the place where you can make a hyphenation and insert a soft hyphen character using the Ctrl-minus key combination. You can search for all hyphenated words using the Hyphenation function in the Tools menu. Figure 8.1. Arrangement of hyphenation The "=" sign means the place of possible hyphenation; "-" indicates the place where it will definitely be produced. To install the transfer, click the Transfer button; to terminate hyphenation, use the Cancel button. The Next button moves to the next word without setting a hyphenation in this word. 32 User Guide Pressing the Remove button removes the previously set hyphenation. If you want the word to never be hyphenated, you need to add it to the dictionary with the "=" sign at the end. Chapter 9. Using the Find and Replace function 33 Chapter 9. Using the Find and Replace function The Find and Replace function is invoked from the Edit → Find and Replace menu or by pressing Ctrl-F. Figure 9.1. Find and replace In the dialog that opens, you need to set the search and replace attributes; after clicking the Find button, the found match will be highlighted, and then you can replace it using the Replace button. The Replace All button is used to replace all matches in the text. If you need to insert a special character into an input field, right-click in the required field, or use the Ctrl-Shift-S keyboard shortcut. The options at the bottom of the dialog box are used to control the search: "Word only" is used to search for matches for a full word; "Reverse search" changes the direction of the search (from the cursor position to the beginning of the text); Regular Expression indicates that a regular expression will be entered instead of a word; "Exact Search" is used to specify a case-sensitive search. 34 User Guide In the editor OpenOffice.org Writer there is also the ability to search and replace not in the whole text, but only in its part. To do this, select the part of the text that will be searched for and call the search and replace function. This activates the Search only in selection option. To search for specific styles, use the Including Styles option - when it is enabled, the paragraph styles will be listed in the Find and Replace with lists. The search in the document can be carried out not only by words and phrases, but also by other parameters. To do this, use the Attributes and Format buttons - here you specify the format of the text that you want to find. If you need to search for words with any formatting, use the Unformatting button. To navigate to certain elements in the document, navigation is used - special arrows on the scroll bar on the right. The middle button is used to select the type of object for the transition - clicking on it brings up a menu with all objects that can be inserted into the document. After selecting the required object, the previous or next one is highlighted using the upper and lower buttons. Chapter 10. Customizing Toolbars 35 Chapter 10. Customizing Toolbars Toolbars provide quick access to commonly used functions of OpenOffice.org Writer, such as font properties, paragraph formatting, working with a file, inserting various elements, etc. some examples of working with toolbars. Toolbars are located on the left and top; picture buttons represent tools, some of which have menus; on such instruments there is a small green arrow, with a long press on which (more than one second) it appears. The user can customize the toolbar by adding and removing individual tools and entire groups. Right-clicking on the toolbar brings up a menu where the first section shows toolbars that can be made visible or invisible. When you click on a specific toolbar in the Show buttons menu, there will be tools that can be made visible on this toolbar or hidden. The "Configurations ..." menu item opens a dialog where you can customize toolbars, add or remove a panel. Here you can save or load a previously saved toolbar. The "Preferences ..." menu item opens the Tool Preferences dialog - this is where you find all the OpenOffice.org Writer functions that you can add to the toolbar. The dialogue is divided into areas; the "Symbols" area is intended for tools. To add a tool to the toolbar, drag the tool to the toolbar; to remove a tool from the toolbar, simply remove it from the toolbar when the customization dialog is open. The next area allows you to select a category of tools and the tool itself by name. The Symbols ... button is designed to assign a pictogram to the selected tool - you must select it in the opened dialog and confirm your choice. 36 User manual Figure 10.1. Customizing Toolbars Chapter 11. Arranging Windows on the Screen 37 Chapter 11. Arranging Windows on the Screen As mentioned above, each new or open document opens in a new window; for quick access to any of them the "Window" menu is used. Sometimes you need to edit the same document in two windows. To do this, use the "Window" → "New Window" menu item. In the window that opens, there will be the same document, and the changes made in either of them are reflected in both. Conveniently, in OpenOffice.org, many of the tool menus on the toolbar can be dragged out like Navigator or Stylist windows. To do this, open the tool menu and drag it by the title bar to an empty space. For example, to make it convenient to quickly navigate the objects of the document, you can call the navigation menu, as mentioned in the previous chapter, and drag the window to a convenient place. You can now quickly switch between objects by selecting an object and using the up and down arrows in the dialog. Part III. Spreadsheets 40 User Guide Chapter 12. Main Window of OpenOffice.org Calc. After loading OpenOffice.org Calc, a window appears on the screen. Figure 12.1. The main window of OpenOffice.org Calc The main elements of the window are: Menu The menu controls, configures and works with spreadsheets. Input line The input line is used to enter values and formulas into table cells. Chapter 12. Main Window of OpenOffice.org Calc. 41 Symbol Bars The Symbol Bars provide quicker than menu-driven access to spreadsheet controls and settings. Working area of the sheet The area of the sheet consists of cells. A cell is the smallest structural unit in a spreadsheet; it has an address defined by vertical and horizontal coordinates. The first is the column name (the first part of the address); it can range from A to IV. The second is the line number (the second part of the address) and has a value in the range from 1 to 32000. To the right and above the worksheet there are rulers with the names of columns and rows. To select an entire column, click on the cell with its name on the top ruler; to select the entire row - by the cell with its name on the left ruler. When selected, the row or column name appears in bold; if you select one cell, then both parts of the address located on the rulers will be displayed in bold. Status bar Displays information about the modes of the table. Sheet navigator Select a sheet for work by clicking the left button; if you right-click on the sheet navigator, the following operations for working with the sheet will be available in the pop-up menu: Insert - create a new sheet 3. Delete - used for unnecessary sheets. Rename - allows you to assign a different name to the sheet. Moving / copying - allows you to make copies of sheets, transfer existing sheets to other documents, change their order. Select All - selects the entire sheet. 3 In total, OpenOffice.org Calc allows you to create a maximum of 256 sheets 42 Figure 12.2. Insert sheet Figure 12.3. Moving a Worksheet User's Guide Chapter 13. Entering Data 43 Chapter 13. Entering Data To enter data, select a cell and just enter what you want. The text you type will appear in the cell where you enter your text and in the input line (at the top), which is especially useful given that a cell can contain more characters than its current width can display. If adjacent cells to the right do not contain values, then the entered line will be displayed in full; otherwise, only part of the row will be displayed and a red arrow will appear in the cell. To display the entire information, you must either stretch the cell to its width or allow line breaks. Figure 13.1. Changing the size of cells There are several ways to change the width (height) of a row: Automatic - double-click on the right border of the column name and OpenOffice.org Calc will adjust the width for the column, choosing the width necessary to display the cell with the longest content. The same can be done through the menu: "Format" -> "Column" -> "Optimal width ..." Manually - left-click on the border of the column name and, without releasing it, move it until the desired size is reached. Exactly - select any cell in the column whose width you want to change, and then the menu item "Format" -> "Column"> "Width ..."; in the window that opens, enter the exact size. To enable line breaks, press Ctrl-Enter, or right-click on a cell and select "Format Cells", or select the "Format" -> "Cell" menu item and then - the "Alignment" tab; here check the "Line break" checkbox. In the same window, you can set the vertical and horizontal alignment of the text and the direction of writing (the angle of rotation of the text). Alignment allows you to determine the position of text in a cell (left, right, center, bottom, top) 44 User Guide Figure 13.2. Cell Attributes The writing direction allows you to write in cells at a specified angle. It should be noted that if the text begins with an "=" sign, then it is not displayed in the cell, because OpenOffice.org Calc treats such text as a formula. If you want to print text starting with the "=" sign, then you must put the single quotation mark as the very first character. If there is a need to start a string with a quotation mark, then it is necessary to print the quotation mark twice. Chapter 14. Entering Formulas 45 Chapter 14. Entering Formulas One of the purposes of spreadsheets is calculation, so we'll go over the basic rules for writing formulas. As already noted, entering a formula begins with an equal sign, then the formula itself is written. For example: "= 4 + 16". Writing down such a formula and pressing Enter, we will see the number 20 in the cell. Of course, formulas without variables usually do not make much sense, so now let's see how to use variables, which are cell addresses in OpenOffice.org Calc. For example, if we wrote down the number 20 in A1, then after writing the formula = A1 ^ 2 to B1 and pressing Enter, the number 400 will appear in cell B1. Basic arithmetic operations available to OpenOffice.org Calc: "+" - addition; "-" - subtraction; "*" - multiplication; "/" - division; "^" - exponentiation; ":" - setting the range. In addition to these operations, OpenOffice.org Calc provides an extensive set of functions in the following categories: working with databases; processing of times and dates; financial; informational; brain teaser; mathematical; work with arrays; statistical; text; additional. For the convenience of writing formulas in OpenOffice.org Calc, an autopilot of functions has been developed. 46 User Guide In the autopilot window, you can enter functions and check the correctness of their set; depending on the category selection, the list of available functions will change. In addition to the categories listed above, All and Recently used have been added for convenience. Figure 14.1. Autopilot of functions The current formula is displayed in the "Formula" edit field, which can be edited directly - or, by placing the cursor in the required position, double-click on the function name from the list, and the selected function will be inserted into the input window. All that remains is either to enter the argument from the keyboard, or to press the button: Next, select the cell, the value of which will be the argument. Chapter 14. Entering formulas 47 In the "Structure" tab, the typed formula is expanded into a tree, which greatly helps in editing formulas, allowing you to keep track of the order in which the formula is calculated. For the case when the formula is quite simple (contains the signs "+", "-", "*", "/", "^"), but consists of a relatively large number of variables, consider the following example: Let it be required to calculate A1 + C5 * B4; To do this: Press =, then select cell A1 using the cursor arrows (the first time you press the cursor key, a red rectangle cursor will appear). Then press + and select C5, press * and finally select B4. In this way, using the keyboard, you can quickly form formulas (cells can also be selected with the mouse pointer). After entering "=" and a letter, OpenOffice.org Calc automatically highlights the function name that starts with that letter. This feature allows you to type not the entire formula, but only its first letters, and then, if the proposed function is exactly the one you need, you just have to press Enter. It so happens that when entering formulas as their arguments, you need to pass not the address of a cell, but a whole area - for example, you need to sum all the values in column A, starting from address A2 to address A11. Of course, you can write "= A2 + A3 + ... + A10 + A11" - but it is much easier and in any case it would be more correct to write "= Su", then use the prompt (Sum) and, pressing Enter, enter the range 'A2 : A11 '. The area of the worksheet is specified by specifying the address of the upper left cell, then a colon is put and the lower right cell is indicated. The area can also be set using the mouse. 48 User Guide Chapter 15. Autocomplete Sometimes you need to perform the same type of calculations for a set of data. A spreadsheet allows you to enter a formula only once - when you copy it to another cell, the parameters will be automatically replaced with new values. Let the task be to calculate cos (x), where x is given in degrees. To solve it, perform the following actions: 1. Enter the text "Angle" in cell A1, the number "0" in cell A2, and "1" in A3. Select cell A2 and, without releasing the mouse button, also cell A3. Cell selection can also be done using the cursor keys: select A2, then press Shift-Down Arrow. 2. Next, move the mouse over the lower right corner of the selected area; the cursor changes to a cross. By pressing and holding the left mouse button, select an area of 360 cells with a red rectangle, that is, the last selected cell should be cell A361. In this case, the number 360 will appear in the yellow hint rectangle. An example of autocomplete has just been analyzed. OpenOffice.org Calc automatically increases the cell values by one as the red selection area expands. In principle, it would be enough to just enter "1" and just multiply the cell, since OpenOffice.org Calc by default multiplies cells in an arithmetic progression in increments of "1". If you hold down Ctrl, then the cell values will be multiplied by simple copying. Chapter 15. Autocomplete 49 Now it is just as easy to calculate the cosine values of all angles; first, you need to return to the top of the page using CtrlHome (return to the beginning of the sheet) or Ctrl-up arrow (move to the top margin of the block). Enter in B1 "cos (angle)", and in B2 in Latin "= c" and press Enter; further, having switched to Russian, "p"; Enter, left arrow and Enter. So, by pressing just a few buttons, the formula "= COS (RADIANS (A2))" was introduced. Now, hooking the lower-right edge of the cell with the cross-shaped cursor, we multiply the formula by all the angles. The result is the cosine values of all angles. 50 User Guide Chapter 16. Cell Format OpenOffice.org Calc, like any modern spreadsheet, supports various formats of data in cells that determine how it appears in the table. For example, the text "3/4/01" will be assigned the format "Date". If we change the cell format to a number, we get 36954. To change the cell format, right-click on the cell and select “Cell Format ...” in the context menu and the “Numbers” tab in the window that opens. All formats are categorized for convenience. numerical; monetary; financial; date; time; percentage; fractional; scientific; Chapter 16. Format of cells 51 logical; text. In our example with calculating the cosine, change the number of displayed decimal places (the value of the fractional part parameter) to 7. Our format will automatically be entered in the "Number" and "User-defined" categories. 52 User Guide Chapter 17. References Let's go back to the example with the calculation of the cosine. Let now it is required to calculate the function "cos (angle + phase)". Let's say the phase is constant and should be stored in cell C2. Then change the formula in B2 from "= cos (radians (A2))" to "= cos (radians (A2 + C2))" and multiply by all 360 values. There will be practically no effect: the fact is that we did not say that our phase is constant, that is, the formula “= cos (radians (A3 + C3))” was written in cell B3. There is no data in C3, so OpenOffice.org Calc assumes that C3 contains "0". To prohibit changing a variable by column or row, you need to write a $ sign in front of the coordinate. Now we prohibit changing the row coordinate by changing C2 to C $ 2 in our formula. To quickly insert $ into the edited address, it is convenient to use the Shift-F4 keyboard shortcut. If you press this combination once, the $ sign is added to the column coordinate and the row coordinate; two times - only to the row coordinate, three times - to the column coordinate. The fourth press is equivalent to the first. Since an OpenOffice.org Calc document contains multiple sheets, it is possible to address between sheets as well. Up to this point, we have considered single-leaf local addressing; the full cell address looks like this:<Название листа>.<Локальный адрес ячейки>... Chapter 18. Diagrams 53 Chapter 18. Diagrams Now it remains to insert the diagram of our calculation. This is done very simply: Two columns A and B are selected. From the menu, select the "Insert" -> "Chart ..." item. Figure 18.1. Chart auto-format (dialog 1) In our case, the first line is the label of the x-axis, so we leave the “First line as label” checkbox. The range of values recorded in the "Area" field was determined automatically, it is, as expected, equal to "$ Sheet1. $ A $ 1: $ B $ 361". Our diagram can be placed either on one of the existing sheets, or on a new sheet. If you place a diagram on a new sheet, then it will occupy it completely, which is very convenient for printing diagrams on a whole sheet. In our example, Sheet1 is selected to place the chart. After filling in each dialog box, the Next button is clicked. 54 User manual Figure 18.2. Chart auto-format (dialog 2) In this window the chart type is selected from the following possible ones: Two-dimensional charts: lines; with areas; bar graph; ruled; circular; XY chart; mesh; exchange. 3D charts: 3M chart; with areas 3M; 3M histogram; ruled 3M; circular 3M. Chapter 18. Diagrams 55 Since the diagram is built on two columns, we select the XY diagram. Data series are specified in columns. Figure 18.3. Diagram auto-format (dialog 3) In this window, the diagram version is specified. Figure 18.4. Chart auto-format (dialog 4) Specify the name of the chart; since there is only one dependency on it, uncheck the legend box. Enter the labels for the X and Y axes. 56 User Guide Next, press the Finish button. Figure 18.5. Chart auto-format (dialog 5) The chart is built. Chapter 19. Styles 57 Chapter 19. Styles A style is a fixed set of object properties; they are very convenient for quick changes appearance of the finished document. To change or add a style, select the menu item "Format" → "Catalog of styles". Let's go back to our example. All cells in the new table are in the Default style; if you change its font, it will affect the display of all cells. Styles in OpenOffice.org Calc apply not only to cells but also to sheets; they can set all the properties of these objects. The way to edit a document through styles is the most convenient, especially for large and multi-page documents. Part IV. Creating Presentations 60 User Guide Chapter 20. Getting Started with Presentations When you first load OpenOffice.org Impress, the Presentation Autopilot window appears on your screen. Figure 20.1. Presentation autopilot (dialog 1) In the first window of the wizard, the presentation type is selected: "Empty presentation" - creates new presentation ; "From template" - allows you to open a presentation from a previously saved template; "Open one of the presentations" - opens an existing presentation. To disable the appearance of the Presentation Autopilot on the next boot, select the Do not show this dialog again box. If you want to have an idea of how the presentation will look, leave a check mark in the View box. Go to the next window by clicking the Next >> button. In the second step, set the slide style and Presentation Shower. Chapter 20. Getting Started with Presentations 61 Figure 20.2. Presentation autopilot (dialogue 2) Figure 20.3. Presentation autopilot (dialog 3) In the third window, select the parameters for switching between presentation frames. Then click the Finish button. A window with a dialog for creating a slide will open. 62 User manual Figure 20.4. Presentation autopilot (dialog 4) Here enter a name for the new slide, define the layout (view) of the slide and options to show the background and show objects in the background. To add a new slide, right-click in an empty space and select "Slide" → "Insert Slide" from the context menu or through the menu "Insert" → "Slide ..." - the dialog for creating a slide will open. OpenOffice.org Impress allows you to make a copy of a specific slide and paste it as a new one by choosing Insert → Duplicate Slide from the menu. Chapter 21. Modes of working with a presentation 63 Chapter 21. Modes of working with a presentation On the right under the control bar on the scroll bar there are six tools for controlling the mode of working with a presentation. The top button Drawing mode is used to view slides individually and edit them. When this mode of operation is selected, the tabs with the names of the slides will be visible at the bottom left of the horizontal scroll bar; to switch between them, you can click on the tab with the name of the desired one. The next tool allows you to switch to the slide structure mode, which is presented as a hierarchical list; the first level of the hierarchy is the slides (their titles are displayed). To go to any slide, you need to select any element related to it; here you can edit the title. To add a slide, just enter the text and make it the first level of the hierarchy (to change the level, use the Shift-Tab, Tab or toolbar keys). The next tool, Slide Mode, controls their order; to change it, just drag the slide from one place to another. The Annotation View tool lets you enter text that will only be visible in Annotation View. Abstract mode allows you to place slides on one page and enter their descriptions. In the lower left corner there is a toolbar that allows you to add a background to your slides; you can switch between slide mode and background mode (the first two buttons are used for this). In background mode, you can add a background that will be visible on all slides, but cannot be edited. You can add 64 User's Guide for example, a text caption or a picture. To make the background visible or not visible on a specific slide, right-click on the slide and in the context menu select "Slide" → "Slide Style ..." and then slide style with or without background. In the same dialog, you can select one of the possible styles by clicking on the Load button and by selecting the desired one, confirm the choice. Chapter 22. Working with a slide 65 Chapter 22. Working with a slide To work with a slide, there is a main toolbar on the left: Tools with a green arrow have a submenu. When you click on such tools for a long time (more than a second), a menu will appear in which you can select one of the group elements. The arrow-shaped tool is used to select objects. The next tool in the form of a sheet of paper with a magnifying glass is used to change the scale of the document; in its menu there are several buttons that allow you to select the optimal scale of the document. The next group of tools is used to insert various objects on the slide - text, rectangular shapes, ellipses and circles, three-dimensional objects, curves, lines and arrows, connecting lines. To change the position of an object, use the following group of tools - for example, to rotate an object, you can select an object, click on the rotation button and, grabbing the red handles around the object, rotate the object in different directions. To align an object on the page (both horizontally and vertically), use the following tool. The Arrange tool lets you influence the order in which objects are layered. A group of elements that change the effects of objects, allows you to make your presentation more beautiful and attractive; it "hides" behind the Effects button. Buttons for selecting effects allow you to select an object to which they will be applied. The first allows you to choose options for the appearance of the slide, the second - only text effects. Below in the drop-down list, the category of effects is set, from which, in the end, the necessary one is selected; the speed of its execution is also set. To assess the impact, click the Preview Window button. 66 User Guide To apply an effect to an object, use the Assign button. After clicking the Order button, a list of the order in which objects appear on the presentation slide appears; you can change it by simply dragging the selected object to the desired position. The next button on the left toolbar is Interaction, which allows you to set the click action on an object. This can be a transition to a slide, the execution of a program, and much more. The penultimate tool lets you apply 3D effects to an object. The latter tool provides a presentation view mode. After creating a slide, you can edit it. The title of the created slide is edited by clicking on the object labeled "Add title by mouse click". The name of the created slide is displayed on a tab next to the scroll bar. If you right-click on it, you can rename the slide, delete it, insert a new one, or change the slide layout. Changing the properties of the text is done by selecting one of the items of the drop-down context menu. Chapter 22. Working with a slide 67 The item "Text ..." allows you to set the properties of the text and the effect of the creeping line. If the word is misspelled, it is better to correct it 4. On the “Text” tab, the frame properties are set: the size and position of the text. On the tab "Creeping line" you can set the effects for the animation of the text. 4 Otherwise, the correction options will be observed in the menu. 68 User manual Figure 22.2. Applying the creeping line effect to the text To add a picture, click on the icon with the house and select the picture in the dialog that opens. Clicking the right mouse button gives access to the following properties of the image: Text ... - effects of the text superimposed on the image (can be added after double-clicking on the last one). Position and Size - sets position, size, rotation, tilt. Original Size - sets the initial size of the image. Color resolution - allows you to set the tonal depth of the image. Location - determines the level of the object in the "stack". Alignment - sets the position of the object on the slide (left, center, right, top, middle, bottom). Flip - allows you to flip the image vertically or horizontally. Convert - makes it possible to transform an image into a polygon, contour, three-dimensional object, body of revolution, raster. These properties are not always available. Assign name to object - allows you to name objects for convenience. Chapter 22. Working with a slide 69 Effect - after selecting this property, the object effect selection dialog appears. In addition to being able to position objects on a slide, you can specify a slide background. To do this, right-click in an empty spot on the slide and select "Slide" → "Page Setup" from the context menu. In the dialog that opens, open the "Background" tab. Figure 22.3. Setting the background Filling is selected by a radio button, which can have the value: No - no filling; Color - sets the color of the monotone background; Gradient background fill provides a rich library of gradients; Hatching - it is necessary to choose a background color and define the color and geometry of the picture; Bitmap - provides a wide selection of background images; Accordingly, each filling has its own properties. User Manual 70 Table 22.1. Basic Selection Tools Zoom All drawing-related functions available through the icons on this panel are described in the OpenOffice.org Draw part. Positioning the slide Inserting an object Show and slide effects Viewing a presentation Chapter 22. Working with a slide Figure 22.1. Selecting an Effect 71 72 User Guide Chapter 23. Presentation Panel This window is a convenient tool for managing slides: Insert Slide opens the familiar window for creating a new slide. Slide Style opens the dialog for changing the slide style. Duplicate Slide adds a slide that is identical to the current one. Chapter 24. Slide Transition Effects 73 Chapter 24. Slide Transition Effects You can set slide transition effects in the second step of the presentation autopilot. If this has not been done, correction is needed or you need to make different transitions between slides - use the menu item "Demonstration" → "Slide Transition"; a dialog box for setting the transition effect for this slide will open. Figure 24.1. It is similar to the dialog for setting transition effects, but has the addition of a time control button. With its help, you can set the time between slide changes, which, in turn, can be automatic, semi-automatic and manual. The first option indicates the time after which the transition to the next slide will be made. 74 User Guide Launches a presentation for viewing. You can view the created presentation using the button from the menu "Demonstration" → "Demonstration" or the key combination Ctrl-F2. Part V. Using OpenOffice.org Draw With OpenOffice.org Draw, you can provide any OpenOffice.org document with high-quality illustrations - be it a word processing document, spreadsheet, or presentation. In addition, it is possible to export the drawing to other applications using widely used graphic formats. Chapter 25. Types of Drawings 77 Chapter 25. Types of Drawings OpenOffice.org Draw allows you to create both vector and bitmap drawings. Let's consider the latter first. Raster images consist of a limited number of dots and the image in such patterns is formed by a combination of dots of different colors. As a result, raster-type pictures are not scaled - more precisely, they do not look good after resizing. At the same time, bitmap images are well transferred from one program to another, since in essence they are reduced to a simple array of points. Vector drawings are drawings that consist of objects (lines, rectangles, circles, gradients, etc.) and do not have a fixed resolution; they can include bitmaps as objects. Such graphics are perfectly scalable and at any time can be converted to raster form with any specified resolution. Due to these properties, vector drawings are the most preferred when creating illustrations for documents; at the same time, when exporting a document to some external format for OpenOffice.org, vector images cannot always be used and in such cases are converted to raster. OpenOffice.org Draw is primarily intended for creating vector drawings; applications such as GIMP exist for working with bitmaps. The rest of this tutorial will discuss mainly vector art; Bitmaps will be discussed in terms of their use as part of a vector image, as well as in the context of converting a vector to a raster. 78 User Manual Chapter 26. Principles of Working with the Program General view of the main window of the program is shown in the figure. Figure 26.1. General view of the main window of OpenOffice.org Draw Like all other modules in the package, OpenOffice.org Draw has an intuitive graphical interface. The menu area is located at the top of the main window; going down - panels of functions, hyperlinks, objects; on the left, the toolbar is vertically located, a little to the right is the ruler, and even lower - the panel of symbols, colors - finally, at the very bottom of the main window - the status panel. Any of them can be turned on or off through the menu "View" → "Symbol Bars". Elements can contain so-called tear-off panels - this is indicated by the green arrow in the form of a triangle. A longer press on the tear-off panel symbol leads to its appearance in a "independent" form. Then you can select the desired tool or tear off the panel - for this, left-clicking on the title and without releasing Chapter 26. Principles of working with the program 79 Figure 26.2. button, move the panel to the work area. After working, you can close the unnecessary panel using the cross button on its title. Figure 26.3. In the central part of the main window of the program there is a drawing worksheet. The scale of the worksheet display is set through the "View" → "Scale" menu or using the Scale tool on the toolbar. 80 User's Guide Chapter 27. Graphic primitives Graphic primitives are the smallest graphic objects that make up a vector drawing - like the bricks from which a building is constructed. Graphical primitives in OpenOffice.org Draw include: lines and arrows; rectangles; circles, ellipses, arcs, segments and sectors; curves; connecting lines; three-dimensional objects (cube, ball, cylinder, etc.); text. Graphics primitives can compose more complex objects thanks to the combination function and logical operations on shapes; more on this later. Creation of graphic primitives To create a primitive, make a long-click on the button of the corresponding group of primitives on the toolbar; then, having selected the required primitive from the drop-down list of icons, release the button. As a result, the mode of primitive creation is activated, in which you need to specify with the mouse the location of key points and distances of the primitive. Different primitives have a different number of parameters; so, a simple line has only two parameters, while a curve has an unlimited number. Below we will talk about the features of creating various primitives. Lines and Arrows To create a line, specify the starting and ending points of the line on the drawing sheet: the starting point of the line is set with the left mouse button; then, without releasing the button, position the cursor on the end point of the line and release the button - the line is created. Chapter 27. Graphic primitives 81 Figure 27.1. Figure 27.2. Connecting line This object is created in the same way as a regular line. A feature of the connecting line is the ability to snap to objects, therefore, when creating a connecting line, instead of specifying the start or end point of the line, you can specify an object and the program itself will select the best connection point for the line to it. Rectangles Figure 27.3. 82 User Guide Here you need to specify the position of two opposite vertices of the rectangle - the first is indicated by pressing the left mouse button; then, without releasing it, move the cursor to the second point and fix the shape by releasing the button. Circles, ellipses, arcs, segments and sectors Figure 27.4. To create a circle and an ellipse, it is enough to indicate the overall dimensions of the primitive with two points by pressing, dragging and releasing the left mouse button. In the case of an arc, segment or sector, you need to specify two more points on the outline of the primitive by simply pressing and releasing the left button. 3D objects Figure 27.5. Any three-dimensional object is created by specifying its maximum size in one of two dimensions. A three-dimensional object is created in fixed proportions, which change after it is created. Text Text is created by simply clicking the left mouse button in the desired place on the sheet; a typing frame appears with a text cursor. Chapter 27. Graphic primitives 83 Figure 27.6. When creating text that is inscribed in a frame, first set the frame with two points by right-clicking-stretching-releasing, then type the text. The font size will be automatically selected so that the text occupies the entire area of the specified frame. A legend is a box with an arrow, which is usually used to explain a part of a drawing. It is created by right-clicking; you can then insert text into the legend frame by double-clicking the frame. As you enter text, the legend frame automatically resizes. Bezier curves, sketched curves, polygons Figure 27.7. Based on trigonometric equations, the French mathematician and engineer Pierre Bézier created a special way of describing complex contours in a simple yet flexible way for metal-cutting machines used in the automotive industry; this method was called Bezier curves and, due to its simplicity and flexibility, subsequently became one of the most important methods of computer graphics. Bezier curves are drawn from multiple points and guide lines. The points along which the curve is drawn are called anchor points; each is characterized by two line segments tangent to the Bezier curve at the anchor point (called guides). The length of each of them defines the steepness of the next or previous segment of the curve, and the angle of the tangent defines the direction in both directions from the anchor point. 84 User Guide When creating a curve in OpenOffice.org Draw, its anchor points are sequentially indicated using the left mouse button. If, after pressing the button to create an anchor point, you do not release the button, you can set the angle and length of the guides; if the button is not held down, the length of the guides will be zero, and such a point will be angular. The track of the first anchor point must be specified, otherwise the operation is canceled. Double-clicking with the left mouse button finishes drawing the curve. Chapter 27. Graphic primitives 85 Important Note that when creating a curve, the length of the guides in both directions is the same. You can change the lengths of the guides separately after creating the curve using the point editing tool. Note Holding down the Shift key while creating a curve allows you to specify angles in multiples of 45 degrees; you can use the Alt key to close the curve. When working in the X Window, the Alt key can be used by the window manager, which will prevent this operation from being performed. For example, KDE uses Alt in combination with the left mouse button by default to move the window. However, you can close the line by pressing Alt after the right button. The line will be closed, but the last anchor point will be the corner. This is easy to fix with the Point Editing Tool. Alternatively, change the settings of the window manager to use a different modifier. The drawn line is also a Bezier curve, only the number of anchor points, the values and angles of the guides are automatically determined by the program. To create a hand-drawn line, by pressing and holding the left mouse button, draw the desired curve by hand. Polygon creation consists in specifying all the vertices of the polygon. The second vertex must be indicated by releasing the pressed left mouse button, otherwise the operation will be canceled; the rest of the vertices are indicated by a regular click, and the last vertex is indicated by a double click. Just like when creating a curve, you can use the Alt and Shift keys to close the polygon and draw with angles that are multiples of 45 degrees, respectively. 86 User Guide Chapter 28. Modifying Graphic Objects Each object - already modified, combined, transformed or just a graphic primitive - has a certain set of characteristics, such as size, color, rotation angle, font family and size, etc. At the same time, from the point of view of modification, objects can be divided into three groups: 1. graphic objects characterized by a region (most objects); 2. graphic objects characterized by particular properties (lines, connecting lines, legend); 3. text objects (plain text). To change the parameters of objects, first select the required one by clicking on any part of it. The program will confirm the selection by highlighting the area where the object will be placed with square dots. In this case, the primitives, which are characterized by the area, as well as text objects, are highlighted by a field of eight green square dots, the rest are highlighted by turquoise dots, which show the key points of the object. You can select several objects at once using the left mouse button while holding down the Shift key - in this case, the selected objects will be selected with one field of eight points and all further operations will affect all selected objects. The selection area of an object can be stretched, moved, rotated, etc. Stretching an area of plain text does not change the size of the text; in all other cases, resizing the selection area causes the object to be scaled. Resizing and Moving The vertex points of the rectangular region of the object are used to resize the object in both dimensions, and the points on the sides are used in only one. To perform these actions, grab the desired point with the mouse, stretch the area and release the button. For objects of the second type, when changing the size, control points are used - in much the same way as when changing the size of the area, but in this case the resizing occurs Chapter 28. Modifying graphic objects 87 according to the rules of the object itself: for example, for a Legend, lengthening the pointer arrow does not lead to change the scope of the comment. The text object area frame specifies the typesetting field and line width; changing its size does not lead to a change in the font size, unlike text inscribed in a frame, where it depends on the size of the specified area and is automatically selected so that all the text fits in the specified area. To move an object, left-click on any part of the object, move the object without releasing the button, and after releasing it, commit the change. Object text Almost all objects (except three-dimensional ones) can contain text in one form or another. For text objects, this is, of course, the main function; for others - additional. If you double-click the left mouse button on an object, a cursor will appear, which allows you to enter or correct the object's text. Its properties can be changed in the same way as for text objects - using the tools of the object panel, the "Format" menu or using the context menu. Effects Figure 28.1. For other operations on objects, such as rotation, mirroring and others, use the effect panel. After selecting the rotation tool, the selection points of the object will take a round shape; depending on the type of object selected, each point gives access to different functions. When you hover the mouse over the desired point, the cursor changes its appearance, indicating a possible operation; in addition, when an operation is performed, the title and details of the current operation appear in the status bar. If the function corresponding to the control point is not applicable for the selected object, the cursor changes to a crossed-out circle. 88 User manual Figure 28.2. The vertex points of the marquee rectangle are used to rotate the object in the plane of the sheet about the center, shown as a small circle with a cross. By default, the center of rotation is set exactly in the center of the object's selection area, but you can move it with the mouse to any point on the page. For 3D objects, points at the vertices of the marquee allow you to rotate them in the plane of the sheet. Points on the sides of the object's selection area are used to distort the object in the appropriate direction. For 3D objects, these points allow you to rotate them in a plane that is perpendicular to the sheet plane and parallel to the side of the rectangular marquee containing the selected control point. The Effects panel allows you to perform other useful operations on objects, such as deformations, mirroring at any angle, building an object by rotating a flat prototype, and adjusting transparency. These tools will be discussed in the next edition of this manual. Using the point editor The point editing mode can be invoked through the Point Edit tool on the object panel (or options), the context drop-down menu (the “Point Edit” item) or from the keyboard by pressing the F8 key. This mode is available for objects constructed from Bezier curves. Most objects can be converted to Bezier curves if necessary, using the Convert item of the context drop-down menu. In the point editing mode, you can change the point type, close the curve, add and delete points using the point editor tools that appear on the object panel after you turn on the point editing mode. Right-click Chapter 28. Modifying Graphics Objects 89 Figure 28.3. Figure 28.4. desired point - it will be possible to change the angle and dimensions of the guide lines of the selected anchor point. Thus, you can change the degree of bending of the line on different sides of this point. The control points themselves can be moved, deleted, added and changed their type. In addition, the Edit Points panel contains tools for closing or opening the curve and converting it to a Bezier curve. Figure 28.5. For convenience, OpenOffice.org Draw distinguishes between three types of anchor points: Symmetrical transition - an anchor point with equal length guiding lines. When you change the length of one symmetrical transition guide, the second also changes the length. A smooth transition is a regular anchor point with different lengths and separately adjustable guides. The corner point is the anchor point at which the curve appears to break. The corner point direction lines may not be on the same line and may vary in length. Having selected the desired anchor point, you can easily change its type using the tools on the Edit Points panel. Properties of the area The area of an object, if it exists, can be very flexibly configured through the tools of the object panel (menu "Format" → "Area" or the context menu "Area"). It can have different fillings, cast a shadow and be transparent. The fill can be a color fill, a gradient fill, a hatch, or a bitmap texture. Shadow and transparency also have their own settings, which can be found on the corresponding tabs of the area properties window. Chapter 28. Modifying Graphic Objects 91 Line Properties Every OpenOffice.org Draw object contains lines - even text has a border that is not visible by default. The settings of these lines can be called through the tools of the object panel, the "Format" menu Line or through the context menu "Line"; in this case, you can change the color, thickness, set the transparency and provide the ends of the line with arrows of various types. Text properties For text and objects containing text, it is possible to change its appearance and properties through the tools on the object panel, the "Format" menu or the context menu. The properties of the text are called using the tools of the object panel, the menu "Format" → "Text" or the context menu "Text". Here it is determined whether the text will fit into the frame or vice versa - the text will set the size of the frame, as well as whether various creeping line effects will be applied when the text is displayed on the screen. To change the properties of characters and a paragraph, use other menu items "Character" and "Paragraph" of the context menu or the same items of the "Format" menu. 92 User Guide Chapter 29. Positioning Objects OpenOffice.org Draw has powerful tools for positioning objects. It is often necessary to align objects relative to each other, page or line; to perform these actions, use the tools on the Arrange and Align panels, as well as the "Distribute" item of the context menu or the "Actions" menu. The tools in the options bar help you position objects precisely. Alignment Any object can be aligned relative to the page margins using the appropriate tools in the Alignment detachable panel. Figure 29.1. There are separate tools for horizontal and vertical alignment - center and edge of the sheet. If you select several objects at once (while holding down the Shift key), you can use the same tools to align objects relative to the edges or center of the selection area. Location Depending on the order of creation, an object can overlap part of another object (s) or be overlapped by another object (s). To control the position of objects in depth, use the tear-off toolbar Arrangement. The panel has tools for moving an object directly to the front or back, changing the position sequentially (behind the object or in front of the object), changing the position relative to a specific object. It is also possible to swap (in depth) two objects. Chapter 29. Positioning Objects 93 Figure 29.2. Distribute This function allows you to align multiple objects relative to each other so that the distances between objects relative to the contours or centers of objects are equal. In this case, the outermost objects in the chain do not move. Figure 29.3. In order to use this function, you must first select three or more objects, and then call the "Distribution ..." item of the context menu or the "Actions" menu. Precise Positioning of Objects The OpenOffice.org Draw options panel has a number of handy tools to make it easy to accurately position objects relative to each other or to the sheet. Precise positioning is carried out by creating special marks or markers in the form of points or lines on the picture field, which can later be used for easier positioning of objects. These labels are called bindings. OpenOffice.org Draw supports several types of anchors: Grid - a grid is superimposed on the page margin. When this snapping is enabled, objects can be moved or scaled strictly along the grid points; User Guide 94 guide line - horizontal or vertical. To create this anchor, you need to left-click on the vertical or horizontal ruler and extend the line to the desired location on the sheet; page margins; object frames; object nodes; custom snap - specifies a line or point snap anywhere on the sheet with millimeter precision. Created using the "Insert" menu "Line / Anchor Point ..." Figure 29.4. There are tools to enable or disable various kinds of snaps: to to to to the grid; guide lines; page margins; frames and nodes of objects. Chapter 29. Positioning Objects 95 If you activate snapping, the object will be attracted to it as it moves, which greatly simplifies the precise positioning of the object. You can show or hide the anchor for greater clarity. The options panel contains tools for switching the visual display of two types of snaps and guiding frames of an object when moving: Figure 29.5. mesh; guide lines; guide lines of the object frame as you move. 96 User Guide Chapter 30. Converting Objects Any object in OpenOffice.org Draw can be converted into one form or another, depending on its type; the possible options are contained in the Convert context menu. This menu contains different sets of options depending on the type of object selected. So, for example, for three-dimensional objects there are only two options, and for a rectangle there are already seven. By transforming objects, you can get new objects with completely different properties that have a completely different look compared to the original. Chapter 31. Groups of objects 97 Chapter 31. Groups of objects To perform actions on several objects at once, it is convenient to use the grouping function. To create a group, you must first mark several objects by holding down the Shift key, and then select the "Group" item from the context menu (or the "Actions" menu) or use the Ctrl-Shift-G hotkey. Note If you use Ctrl-Shift as a keyboard switch and notice that similar combinations are used in many applications - try setting the language switching by Caps Lock (the case lock is switched by Shift-Caps Lock), it is more efficient. Figure 31.1. The created group behaves like a permanent selection of several objects. The advantage of a group over the usual selection of several objects lies precisely in the consistency, since it does not make it possible to forget to select an object before the operation. A group can always be split using the "Ungroup" item in the context menu or the "Actions" menu, or by using the Alt-Ctrl-Shift-G keyboard shortcut. To edit objects included in a group, there is no need to split the group - the operations of entering and exiting the group are intended for this. To do this, you can use the items "Enter the group" ("Exit the group") of the context menu or the "Actions" menu, or the hot key F3 (Ctrl-F3). You can leave the group by double-clicking the left mouse button past the group area, and enter - by double-clicking on the area of any object included in the group. After entering a group, objects that are not included in this group are displayed more dimly. This is done to make it easier to distinguish objects included in this group from others, as well as to indicate the mode of being in the group. Chapter 32. Combining Objects 99 Chapter 32. Combining Objects Creating a combination is as easy as grouping objects. To create a combination, you must first select several objects (holding the Shift key), and then select the "Combine" item in the context menu (or the "Actions" menu) or use the Ctrl-Shift-K hotkey. Unlike grouping, combining the selected objects creates a new object with new properties. The resulting combination inherits the properties of the object that was created first, or, more precisely, that is behind all other objects selected for the combination (see the section "Location"). You can only combine objects that can be converted to Bezier curves. Figure 32.1. At the intersection of objects in combination, transparent holes appear; this property is a payment for being able to split a combination. This method can also be used as a temporary union of objects before performing logical operations on them. The resulting combination can always be disconnected using the Disconnect Combination item of the context menu (or the Actions menu) or by using the Alt-Ctrl-Shift-K keyboard shortcut. For some types of objects, the combining process converts the object to Bezier curves, so although the combination can always be uncoupled, the combining operation is not completely reversible. 100 User Guide Chapter 33. Logical Operations on Objects OpenOffice.org Draw allows you to logically add, subtract and intersect objects. To perform logical operations, select several objects (holding the Shift key), then use the "Merge", "Subtraction" or "Intersection" items of the "Forms" context menu or the "Actions" → "Forms" menu to perform the required operation. As a result, a new object is formed, inheriting the properties of the oldest (or, more precisely, located deeper than all the others selected). Logical operations are irreversible, so if you want to undo the operation, the only way is to use the undo function of OpenOffice.org Draw, which is available through the Edit → Undo menu or the Ctrl-Z hotkey. Chapter 34. Naming Objects 101 Chapter 34. Naming Objects To simplify the work with complex drawings, OpenOffice.org Draw has the ability to name certain types of objects, which then appear in the status bar each time you select an object. In addition, the named objects are shown by the Navigator as separate elements of the drawing structure. You can assign a name only to: a group of objects; inserted objects: bitmap, OLE object, formula, etc. 102 User Guide Chapter 35. Graphic Styles Like a text document, a picture can contain styles, but only of one type - graphic. A graphic style is a comprehensive collection of attribute values for a wide variety of graphic objects. When applied to an object, the style overrides the values of the attributes of the given object with the new values specified for this style. Graphic styles are especially useful when creating complex drawings with repeating elements; they are indispensable for drawings, various diagrams, diagrams, etc. To create, modify, apply and delete them, it is most convenient to use the Stylist, which can be called from the "Format" → "Stylist" menu, by pressing the F11 key or from the function panel (Stylist On / Off). Figure 35.1. Chapter 35. Graphic Styles 103 Having selected an object or several objects using the Stylist, it is easy to apply any style - just double-click on the desired item in the Stylist window. To change the style itself, just click on the desired one and select the "Change" item from the drop-down menu. Changes to the style will affect all graphics to which it was applied. Part VI. Databases in OpenOffice.org 106 User Guide Chapter 36. Database Concepts A database in OpenOffice.org allows you to insert data from external resources. The source can be Adabas, JDBC, ODBC, ADO, dBase, Text File, Spreadsheet Document, or Address Book Data. Here we will not consider the theory of databases, but only its basic concepts, with which you can work in OpenOffice.org. These are: data source - primary resource; table rowsets of records; query is a command in SQL language that modifies data or one of their representations for the user; presentation (form, report) document for printing. Chapter 37. Creating and configuring a new data source 107 Chapter 37. Creating and configuring a new data source To create a new data source, you need to call the dialog in the menu "Tools" → "Initial data ...". Here you can edit existing or create new sources. To create, click on the New data source button - it will appear new entry in the list on the left. Figure 37.1. Setting up a data source (the "General" tab) On the first tab, enter the name of the resource and the source of the resource; in the Name field, enter the name of the database. In the Database type field, the actual database type is entered. As mentioned above, it can be Adabas, JDBC, ODBC, ADO, dBase, Text, Spreadsheet Document, Address Book Data. In the Source data URL field, enter the path to the database or the URL for accessing it. The next tabs in the dialog depend on the type of database source. For example, consider dBase as a database type. In the Source URL Data field, you must enter the path to an existing dBase database or the directory in which the data will be stored. 108 User Guide On the “dBase” tab, enter the parameters of the created database. All tables available in this database are shown on the Tables tab. Figure 37.2. Setting up a data source (the "Tables" tab) There are three buttons above the list of tables that are used to create a new table as well as edit and delete existing ones. When you click on the create table button, the constructor will be called. Here you need to enter fields and their types; after finishing editing, save the table in the database by entering its name. The edit button will bring up the same dialog. When deleting a table, you must confirm the operation. Chapter 38. Working with the address book as a database 109 Chapter 38. Working with the address book as a database As mentioned above, the source can be an address book exported to the OpenOffice.org database. When you first load OpenOffice.org, the program will ask for the data source for the address book; a new Address Book resource will appear in the "Initial Data" dialog box. However, you can skip entering the address book data at the first start and add this data source later. To use the address book, select it in the source data; specify the source in the dialog that appears. 110 User Guide Chapter 39. Entering and Modifying Data in Tables To enter data, open the "Initial Data" using the button on the toolbar on the right or by pressing the F4 key. Clicking on the + next to a data source opens a list in which you can select tables, queries or reports; selecting the desired table in it, you can enter new or change the already entered data. Chapter 40. Entering and building queries 111 Chapter 40. Entering and building queries On the "Queries" tab there is a list of queries that can be added, edited and deleted - for this there are six buttons above the list. Figure 40.1. Setting up a data source (“Queries” tab) The first button is used to create a new query using the builder; in the dialog that appears, select the table from which the selection will be made. This release of OpenOffice.org does not support concatenated queries, so only one table can be added. The second button also serves to create a request, but using SQL language ... In the dialog that appears, you need to enter a command to select from a table. This release of OpenOffice.org does not support multi-table and data-modifying queries. On the toolbar of the macro editing dialog, there are several buttons for working with a query. To process the request, you need to click on the start button. An additional panel will open containing a table with the query results. 112 User Guide After the start button there is a button for clearing the request. To switch between the query builder and the text of those, use the button for switching the designer view. Additional buttons follow. The first one is used to add a table to a query. The next group of buttons is used to turn on and off the groups used in the query. The first button allows you to use functions in the request. Disabling functions from the query builder prevents them from being entered. The second turns off the display of table names in the query. The third turns off table aliases. The fourth button allows you to exclude duplicate combinations from the request. Chapter 41. Creating reports 113 Chapter 41. Creating reports Reports are created on the last tab in the Initial data dialog. Here they can be created, edited, viewed, connected previously created or deleted. Figure 41.1. Configuring a data source (the "Reports" tab) The first button is used to include an existing file in the list of reports. The second button is used to edit the name and path to the report file; the third button is used to exclude from the list of the report. The next two buttons are used to view and edit the report. Clicking on one of these buttons will open a file with a report. When viewing a report, you can navigate through the records using the database toolbar at the bottom of the window. The last button is used to create a new report file; any type of document can be used in this capacity. When you click the button, select a report type from the list. To quickly create a report, you can use the Autopilot ... function. When this function is selected, a new window will open and a macro will run to create an autoreport; in the dialog that appears, enter the parameters step by step. At the first stage, a data source, table or query is selected from which data will be taken, and the fields that will be displayed. 114 User Guide On the second one you enter the parameters of the appearance of the report. This is the arrangement of fields in the report, the type of display of elements (can be no border, three-dimensional or flat) and the background of the report. After customizing the appearance of the report, click the Create button. The created documents can be printed in the same way as an ordinary text document. Data can be inserted into any document - to do this, insert the Text Box control (the Form button on the left panel) into it. In the form properties dialog (toolbar when selecting an object) on the "Data" tab, select the source database; in the Content type field - the origin of the data (table or query). In the Content field, specify the element (table, regular or SQL query) that will be used as data. In the properties dialog of the control on the "Data" tab, set the data field. To switch between editing and viewing modes of controls, use the On / Off button in the Form tool menu. project mode. Turn off project mode to view the data. At the bottom of the window, you will see the DB panel, with which you can navigate through the records, change and filter them. Part VII. Group work on a document User's Guide 116 Chapter 42. Introduction Often several authors or editors are involved in the process of creating or editing a document; at the same time, each participant works on his own copy of the document in parallel with other authors. In this case, it is very important to be able to accommodate changes made to your copy of the document by other authors. OpenOffice.org has special functions for group work on a document, available for text documents and spreadsheets. The whole set of functions of group work can be divided into two categories: 1. functions of making changes and commenting: recording changes; making changes without writing (undesirable to use); 2. functions of accepting / rejecting changes: combining documents; comparison of documents; acceptance / rejection of changes. Suppose, when working on a draft contract, an agreement with a lawyer and an accountant is required; each participant is given a copy of the agreement. The lawyer and accountant work independently on their copy of the contract and then return the revised copies of the contract. Chapter 43. Making changes to a document 117 Chapter 43. Making changes to a document The peculiarity of making changes when working in a group on a document is that all changes must be made when the option "Edit" → "Corrections" → "Save" is enabled. In this mode, all the changes made are displayed in a special way - with a color that is different for each author. In spreadsheets, cells containing changes are displayed with colored borders that correspond to the author who made the changes. In addition to color, for a text document: additions are highlighted with an underline; deletions are displayed as strikethrough text; The line containing the change is highlighted with a vertical line in the document margin. Figure 43.1. When you hover the mouse cursor over the place containing the change, a tooltip pops up containing information about the author, nature, date and time of the change. Each change can be provided with additional information in the form of a comment using the function "Edit" → "Corrections" → "Comment" - it will be displayed in the process of accepting or rejecting the change. The settings for displaying changes are available through the menu "Service" → "Options ..." then for text documents: "Text document" → "Corrections", and for spreadsheets: "Spreadsheet document" → "Corrections". 118 User Guide To turn off the mode of recording changes, select the menu “Edit” → “Corrections” → “Record” again. Keep in mind that not all changes are remembered in record mode, such as creating new styles and other complex formatting. After disabling the mode of recording changes, it is not recommended to edit the document. Chapter 44. Acceptance / rejection of amendments 119 Chapter 44. Acceptance / rejection of amendments Suppose that both the lawyer and the accountant have made changes to their copies of the agreement - now you need to update the original document to reflect the changes made by both the lawyer and the accountant. First, you need to combine three documents into one. To do this, you need to open the original contract and select the menu "Edit" → "Corrections" → "Combine Document ...". In the window that opens, select the file corrected by the lawyer and click the Insert button. The Accept or Reject Changes window will appear, displaying a list of the changes made by the lawyer. You can view and accept or reject the changes by selecting the appropriate line in the list and using the Accept (Accept All) and Reject (Reject All) buttons, or simply close this window and repeat the operation for the second file. Figure 44.1. Acceptance and rejection of changes (“List” tab) As a result of these operations, changes are made to the original contract, recorded by both a lawyer and an accountant. If the list of changes is very long, then it is convenient to use a filter that can be configured according to various parameters - date, author, action, and description. 120 User manual Figure 44.2. Acceptance and rejection of changes (the "Filter" tab) If any author made at least one change without turning on the mode of recording changes, the merge operation will fail. In this case, you can use the file comparison function. Suppose that when you merge with the accountant's file, you receive the message “Merge - Failed”, but you know that some changes have been made. This probably means that at least one change was made outside the record mode. You can try to determine the difference in the documents using the menu "Edit" → "Compare Document ...". In the window that appears, you must specify the file name of the copy of the accountant's agreement. If there are differences, the "Accept or reject changes" window will appear, in which the list of changes will be supplemented with those changes made by the accountant. When using the file compare function, it is very important to remember that the specified file is compared relative to the open file. Therefore, in our example, the changes made by the accountant will be inverted by action: what was added by the accountant will appear in the list of changes with the action Delete instead of Insert. This means that to apply the action, you need to press Reject instead of Accept and vice versa. Chapter 45. Document versions 121 Chapter 45. Document versions Any OpenOffice.org file can contain several different versions of a document. Versions can be viewed, created, deleted or compared with another using the item "File" → "Versions ...". The comparison generates a list of changes relative to the most recent version. OpenOffice.org 123 Table of Contents I. Getting Started with OpenOffice.org. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 1 1. Launch OpenOffice.org, open a file. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 2 II. Basics of working with text documents. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 5 2. Navigation through the text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 6 3. Basic principles of working with text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 7 Enter text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 7 Delete text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 7 Select text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 7 Copy and move text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 8 4. Formatting text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 9 Visually highlight text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 9 Changing the font, size, color of symbols. ... ... ... ... ... ... ... ... ... ... ... ... 9 Formatting paragraphs. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 12 Line spacing. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 13 Using lists. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 13 Applying special inserts. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 14 Setting up and using tabs. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 15 Draw frames and lines, ornate text. ... ... ... ... ... ... ... ... ... ... ... ... ... 17 5. Saving, opening and printing documents. ... ... ... ... ... ... ... ... ... ... ... ... ... 19 Saving and opening. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 19 Printing documents. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 21 6. Structural formatting. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 23 Structural and physical formatting. ... ... ... ... ... ... ... ... ... ... ... ... 23 Creating texts with or without styles. ... ... ... 24 Document structure (Navigator). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 27 7. Check spelling. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 29 8. Arrangement of hyphenation. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 31 9. Using the Find and Replace function. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 33 10. Customizing toolbars. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 35 11. Arrangement of windows on the screen. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 37 III. Spreadsheets. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 39 12. The main window of OpenOffice.org Calc. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 40 Menu. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 40 Input line. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 40 Symbol bars. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 40 Working area of the sheet. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 41 Status bar. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 41 Sheet navigator. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 41 13. Entering data. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 43 124 User Guide 14. Entering formulas. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 45 15. Autocomplete. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 48 16. Format of cells. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 50 17. Links. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 52 18. Diagrams. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 53 19. Styles. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 57 IV. Creation of presentations. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 59 20. Getting started with presentations. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 60 21. Modes of work with presentation. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 63 22. Working with a slide. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 65 23. Presentation panel. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 72 24. Effects of transition between slides. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 73 V. Using OpenOffice.org Draw. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 75 25. Types of drawings. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 77 26. Principles of work with the program. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 78 27. Graphic primitives. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 80 Creation of graphic primitives. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 80 Lines and arrows. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 80 Connecting line. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 80 Rectangles. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 81 Circles, ellipses, arcs, segments and sectors. ... ... ... ... ... 82 Three-dimensional objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 82 Text. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 82 Bézier curves, sketched curves, polygons. ... 83 28. Modification of graphic objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 86 Resizing and moving. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 86 Text of objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 87 Effects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 87 Using the Point Editor. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 88 Area properties. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 90 Line properties. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 90 Text properties. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 91 29. Positioning of objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 92 Alignment. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 92 Location. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 92 Distribution. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 92 Precise positioning of objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 93 30. Transformation of objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 96 31. Groups of objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 97 32. Combination of objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 99 33. Logical operations on objects. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 100 OpenOffice.org 34. Object naming. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 35. Graphic styles. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... Vi. Databases in OpenOffice.org. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 36. Basic concepts of databases. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 37. Creation and configuration of a new data source. ... ... ... ... ... ... 38. Working with the address book as a database. ... ... ... ... ... ... ... ... 39. Entering and changing data in tables. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 40. Entering and building queries. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 41. Creation of reports. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... Vii. Group work above the document. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 42. Introduction. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 43. Changes to the document. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 44. Acceptance / rejection of changes. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 45. Versions of documents. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 125 101 102 105 106 107 109 110 111 113 115 116 117 119 121 126 User manual List of illustrations 4.1. Text properties. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 4.2. Insert a custom field via the menu. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 4.3. Customizing custom fields. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 5.1. Saving the document. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 6.1. Stylist. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 6.2. Customizing styles. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 6.3. Customize indents and spacing. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 6.4. Navigator. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 7.1. Spell checker. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 8.1. Arrangement of hyphenation. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 9.1. Find and Replace. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 10.1. Customizing toolbars. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 12.1. The main OpenOffice.org Calc window. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 12.2. Insert sheet. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 12.3. Moving the sheet. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 13.1. Changing the size of cells. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 13.2. Cell attributes. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 14.1. Autopilot functions. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 18.1. Chart auto-format (dialog 1). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 18.2. Chart auto-format (dialog 2). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 18.3. Chart auto-format (dialog 3). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 18.4. Chart auto-format (dialog 4). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 18.5. Chart auto-format (dialog 5). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 20.1. Autopilot for presentations (dialogue 1). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 20.2. Autopilot for presentations (dialogue 2). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 20.3. Autopilot for presentations (dialogue 3). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 20.4. Autopilot for presentations (dialogue 4). ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 22.1. Selecting an effect. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 22.2. Apply a creeping line effect to the text. ... ... ... ... ... ... ... ... ... 22.3. Setting the background. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 24.1. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 26.1. General view of the main window of OpenOffice.org Draw. ... ... ... ... ... ... ... ... ... ... 26.2. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 26.3. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 27.1. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 27.2. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 27.3. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 27.4. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 27.5. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 11 15 15 19 24 24 26 27 29 31 33 35 40 41 41 43 43 46 53 53 54 55 55 60 60 60 60 65 67 69 73 78 78 78 80 80 81 82 82 OpenOffice.org 27.6. 27.7. 28.1. 28.2. 28.3. 28.4. 28.5. 29.1. 29.2. 29.3. 29.4. 29.5. 31.1. 32.1. 35.1. 37.1. 37.2. 40.1. 41.1. 43.1. 44.1. 44.2. 127. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 82. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 83. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 87. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 87. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 88. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 88. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 89. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 92. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 92. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 93. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 94. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 95. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 97. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 99. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 102 Data source configuration (General tab). ... ... ... ... ... ... ... 107 Configuring a data source (the Tables tab). ... ... ... ... 108 Configuring a data source (the Queries tab). ... ... ... ... ... 111 Configuring a data source (the Reports tab). ... ... ... ... ... ... 113. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 117 Acceptance and rejection of changes (List tab). ... ... 119 Acceptance and rejection of changes (Filter tab). ... ... 119 128 User manual List of tables 1.1. OpenOffice.org document types. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 2 4.1. Text alignment. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 13 4.2. Controlling tabs. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 17 22.1. Basic tools. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 65
Architecture of a distributed control system based on a reconfigurable multi-pipeline computing environment L-Net "transparent" distributed file systems
Email sending page Fill relay_recipients file with addresses from Active Directory
Missing language bar in Windows - what to do?