Izračunaj

Definiše postavke računanja za tablice za računanje. Definiše ponašanje tablica za računanje sa iterativnim referencama, postavkama datuma, brojem decimalnih mjesta, ili ako su velika slova ili manji slučajevi uzeti u obzir dok pretražujete unutar stranica.

To access this command...

Open a spreadsheet document, choose - LibreOffice Calc - Calculate.


Iterativne reference

U ovoj sekciji možete ograničiti broj približnih koraka poduzetih tokom iterativnih računanja. U dodatku, možete odrediti stepen preciznosti odgovora.

Iteracije

Određuje da li su formule sa iterativnim referencama (formule koje su konstantno ponovljene dok se problem ne riješi) izračunate nakon određenom broja ponavljanja. Ako Iteracije kutija nije označena, iterativna referenca u tabeli će uzrokovati poruku o grešci.

Primjer: Računanje troška predmeta bez vrijednosti-dodane takse.

  1. Upišite tekst 'Cijena prodaje' u ćeliju A5, tekst 'Neto' u ćeliju A6, i tekst 'Vrijednost-dodana taksa' u ćeliju A7.

  2. Sada upišite prodajnu cijenu (npr., 100) u ćeliju B5. Neto cijena bi trebala biti prikazana u ćeliji B6 i vrijednost-dodana taksa bi trebala biti prikazana u ćeliji B7.

  3. Vi znate da je vrijednost-dodana taksa izračunata kao 'neto cijena puta 15%' i da dođete do neto cijene oduzimajući vrijednost-dodane takse iz prodajne cijene. Upišite formulu =B5-B7 u B6 da izračunate neto cijenu, i upišite formulu =B6*0.175 u ćeliju B7 da izračunate vrijednost-dodanu taksu.

  4. Prebacite na iteracije da bi tačno izračunali formule, inače 'Kružna referenca' poruka o grešci se pojavljuje u Stanje Odjelu.

A

B

5

Selling Price

100

6

Mreža

=B5-B7

7

Tax

=B6*0.15


Koraci

Sets the maximum number of iteration steps.

Minimalna promjena

Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop.

Datum

Select the start date for the internal conversion from days to numbers.

12/30/1899 (uobičajeno)

Sets 12/30/1899 as day zero.

01/01/1900 (StarCalc 1.0)

Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries.

01/01/1904

Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format.

Razlikuj velika i mala slova

Specifies whether to distinguish between upper and lower case in texts when comparing cell contents.

Example: Type the text 'Test' in cell A1; and the text 'test' in B1. Then type the formula "=A1=B1" in cell C1. If the Case sensitive box is marked, FALSE will appear in the cell; otherwise, TRUE will appear in the cell.

note

The EXACT text function is always case-sensitive, independent of the settings in this dialog.


warning

Disable case sensitivity for spreadsheets that need to be interoperable with Microsoft Excel.


Preciznost kao što je prikazano

Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number.

Search criteria = and <> must apply to whole cells

Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When both, the Search criteria = and <> must apply to whole cells box and the Enable wildcards in formulas box are marked, LibreOffice Calc behaves exactly as Microsoft Excel when searching cells in the database functions.

* in following position:

Search result:

win

Finds win, but not win95, os2win, or upwind

win*

Finds win and win95, but not os2win or upwind

*win

Finds win and os2win, but not win95 or upwind

*win*

Finds win, win95, os2win, and upwind


If Search criteria = and <> must apply to whole cells is not enabled, the "win" search pattern acts like "*win*". The search pattern can be at any position within the cell when searching with the Calc database functions.

warning

Enable whole cell match for spreadsheets that need to be interoperable with Microsoft Excel.


Enable wildcards in formulas

Specifies that wildcards are enabled when searching and also for character string comparisons.

warning

Enable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


Enable regular expressions in formulas

Specifies that regular expressions instead of simple wildcards are enabled when searching and also for character string comparisons.

warning

Do not enable regular expressions in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


No wildcards or regular expressions in formulas

Specifies that only literal strings are used when searching and also for character string comparisons.

warning

Do not disable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.


Automatically find column and row labels

Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators.

Example: Cell E5 contains the text "Europe". Below, in cell E6, is the value 100 and in cell E7 the value 200. If the Automatically find column and row labels box is marked, you can write the following formula in cell A1: =SUM(Europe).

Limit decimals for general number format

You can specify the maximum number of decimal places that are shown by default for cells with General number format. If not enabled, cells with General number format show as many decimal places as the column width allows.

Decimalna mjesta

Defines the number of decimals to be displayed for numbers with the General number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers.

Please support us!