Spreadsheets

General Information and User Interface Usage

Welcome to the %PRODUCTNAME Calc Help
%PRODUCTNAME Calc Features
Tipka prečca (%PRODUCTNAME Calc Dostupnost)
Precaci za Spreadsheet-ove
Error Codes in %PRODUCTNAME Calc
Dodaj-u Programiranje u %PRODUCTNAME kalkulatoru
Upute za oristenje %PRODUCTNAME kalkulatora

Command and Menu Reference

Menus

Izbornici
Datoteka
Uređivanje
Pogled
Ubaci
Oblik
Alati
Prozor
Podaci
Pomoć

Toolbars

Alatne trake
Formatting Bar
Drawing Object Properties Bar
Text Formatting Bar
Traka formule
Statusna traka
Page Preview Bar
Picture Bar
Tools Bar
Standard Bar
Table Data Bar
Form Navigation Bar
Query Design Bar
Form Design Toolbar

Functions Types and Operators

Čarobnjak Funkcije
Funkcije po kategoriji
Matricna funkcija
Bit Operation Functions
Funkcije baze podataka
Date & Time Functions
Financijske funkcije prvi dio
Financial Functions Part Two
Financial Functions Part Three
Informacijska funkcija
Logical Functions
Matematicke funkcije
Statistics Functions
Statistical Functions Part One
Statistical Functions Part Two
Statistical Functions Part Three
Statistical Functions Part Four
Statistical Functions Part Five
Funkcije Proracnuskih tablica
Funkcija teksta
Dodaj-u funkcija
Add-in Functions, List of Analysis Functions Part One
Dodaj u funkcije, Lista Analitičkih funkcija drugi dio
Operators in %PRODUCTNAME Calc
User-Defined Functions

Loading, Saving, Importing, and Exporting

Inserting External Data in Table (WebQuery)
Spremanje i otvaranje listova u HTMl-u
Importing and Exporting Text Files

Formatting

Rotirajuci tekst
Writing Multi-line Text
Formatiranje brojeva kao teksta
Tekstni eksponent/indeks
Mijenjanje Visine redova i širine stupaca..
Primjena pogofbenog oblikovanja
Oznacavanje negativnih brojeva
Pridruživanje formata formulama
Unos Broja sa Vodecim Nulama
Formatting Spreadsheets
Oblikovanje brojeva s Decimalama
Imenovanje celija
Rotating Tables (Transposing)
Preimenovanje listova
19xx/20xx godina
Using Rounded Off Numbers
Cells in Currency Format
Using AutoFormat for Tables
Inserting and Editing Comments
Izbor tema za listove
Entering Fractions

Filtering and Sorting

Applying Filters
Filter: Primjena Naprednih Filtera
Applying AutoFilter
Applying Sort Lists

Printing

Ispis redova ili stupaca na svakoj stranici
Printing Sheets in Landscape Format
Printing Sheet Details
Defining Number of Pages for Printing

Data Ranges

Defining Database Ranges
Filtriranje raspona ćelija
Sorting Data

Pivot Table

Pivot Table
Creating Pivot Tables
Deleting Pivot Tables
Editing Pivot Tables
Filtering Pivot Tables
Selecting Pivot Table Output Ranges
Updating Pivot Tables

Scenarios

Koristenje Scenarija

References

Addresses and References, Absolute and Relative
Referencing a Cell in Another Document
References to Other Sheets and Referencing URLs
Referencing Cells by Drag-and-Drop
Prepoznavanje Imena kao Adresiranje

Viewing, Selecting, Copying

Izmjena tablicnih pogleda
Displaying Formulas or Values
Freezing Rows or Columns as Headers
Navigating Through Sheets Tabs
Kopiranje na mnogostruke listove
Kopiraj samo vidljive celije
Selecting Multiple Cells

Formulas and Calculations

Calculating With Formulas
Kopiranje formula
Unos formula
Displaying Formulas or Values
Izracunavanje u proracunskim tablicama
Racunanje Sa Datumima i Vremenima
Automatically Calculating Series
Calculating Time Differences
Entering Matrix Formulas

Protection

Zastita Celija od Promjena
Unprotecting Cells

Miscellaneous

Deaktiviranje automatskih promjena
Consolidating Data
Primjenjivanje traženja cilja
Primjena visestrukih operatora
Applying Multiple Sheets
Validity of Cell Contents