Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Entering data using the keyboard"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Entering data using the keyboard}} {{Documentation/CG3Ch2TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Enter edit format |NextPage=Documentatio...)
 
Line 30: Line 30:
 
== Entering dates and times ==
 
== Entering dates and times ==
 
Select the cell and type the date or time. You can separate the date elements with a slant (/) or a hyphen (–) or use text such as 10 Oct 03. Calc recognizes a variety of date formats. You can separate time elements with colons such as 10:43:45.
 
Select the cell and type the date or time. You can separate the date elements with a slant (/) or a hyphen (–) or use text such as 10 Oct 03. Calc recognizes a variety of date formats. You can separate time elements with colons such as 10:43:45.
 +
 +
== Entering special characters ==
 +
A “special” character is one not found on a standard English keyboard. For example, © ¾ æ ç ñ ö ø ¢ are all special characters. To insert a special character:
 +
 +
# Place the cursor in your document where you want the character to appear.
 +
# Click '''Insert > Special Character''' to open the Special Characters dialog.
 +
# Select the characters (from any font or mixture of fonts) you wish to insert, in order; then click '''OK'''. The selected characters are shown in the lower left of the dialog. As you select each character, it is shown on the lower right, along with the numerical code for that character.
 +
 +
[[Image:SpecialChars.png|thumb|none|500px|''The Special Characters dialog , where you can insert special characters.'']]
 +
 +
{{Documentation/Tip| Notice that the characters selected appear in the bottom-left corner of the dialog.}}
 +
 +
{{Documentation/Note| Different fonts include different special characters. If you do not find a particular special character you want, try changing the ''Font ''selection.}}
 +
 +
=== Inserting non-breaking spaces and hyphens ===
 +
'''Non-breaking spaces'''
 +
 +
To prevent two words from being separated at the end of a line, press ''Control+spacebar'' after the first word.
 +
 +
'''Non-breaking hyphen'''
 +
 +
You can use a non-breaking hyphen in cases where you do not want the hyphen to appear at the end of a line, for example in a number such as 123‑4567. To insert a non-breaking hyphen, press ''Control+Shift+minus sign''.
 +
 +
=== Inserting dashes ===
 +
To enter en and em dashes, you can use the ''Replace dashes'' option under '''Tools > AutoCorrect > Options'''. This option replaces two hyphens, under certain conditions, with the corresponding dash.
 +
 +
In the following table, the A and B represent text consisting of letters A to z or digits 0 to 9.
 +
 +
{| class="prettytable"
 +
! Text that you type:
 +
! Result
 +
 +
|-
 +
| A - B (A, space, minus, space, B)
 +
| A – B (A, space, en-dash, space, B)
 +
 +
|-
 +
| A -- B (A, space, minus, minus, space, B)
 +
| A – B (A, space, en-dash, space, B)
 +
 +
|-
 +
| A--B (A, minus, minus, B)
 +
| A—B (A, em-dash, B)
 +
 +
|-
 +
| A-B (A, minus, B)
 +
| A-B (unchanged)
 +
 +
|-
 +
| A -B (A, space, minus, B)
 +
| A -B (unchanged)
 +
 +
|-
 +
| A --B (A, space, minus, minus, B)
 +
| A –B (A, space, en-dash, B)
 +
 +
|}
  
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category: Calc Guide (Documentation)]]
 
[[Category: Calc Guide (Documentation)]]

Revision as of 08:01, 10 March 2009



Most data entry in Calc can be accomplished using the keyboard.

Entering numbers

Click in the cell and type in the number using the number keys on either the main keyboard or the numeric keypad.

To enter a negative number, either type a minus (–) sign in front of it or enclose it in parentheses (brackets), like this: (1234).

By default, numbers are right-aligned and negative numbers have a leading minus symbol.

Entering text

Click in the cell and type the text. Text is left-aligned by default.

Entering numbers as text

If a number is entered in the format 01481, Calc will drop the leading 0. (Exception: see Tip below.) To preserve the leading zero, for example for telephone area codes, type an apostrophe before the number, like this: '01481.

The data is now regarded as text by Calc. Formulas and functions will treat the entry like any other text entry, which typically results in it being a zero in a formula, and being ignored in a function.

Template:Documentation/Tip

Template:Documentation/Note

Entering dates and times

Select the cell and type the date or time. You can separate the date elements with a slant (/) or a hyphen (–) or use text such as 10 Oct 03. Calc recognizes a variety of date formats. You can separate time elements with colons such as 10:43:45.

Entering special characters

A “special” character is one not found on a standard English keyboard. For example, © ¾ æ ç ñ ö ø ¢ are all special characters. To insert a special character:

  1. Place the cursor in your document where you want the character to appear.
  2. Click Insert > Special Character to open the Special Characters dialog.
  3. Select the characters (from any font or mixture of fonts) you wish to insert, in order; then click OK. The selected characters are shown in the lower left of the dialog. As you select each character, it is shown on the lower right, along with the numerical code for that character.
The Special Characters dialog , where you can insert special characters.

Template:Documentation/Tip

Template:Documentation/Note

Inserting non-breaking spaces and hyphens

Non-breaking spaces

To prevent two words from being separated at the end of a line, press Control+spacebar after the first word.

Non-breaking hyphen

You can use a non-breaking hyphen in cases where you do not want the hyphen to appear at the end of a line, for example in a number such as 123‑4567. To insert a non-breaking hyphen, press Control+Shift+minus sign.

Inserting dashes

To enter en and em dashes, you can use the Replace dashes option under Tools > AutoCorrect > Options. This option replaces two hyphens, under certain conditions, with the corresponding dash.

In the following table, the A and B represent text consisting of letters A to z or digits 0 to 9.

Text that you type: Result
A - B (A, space, minus, space, B) A – B (A, space, en-dash, space, B)
A -- B (A, space, minus, minus, space, B) A – B (A, space, en-dash, space, B)
A--B (A, minus, minus, B) A—B (A, em-dash, B)
A-B (A, minus, B) A-B (unchanged)
A -B (A, space, minus, B) A -B (unchanged)
A --B (A, space, minus, minus, B) A –B (A, space, en-dash, B)


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Entering_data_using_the_keyboard&oldid=115354"
Personal tools