The standard rules for typing text in Calc cells do not allow you to type text on multiple lines. And pressing the Enter key, which is familiar to Writer, only moves to the next cell. The placement of text on lines can be set both after typing, and in the process. In the first case, the cell text will consist of one paragraph, and in the second - of several.
How to set multiple lines of text without creating paragraphs In this case, the text in a cell will consist of one paragraph, and the number of lines will depend on the width of the cell.
2. Open the Format menu and select Cell from the command list.
3. In the Format Cells window, on the Alignment tab, in the On Page group, activate the Wrap by words item.
In the future, adjusting the column width, you can achieve the desired number of lines of text in the cell. How to set multiple lines of text by creating paragraphs In the second option, each line in a cell will be a separate paragraph, and the number of lines will remain the same for any column width.
1. In the open sheet window, type the first line of text in the required cell.
2. At the end of a line, use the Ctrl + Enter key combination to move to the second line of text.
3. If necessary, use this keyboard shortcut to create the next rows in the cell.
At the end of the last line, Ctrl + Enter should not be used, as this will affect the vertical alignment of the text. How to change the font color in a cell
2. Open the Font Color button menu on the Formatting toolbar.
3. In the palette that opens, click on the plate of the desired color. Conditional formatting of cells When creating documents and reformatting a large number of cells, you can use the following Calc setting - conditional formatting, that is, introducing a specific format into a cell when a specific specified condition is met. However, if the style for the cell is set, then it does not change. You can specify three conditions for comparing values \u200b\u200bor formulas in cells, which are tested in order from the first to the third conditions. If the first condition matches, the matching style is applied, the second condition is the next assigned style. How to set up conditional formatting To use conditional formatting, you must first make the settings. 1. In the open table window, expand the Tools menu.
2. In the list of commands, move the cursor over Cell Contents.
3. In the additional menu, activate the Calculate automatically item. How to use conditional formatting Using this guide, you can define up to three conditions for each cell by which a particular format is applied to it.
1. In the open sheet window, select the required cells.
2. Open the Format menu and select Conditional Formatting.
3. In the Conditional Formatting window, activate the Condition 1 value and in the first list select:
Cell value - if the conditional formatting depends on the cell value. Select the required condition in the list on the right: equal, less than, greater than, etc. And then in the field - a link, value or formula;
Formula - If the conditional formatting depends on the result of the formula. If you select this value, enter a cell reference in the box on the right. If the value of the cell reference is nonzero, then the condition is met.
4. In the Cell Style list, select the style (base, heading, etc.) to apply when the specified condition is met.
5. Close the window with the OK button. How to quickly transfer conditional formatting to other cells
1. In the open sheet window, select the cell with the created conditional formatting.
2. Click the Copy Formatting button on the Standard toolbar.
3. While holding down the left button, drag the cursor over the desired cells to which you want to apply conditional formatting. Formatting cells graphically Formatting cells graphically includes styling cell borders and filling their background. How to set the background fill of a cell By default, Calc uses a white cell background color. However, you can change the fill color as needed.
1. In an open table window, select the desired cell or range of cells.
2. Open the menu of the Background Color button on the Formatting toolbar.
3. In the palette that opens, click on the plate of the desired color. How to quickly set cell borders
1. In an open table window, select the desired cell or range of cells.
2. On the Formatting panel, expand the Border button menu.
3. In the list, click the button of the required frame. How to set additional border options for cells
1. In the open sheet window, select the desired range of cells.
2. Open the Format menu and select Cells from the command list.
3. In the Format Cells window, on the Borders tab, select a color, a border style, and a shadow position.
4. In the Content padding group, use the sliders to set the padding values.
5. Close the window with the OK button.
Three types of data are entered into table cells: text, number, formula. By the first character Calc determines what is entered: if it is a letter or an apostrophe, then it is text, if a digit is a number, if the equal sign is a formula. To enter data, you need to move to the desired cell, type the data and press Enter or the cursor movement key on the keyboard. Cell data is edited in several ways:
1) by clicking on a cell with the left mouse button and filling it in, while the previous data will be deleted;
2) by clicking on the cell with the left mouse button and the F2 function key on the keyboard, while the cursor will blink in the cell at the end of the word;
3) by double-clicking on a cell with the left mouse button (similar to pressing F2).
To select a data format, use the command Format\u003e Cells\u003e Numbers and then indicate the required format (Fig. 17).
If the text is not included in the cell, then we will choose one of the methods:
- move the borders of the cells horizontally by placing the cursor on the border between the letters of the columns (the cursor arrow turns into a double-headed arrow), and holding down the left mouse button, move the border to the required distance;
- merge several cells and write text in them. To do this, select several adjacent cells and select the path through the Main Calc menu: Format\u003e Merge Cells (we will do the same through the toolbar);
- we organize the wrapping of text in a cell by words: Format\u003e Cells\u003e Alignment\u003e Word Wrap (fig. 18).
If the number is not included in the cell, then Calc displays it either in exponential form (1230000000 - 1.23E + 09), or instead of the number it puts the signs ####. Then we expand the borders of the cell.
Double-clicking the left mouse button on the cell with the entered data switches to the data editing mode. The pointer then changes to a vertical line (cursor).
We can also switch to the data editing mode by clicking on the input line.
We carry out other cell settings in the same way. Let's consider in more detail Format\u003e Cells... The first tab Numbers (see Fig. 17) allows you to select the data format and adjust the selected format, for example, the number format allows you to specify number of leading zeros, fractional part, the ability to divide into digits, highlight negative numbers in a different color. After reviewing the different formats, we will see the settings made for them.
The next tabs are Font and Font effects (fig. 19 and 20).
Tab Alignmentis briefly described in Fig. eighteen.
To frame the table, perform the following settings:
- Position of lines: Selects a predefined style to be applied. There is also a button for this purpose. Framingon the toolbar Formatting.
- Line: Selects the border style to be used. This border is applied to the borders selected in the preview. To the toolbar Formattingyou can also add a button Line style... Here we indicate Line colorto be used for the selected borders.
- Indentation from content, that is, the amount of space that will be left between the border and the contents of the selection, on the specified side. Applying the same spacing to the content to all four boundaries when entering a new distance is carried out by checking the box next to Synchronize.
- Shadow style: Apply a drop shadow to the borders. For best results, apply this effect only when all four borders are visible. Here we choose Position, Widthand Colourshadows.
To select a cell fill, you must specify the color that will be displayed in the sample (field on the right).
The last tab is cell (fig. 23). We set the following parameters:
Protection:
- Hide all - hide the formulas and contents of the selected cells.
- Protected- we prohibit changing the selected cells.
- Hide formulas - hide formulas in selected cells.
Printing:
- Determines the print parameters of the sheet. Hide on print - prohibit printing of selected cells.
Leave your comment!
Tutorial - OpenOffice Basics
Text Editor - OpenOffice Writer
Hyphenation
For greater readability of the document, you can use the alignment of paragraphs to the left and right edges, but this is not always acceptable - in this case, the distance between characters in the text increases, which is especially noticeable if there are long words in the text; it is of course best to use hyphenation.
To OpenOffice.org Writer had the ability to place hyphens in the text, you need to set it in the language properties Russian (menu Tools-\u003e Options ...-\u003e Language Setting-\u003e Languages, field "Western").
Hyphenation can be done automatically or manually.
Automatic hyphenation is set in the paragraph properties - in the dialog for setting the properties of the paragraph style on the tab Position on the page In chapter Hyphenation you need to enable the option Automatically.
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 with a key combination Control + minus... You can search for all hyphenated words using the function Hyphenation on the menu Service.
Sign "=" means the place of possible transfer; "-" indicates the place where it will definitely be produced. To install the transfer, click on the button Transfer; to stop hyphenation, use the button Cancellation.
Using the button Remove the previously set word hyphenation is removed.
If you want the word to never be hyphenated, you need to add it to the signed dictionary "=" at the end.
