# 計算

Defines the calculation settings for spreadsheets. Defines the behavior of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets.

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

## 反覆式參照

### 循環

1. 在儲存格 A5、A6 和 A7 中分別鍵入文字「Selling price」、「Net」和「Value-added tax」。

2. 現在在儲存格 B5 中鍵入一個銷售價 (如 100)。淨價應當顯示在儲存格 B6 中，而增值稅應當顯示在儲存格 B7 中。

3. 您知道增值稅由「淨價乘以 15%」計算而來，而淨價由銷售價減去增值稅得出。在 B6 中鍵入公式 =B5-B7 以計算淨價，而在儲存格 B7 中鍵入公式 =B6*0.15 以計算增值稅。

4. 啟動循環以正確計算公式，否則[狀態列]中會顯示「循環參照」錯誤訊息。

 A B 5 VK 100 6 Netto =B5-B7 7 MwSt =B6*0.15

## 區分大小寫字母

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

## 搜尋條件 = 和 <> 必須為整個儲存格

 .* 下一個位置： 對搜尋的影響： win 尋找 win，但不是 win95、os2win 或是 gewinde win.* 尋找 win 和 win95，但不是 os2win 或是 gewinde .*win 尋找 win 和 os2win，但不是 win95 或是 gewinde win.* 尋找 win、win95、os2win 和 gewinde

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.

• ? (question mark) matches any single character

• * (asterisk) matches any sequence of characters, including an empty string

• ~ (tilde) escapes the special meaning of a question mark, asterisk or tilde character that follows immediately after the tilde character

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

## 以公式進行規則計算

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

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.

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

## 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.

## 小數點位數

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.