1.1.1 Writeri avamine ja sulgemine ICDL 1.1.1
LibreOffice Writer is a free, open-source word processing application — it's the Alin Li alternative to Microsoft Word! You can create letters, reports, essays, and much more.
To open Writer:
- Click the Application Menu (Tegevused või Start)
- Search for "LibreOffice Writer" or find it under "Office"
- Click to open — a blank document appears
To open an existing document: Ctrl + O → navigate to the file → click Open. Or double-click a .odt / .docx file in your File Manager.
To close: Click the ❌ button in the corner, or Ctrl + W (sulgeb dokumendi) / Ctrl + Q (sulgeb kogu rakenduse).
1.1.2 Dokumentide loomine mallidest ICDL 1.1.2
A template is a pre-designed document with formatting already set up (letterhead, CV, report layout). Instead of starting from scratch:
- Go to File → New → Templates
- Browse categories or search for a template
- Select one and click "Open" — a new document based on that template appears
1.1.3–1.1.4 Dokumentide salvestamine ICDL 1.1.3–1.1.4
| Toiming | Shortcut | What Happens |
|---|---|---|
| Save | Ctrl + S | Saves changes to the current file. First time? Opens "Save As" dialog. |
| Save As | Ctrl + Shift + S | Save with a new name, location, or different format. |
| Save as PDF | File → Export as PDF | Creates a .pdf file that looks the same on any device. |
Common file formats:
| Vorming | Extension | When to Use |
|---|---|---|
| Open Documenti tekst | .odt | Default format. Open standard — works in any word processor. Kasuta alati seda! |
| Microsoft Word | .docx | When sharing with people who use Microsoft Word |
| Lihttekst | .txt | Text only — no formatting, images, or tables |
.pdf | For final documents that shouldn't be edited — looks perfect everywhere |
1.1.5 Dokumentide vahel liikumine ICDL 1.1.5
When you have multiple documents open: go to the Window menu to see all open documents and click to switch. Or use Alt + Tab to switch between any open windows on your desktop.
1.2.1 Eelistuste seadistamine ICDL 1.2.1
Go to Tools → Options (Linuxis), et määrata:
| Setting | Where | What It Does |
|---|---|---|
| User name | LibreOffice → Kasutajaandmed | Your name appears in document properties and comments |
| Default save folder | LibreOffice → Asukohad | Choose where files save by default (e.g., /home/student/Documents) |
| Default file format | Laadimine/salvestamine → Üldine | Set to always save as .odt or .docx |
| AutoRecovery | Laadimine/salvestamine → Üldine | Auto-saves every X minutes (set to 5 min for safety!) |
1.2.2–1.2.4 Abi, suum ja tööriistaribad ICDL 1.2.2–1.2.4
Help: Press F1 or go to Help → LibreOffice Help to search for any topic.
Zoom: Use the slider in the bottom-right corner, or go to View → Zoom. Ctrl + hiirerullik suumib samuti sisse ja välja.
Toolbars: Go to View → Toolbars to show/hide toolbars. The Standard and Formatting toolbars are the most important. The Sidebar (Vaade → Külgriba või Ctrl + F5) annab kiire juurdepääsu omadustele, laadidele ja muule.
1.2.5–1.2.6 Dokumentides liikumine ICDL 1.2.5–1.2.6
| Shortcut | Toiming |
|---|---|
| Ctrl + Home | Jump to the beginning of the document |
| Ctrl + End | Jump to the end of the document |
| Ctrl + G | Go to a specific page number (Navigator) |
| Page Up / Page Down | Scroll one screen up/down |
| Ctrl + ← / → | Jump one word left/right |
| Home / End | Jump to start/end of current line |
| F5 | Ava Navigatori paneel (pealkirjade, tabelite ja piltide juurde liikumiseks) |
2.1.1–2.1.2 Dokumendivaated ICDL 2.1.1–2.1.2
| View Mode | Menüü | Best For |
|---|---|---|
| 📄 Tavaline (prindipaigutus) | View → Normal | The standard view — shows exactly how the document will look when printed, with page borders, margins, and headers/footers |
| 🌐 Web Layout | View → Web | Shows the document as it would appear in a web browser — no page breaks |
2.1.3 Teksti sisestamine ICDL 2.1.3
Simply click where you want to type and start typing! The cursor (blinking line |) shows where text will appear. Press Enter to start a new paragraph. Text automatically wraps to the next line — you don't need to press Enter at the end of each line.
2.1.4 Sümbolite ja erimärkide lisamine ICDL 2.1.4
Go to Insert → Special Character to insert symbols not on your keyboard:
2.2.1 Mitteprinditavad märgid ICDL 2.2.1
Mitteprinditavad märgid juhivad vormindust. Lülita need sisse/välja klahvidega Ctrl + F10 or the ¶ button on the toolbar:
| Symbol | Tähendab | Created By |
|---|---|---|
| · (punkt) | Tühik sõnade vahel | Pressing Spacebar |
| ¶ | End of a paragraph | Pressing Enter |
| ↵ | Käsitsi reavahetus (pehme reavahetus) | Shift + Enter |
| → | Tabeldusmärk | Pressing Tab key |
2.2.2 Teksti valimine ICDL 2.2.2
| What to Select | How to Do It |
|---|---|
| A word | Double-click the word |
| A line | Click in the left margin next to the line |
| A sentence | Click at the start, hold Shift, klõpsa lõpus |
| A paragraph | Triple-click anywhere in the paragraph |
| Kogu tekst | Ctrl + A |
| A specific range | Click at start → hold Shift → click at end |
| Mittekülgnev text | Select first part → hold Ctrl → select additional parts |
2.2.3–2.2.8 Teksti muutmine ICDL 2.2.3–2.2.8
Insert mode (vaikimisi): uus tekst lükkab olemasoleva teksti paremale.
Ülekirjutusrežiim: Press Insert key — new text replaces existing characters. (The status bar shows "Insert" or "Overwrite" at the bottom.)
Delete: Delete key removes the character AFTER the cursor. Backspace removes the character BEFORE the cursor.
Find: Ctrl + H opens Find & Replace. Or Ctrl + F for just Find.
Type what you're looking for → click "Find Next" or "Find All".
Replace: In Find & Replace dialog, type the old text in "Search For" and the new text in "Replace With". Click "Replace" (one at a time) or "Replace All" (all at once).
| Toiming | Shortcut | Effect |
|---|---|---|
| Copy | Ctrl + C | Copies selected text (original stays) |
| Cut (Move) | Ctrl + X | Removes selected text (ready to paste elsewhere) |
| Kleebi | Ctrl + V | Paigutab kopeeritud/lõigatud teksti kursori asukohta |
| Undo | Ctrl + Z | Reverses the last action (can press multiple times!) |
| Redo | Ctrl + Y | Redoes an undone action |
You can also copy/move text between open documents using the same shortcuts!
🎮 Activity: Shortcut Matching Game
Sobita iga kiirklahv selle tegevusega:
📖 Internetiallikad
3.1.1–3.1.2 Teksti põhivormindus ICDL 3.1.1–3.1.2
Select text first, then apply formatting:
| Formatting | Shortcut | Toolbar | Effect |
|---|---|---|---|
| Bold | Ctrl + B | B button | Muudab teksti paksemaks ja tumedamaks |
| Italic | Ctrl + I | I button | Muudab teksti kaldkirjaks |
| Underline | Ctrl + U | U button | Lisab teksti alla joone |
| Font Size | — | Size dropdown (e.g., 12pt) | Muudab teksti suuremaks või väiksemaks |
| Font Type | — | Font dropdown | Changes the style of letters (Arial, Times, Liberation Sans) |
3.1.3–3.1.6 Teksti täpsem vormindamine ICDL 3.1.3–3.1.6
| Feature | What It Does | Where to Find |
|---|---|---|
| Subscript | Text below the line: H₂O | Format → Text → Subscript or Ctrl + Shift + B |
| Superscript | Text above the line: E=mc² | Format → Text → Superscript or Ctrl + Shift + P |
| Font Colour | Changes the colour of text | Font Color dropdown on Formatting toolbar (A with coloured bar) |
| Case Changes | UPPERCASE, lowercase, Title Case | Format → Text → UPPERCASE / lowercase / Capitalize Every Word |
| Automatic Hyphenation | Splits long words at line ends with hyphens | Tools → Language → Hyphenation, or Format → Paragraph → Text Flow |
3.1.7 Hüperlingid ICDL 3.1.7
A hyperlink turns text into a clickable link that opens a web page, email, or another part of the document.
- Select the text you want to make into a link
- Go to Insert → Hyperlink (või vajuta Ctrl + K)
- In the "URL" field, type the web address (e.g., https://libreoffice.org)
- Click "Apply" then "Close"
To edit a hyperlink: right-click it → "Edit Hyperlink". To remove: right-click → "Remove Hyperlink".
3.2.1–3.2.4 Lõikude vormindamine ICDL 3.2.1–3.2.4
Creating paragraphs: Press Enter to create a new paragraph. To merge two paragraphs into one, place your cursor at the start of the second paragraph and press Backspace.
Reavahetus (pehme reavahetus): Press Shift + Enter to start a new line WITHOUT starting a new paragraph. Useful inside addresses or poems.
Text alignment:
| Joondus | Shortcut | What It Looks Like |
|---|---|---|
| ⬅️ Left | Ctrl + L | Text aligns to the left edge (default for most text) |
| ↔️ Centre | Ctrl + E | Text is centred on the page (good for titles) |
| ➡️ Right | Ctrl + R | Text aligns to the right edge (for dates, page numbers) |
| ⬌ Justified | Ctrl + J | Text stretches to fill both edges evenly (like in newspapers) |
3.2.5–3.2.6 Taanded ja tabelduskohad ICDL 3.2.5–3.2.6
| Indent Type | What It Does | How |
|---|---|---|
| Vasak taane | Liigutab kogu lõigu vasakust veerisest eemale | Format → Paragraph → Indents & Spacing → Before text |
| Right indent | Liigutab kogu lõigu paremast veerisest eemale | Format → Paragraph → Indents & Spacing → After text |
| First line indent | Taandatakse ainult esimene rida (nagu raamatutes) | Format → Paragraph → First line indent |
| Hanging indent | First line stays, rest of paragraph indents (for bibliographies) | Set negative first line indent |
Quick indent: Use the Increase Indent / Decrease Indent buttons on the toolbar, or drag the markers on the ruler.
Tabs let you align text at specific positions across the line. Types of tab stops:
| Tab Type | What It Does |
|---|---|
| Vasak tabelduskoht | Text starts at the tab position and goes right |
| Centre Tab | Text centres around the tab position |
| Right Tab | Text ends at the tab position (right-aligned) |
| Decimal Tab | Arvud joondatakse komakoha järgi (valuutaveergudes) |
Set tabs: Click on the ruler at the top of the page, or go to Format → Paragraph → Tabs.
3.2.7–3.2.8 Vahed ICDL 3.2.7–3.2.8
Go to Format → Paragraph → Indents & Spacing:
| Setting | What It Does |
|---|---|
| Lõigu kohal | Lisab vahe enne lõiku |
| Below paragraph | Lisab vahe pärast lõiku |
| Reavahe: ühekordne | Read on lähestikku (vaikimisi) |
| Reavahe: 1.5 rida | Keskmine vahe (levinud koolikirjandites) |
| Reavahe: kahekordne | Wide spacing (for editing drafts) |
3.2.9 Täpp- ja numberloendid ICDL 3.2.9
Select your text (or start typing), then click the Bulleted List või Nummerdatud loend button on the toolbar. To change style, click the dropdown arrow next to the button and choose a different style.
To remove bullets/numbers: select the list and click the button again (toggles off).
3.2.10 Lõikude äärised ja varjustus ICDL 3.2.10
Go to Format → Paragraph → Borders to add: border style (solid, dashed, dotted), line width, line colour, and background/shading colour. This is useful for highlighting important paragraphs or creating callout boxes.
3.3 Laadid ICDL 3.3
Styles are saved formatting settings you can apply instantly. They ensure consistent formatting throughout your document.
Lõigustiilid (Pealkiri 1, Pealkiri 2, Vaikimisi lõigustiil jne) juhivad tervet lõiku: fonti, suurust, vahesid ja joondust.
Character styles control just the selected characters — like making certain words always appear in bold red.
How to apply: Click in the paragraph (or select text) → use the Style dropdown on the left side of the Formatting toolbar → choose a style (Heading 1, Heading 2, Body Text, etc.).
Või ava Styles sidebar with F11 to see all available styles.
The Clone Formatting tool (paintbrush icon 🖌️ on toolbar) copies formatting from one place to another:
- Aseta kursor teksti sisse, mille vormingut soovid kopeerida
- Click the Clone Formatting button (paintbrush)
- Select the text you want to apply that formatting to
- Done! The formatting is applied.
Tip: Double-click the paintbrush to apply formatting to multiple places. Click it again (or press Esc) to stop.
4.1.1 Tabelite loomine ja kustutamine ICDL 4.1.1
- Go to Table → Insert Table (või Ctrl + F12)
- Choose the number of columns and rows
- Click OK — the table appears at your cursor position
Või kasuta Table button on the toolbar — hover over the grid to select size visually!
To delete a table: Click inside it → Table → Delete → Table.
4.1.2–4.1.4 Working with Table Data ICDL 4.1.2–4.1.4
Enter data: Click in a cell and type. Press Tab to move to the next cell. Press Shift + Tab to go back.
Select parts of a table:
| Select | How |
|---|---|
| Üks lahter | Click in the cell, then Ctrl + A (või klõpsa lahtri serval) |
| Rida | Click in the left margin next to the row / Table → Select → Row |
| Veerg | Click at the top edge of the column / Table → Select → Column |
| Entire table | Table → Select → Table, or click upper-left corner handle |
Insert/Delete rows & columns: Right-click inside the table → Insert/Delete Rows or Columns. Or use Table → Insert/Delete.
4.2 Table Formatting ICDL 4.2
| What to Change | How |
|---|---|
| Column width | Drag the column border on the ruler, or right-click → Table Properties → Columns |
| Row height | Drag the row border, or Table Properties → set height |
| Cell borders | Select cells → Table → Properties → Borders tab → choose style, width, colour |
| Cell shading | Select cells → Table → Properties → Background tab → choose colour |
4.3 Graphical Objects ICDL 4.3
- Aseta kursor sinna, kuhu soovid pilti
- Go to Insert → Image
- Browse to find your image file → click Open
- The image appears in your document!
You can also drag and drop an image file from the File Manager directly into the document.
Go to Insert → Shape → choose a shape category (Basic, Symbol, Arrow, Flowchart, Stars) → click and drag on the document to draw it.
Või kasuta Drawing toolbar: View → Toolbars → Drawing.
Select: Click on the object — handles (small squares) appear around it.
Teisaldamine: Click and drag the object to a new position. Or cut and paste to move between documents.
Copy: Ctrl + C then Ctrl + V. Töötab ka avatud dokumentide vahel.
Resize (keep proportions): Hold Shift and drag a corner handle. This maintains the aspect ratio so the image doesn't look squished!
Resize (freely): Drag a corner handle WITHOUT holding Shift — the image stretches in any direction.
Delete: Select the object → press Delete key.
📖 Internetiallikad
What is Mail Merge? ICDL 5.1
Kirjakooste lets you create personalised letters, labels, or envelopes for many people automatically. Instead of typing each person's name and address separately, you create ONE template letter and ONE data list — the computer combines them!
📄 Põhidokument — the letter or label template with placeholder fields
📊 Data Source — a spreadsheet or database with names, addresses, and other info (one row per person)
5.1.1–5.1.3 Setting Up Mail Merge ICDL 5.1.1–5.1.3
- Create your data source — Open LibreOffice Calc and create a spreadsheet with columns like: First Name, Last Name, Address, City, etc. Save it as
.ods - Ava või loo oma kiri in Writer — type the main content that everyone will receive
- Go to Tools → Mail Merge Wizard — follow the steps: choose letter type, select your spreadsheet data source
- Insert fields: Aseta kursor nime jaoks sobivasse kohta → klõpsa „Insert Data Field” → vali loendist „First_Name”. Korda perekonnanime, aadressi jne jaoks.
- Your letter now has placeholders like
<First_Name><Last_Name>that will be replaced with real data!
Dear <First_Name> <Last_Name>,
We are pleased to invite you to our Open Computing Day at Alin Li Academy!
Your personal invitation will be sent to:
<Address>, <City>
Warm regards,
Alin Li meeskond
5.2.1–5.2.2 Generating Output ICDL 5.2
Kui mall ja andmed on ühendatud:
- Click „Ühenda“ in the Mail Merge Wizard (or Tools → Mail Merge)
- Choose output: Uus dokument (loob ühe suure dokumendi kõigi kirjadega) või Printer (saadab otse printimiseks)
- Each person gets their own personalised letter with their name, address, and details filled in automatically!
You can also create address labels using File → New → Labels, then connecting to your data source the same way.
📖 Internetiallikad
6.1.1 Page Orientation & Size ICDL 6.1.1
Go to Format → Page Style → Page tab:
| Setting | Valikud | When to Use |
|---|---|---|
| Suund | 📄 Püstpaigutus (kõrge) / 🖼️ rõhtpaigutus (lai) | Püstine kirjade jaoks, rõhtne laiade tabelite või tunnistuste jaoks |
| Paberi suurus | A4 (21 × 29.7 cm), Letter (8.5 × 11 in) jne. | Enamikus riikides on standard A4; USA-s Letter |
6.1.2 Veerised ICDL 6.1.2
Veerised on tühi ruum lehe servades. Muuda neid menüüs Format → Page Style → Page tab:
Set Top, Bottom, Left, Right margins. Default is usually 2 cm (0.79 inches). For binding (printed booklets), increase the left or inner margin.
6.1.3–6.1.4 Page Breaks ICDL 6.1.3–6.1.4
Insert: Aseta kursor sinna, kuhu soovid uut lehekülge → Insert → More Breaks → Page Break (või Ctrl + Enter).
Delete: Show non-printing characters (Ctrl + F10) → aseta kursor vahetult leheküljepiiri ette → vajuta Delete.
6.1.5–6.1.6 Headers & Footers ICDL 6.1.5–6.1.6
Headers appear at the top of every page; footers appear at the bottom. Sobib hästi leheküljenumbrite, kuupäevade, pealkirjade ja autorinimede jaoks.
- Go to Insert → Header and Footer → Header → Default Page Style (või jalus)
- Lehe üla- või alaserva ilmub tekstiala — sisesta oma sisu
- To insert automatic fields: Insert → Header and Footer → Page Number, või Lisa → Väli → Kuupäev, Lehekülgede arv, Faili nimi, Autor
| Field | What It Shows | Insert Path |
|---|---|---|
| Leheküljenumber | Current page number (auto-updates) | Insert → Field → Page Number |
| Date | Today's date (auto-updates) | Insert → Field → Date |
| File Name | The document's file name | Insert → Field → File Name |
| Author | Your name (from user data settings) | Insert → Field → Author |
| Lehekülgede arv | Total number of pages | Insert → Field → Page Count |
Common format: "Page 3 of 12" — type "Page ", insert Page Number, type " of ", insert Page Count.
6.2.1–6.2.2 Spell Check ICDL 6.2.1–6.2.2
LibreOffice Writer joonib õigekirjavead alla red wavy lines and grammar issues in blue wavy lines.
Run spell check: Press F7 or go to Tools → Spelling. Iga vea korral saad teha järgmist:
| Toiming | What It Does |
|---|---|
| Change | Replace the misspelled word with the selected suggestion |
| Change All | Fix all instances of this misspelling in the document |
| Ignore Once | Skip this word just this time |
| Ignore All | Skip all instances of this word |
| Lisa sõnastikku | Lisab sõna sinu isiklikku sõnastikku (seda ei märgita enam veaks) |
6.2.3–6.2.4 Preview & Print ICDL 6.2.3–6.2.4
Print Preview: Press Ctrl + Shift + J or go to File → Print Preview. This shows exactly how pages will look on paper. Click "Close Preview" to return to editing.
Print: Ctrl + P opens the Print dialog:
| Valik | What It Does |
|---|---|
| Kõik lehed | Prints the entire document |
| Leheküljed | Print specific pages (e.g., 1, 3, 5-7) |
| Selection | Prints only the text you've selected/highlighted |
| Eksemplaride arv | Print multiple copies (e.g., 3 copies for 3 students) |
Alin Li ICDL akadeemia — Word Processing with LibreOffice Writer