κ³μ°
μ€νλ λμνΈμ κ³μ° μ€μ μ μ§μ ν©λλ€. μν μ°Έμ‘°, λ μ§ μ€μ , μμμ μ΄ν μλ¦Ώμ, μνΈμμ κ²μν λ λλ¬Έμ λλ μλ¬Έμλ₯Ό ꡬλΆν μ§ μ¬λΆ λ±μ μ¬μ©νμ¬ μ€νλ λμνΈμ λμμ μ§μ ν©λλ€.
μνλλ μ°Έμ‘°
μ΄ μΉμ μμλ λ°λ³΅ κ³μ° μ€μ μνλλ μΆμ λ¨κ³ μλ₯Ό μ νν μ μμ΅λλ€. λν λλ΅μ μ νλλ₯Ό μ§μ ν μ μμ΅λλ€.
Iterations
μν μ°Έμ‘°κ° μλ μμ, μ¦ λ¬Έμ κ° ν΄κ²°λ λκΉμ§ κ³μ μνλλ μμμ μ ν΄μ§ μλ§νΌ λ°λ³΅ν λ€μ κ³μ°ν μ§ μ¬λΆλ₯Ό μ§μ ν©λλ€. λ°λ³΅ νμΈλμ μ ννμ§ μμΌλ©΄ ν μ΄λΈμ μν μ°Έμ‘°λ‘ μΈν΄ μ€λ₯ λ©μμ§κ° νμλ©λλ€.
μ: λΆκ°κ°μΉμΈλ₯Ό μ μΈνκ³ νλͺ© λΉμ©μ κ³μ°ν©λλ€.
-
μ A5μλ 'νλ§€ κ°κ²©', μ A6μλ 'μ κ°'λΌλ ν μ€νΈ, μ A7μλ 'λΆκ°κ°μΉμΈ'λ ν μ€νΈλ₯Ό μ λ ₯ν©λλ€.
-
μ΄μ μ B5μ νλ§€ κ°κ²©(μ: 100)μ μ λ ₯ν©λλ€. μ κ°λ μ B6μ νμνκ³ λΆκ°κ°μΉμΈλ μ B7μ νμν΄μΌ ν©λλ€.
-
λΆκ°κ°μΉμΈλ 'μ κ°*15%'λ‘ κ³μ°λκ³ νλ§€ κ°κ²©μμ λΆκ°κ°μΉμΈλ₯Ό λΉΌλ©΄ μ κ°κ° λ©λλ€. B6μ μμ =B5-B7μ μ λ ₯νμ¬ μ κ°λ₯Ό κ³μ°νκ³ μ B7μ =B6*0.15λ₯Ό μ λ ₯νμ¬ λΆκ°κ°μΉμΈλ₯Ό κ³μ°ν©λλ€.
-
μμμ μ¬λ°λ₯΄κ² κ³μ°νλ €λ©΄ λ°λ³΅ κ³μ°μΌλ‘ μ νν©λλ€. κ·Έλ μ§ μμΌλ©΄ 'μν μ°Έμ‘°' μ€λ₯ λ©μμ§κ° μν νμμ€μ νμλ©λλ€.
A |
B |
|
5 |
VK |
100 |
6 |
Netto |
=B5 B7 |
7 |
MwSt |
=B6*0.15 |
λ¨κ³
μ΅λ λ°λ³΅ λ¨κ³ μλ₯Ό μ€μ ν©λλ€.
μ΅μ λ³κ²½κ°
λ κ°μ§μ μ°μμ μΈ λ°λ³΅ λ¨κ³ κ²°κ³Όμ μ°¨μ΄λ₯Ό μ§μ ν©λλ€. λ°λ³΅ κ²°κ³Όκ° μ΅μ λ³κ²½ κ°λ³΄λ€ μμΌλ©΄ λ°λ³΅μ΄ μ€μ§λ©λλ€.
λ μ§
λ μ§μμ μ«μλ‘ λ΄λΆ λ³νμ μμν λ μ§λ₯Ό μ νν©λλ€.
1899.12.30 (νμ€)
1899/12/30μ 0μΌλ‘ μ€μ ν©λλ€.
1900.01.01 (StarCalc 1.0)
1900/01/01μ 0μΌλ‘ μ€μ ν©λλ€. λ μ§ νλͺ©μ ν¬ν¨νλ StarCalc 1.0 μ€νλ λμνΈμλ μ΄ μ€μ μ μ¬μ©ν©λλ€.
1904.01.01
1904/01/01μ 0μΌλ‘ μ€μ ν©λλ€. μΈκ΅ νμμΌλ‘ κ°μ Έμ¨ μ€νλ λμνΈμλ μ΄ μ€μ μ μ¬μ©ν©λλ€.
λ/μλ¬Έμ μ μ
μ λ΄μ©μ λΉκ΅ν λ ν μ€νΈμ λ/μλ¬Έμλ₯Ό ꡬλΆν μ§ μ¬λΆλ₯Ό μ§μ ν©λλ€.
μ: μ A1μλ 'Test' ν μ€νΈλ₯Ό μ λ ₯νκ³ B1μλ 'test' ν μ€νΈλ₯Ό μ λ ₯ν©λλ€. κ·Έλ° λ€μ μ C1μ "=A1=B1" μμμ μ λ ₯ν©λλ€. λ/μλ¬Έμ κ΅¬λΆ μμλ₯Ό μ ννλ©΄ μ μ FALSEκ° νμλκ³ , κ·Έλ μ§ μμΌλ©΄ TRUEκ° νμλ©λλ€.

ν μ€νΈ κΈ°λ₯ IDENTICALμ μ΄ λν μμμμμ μ€μ κ³Όλ μκ΄ μμ΄ νμ λ/μλ¬Έμλ₯Ό κ³ λ €ν©λλ€.

Disable case sensitivity for spreadsheets that need to be interoperable with Microsoft Excel.
보μ¬μ§λ μ νλ
μνΈμ νμλ λ°μ¬λ¦Όλ κ°μ μ¬μ©νμ¬ κ³μ°ν μ§ μ¬λΆλ₯Ό μ§μ ν©λλ€. μ°¨νΈμ νμλ κ°μ΄ ν¨κ» λνλ©λλ€. νμλ μ λ°λ μ¬μ© μ΅μ μ μ ννμ§ μμΌλ©΄ νμλλ μ«μλ§ λ°μ¬λ¦Όλκ³ λ΄λΆμ μΌλ‘λ λ°μ¬λ¦Όλμ§ μμ μ«μλ₯Ό μ¬μ©νμ¬ κ³μ°ν©λλ€.
κ²μ κΈ°μ€ =μ <>λ₯Ό μ 체 μ μ μ μ©
Calc λ°μ΄ν°λ² μ΄μ€ κΈ°λ₯μ λν΄ μ€μ ν κ²μ κΈ°μ€μ΄ μ 체 μ κ³Ό μ ννκ² μΌμΉνλλ‘ μ§μ ν©λλ€. κ²μ κΈ°μ€ =μ <>λ₯Ό μ 체 μ μ μ μ© νμΈλμ μ ννλ©΄ λ°μ΄ν°λ² μ΄μ€ ν¨μλ‘ μ μ κ²μν λ LibreOffice Calcκ° MS Excelκ³Ό λμΌν λ°©μμΌλ‘ μλν©λλ€.
λ€μ μμΉμμμ .* : |
μ°ΎκΈ°μ λν μν₯: |
win |
winμ μ°Ύμ§λ§ win95μ΄λ os2win, gewindeλ μ°Ύμ§ λͺ»ν©λλ€ |
win.* |
winκ³Ό win95λ μ°Ύμ§λ§ os2winμ΄λ gewindeλ μ°Ύμ§ λͺ»ν©λλ€ |
.*win |
winκ³Ό os2winλ μ°Ύμ§λ§ win95λ gewindeλ μ°Ύμ§ λͺ»ν©λλ€ |
win.* |
win, win95, os2win, gewindeλ₯Ό μ°Ύμ΅λλ€ |
κ²μ κΈ°μ€ =μ <>λ₯Ό μ 체 μ μ μ μ©μ νμ±ννμ§ μμΌλ©΄ "win" κ²μ ν¨ν΄μ ".*win.*"μ λκ°μ΄ μλν©λλ€. Calc λ°μ΄ν°λ² μ΄μ€ κΈ°λ₯μ μ¬μ©νμ¬ κ²μν κ²½μ°μλ κ²μ ν¨ν΄μ μ λ΄μ μ΄λ€ μμΉμλ λ μ μμ΅λλ€.

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. This relates to the database functions, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.
-
? (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. This relates to the database functions, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.

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. This relates to the database functions, and to VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.

Do not disable wildcards in formulas for spreadsheets that need to be interoperable with Microsoft Excel.
μ΄κ³Ό νμ λ μ΄λΈ μλμΌλ‘ μ°ΎκΈ°
μμμ μ μ ν μ€νΈλ₯Ό ν μ€νΈ μλμ μλ μ΄μ΄λ ν μ€νΈ μ€λ₯Έμͺ½μ μλ νμ λ μ΄λΈλ‘ μ¬μ©ν μ μλλ‘ μ§μ ν©λλ€. ν μ€νΈλ λ°λμ ν λ¨μ΄ μ΄μμΌλ‘ ꡬμ±λμ΄μΌ νλ©° μ°μ°μλ₯Ό ν¬ν¨ν μ μμ΅λλ€.
μ: μ E5λ "Europe" ν μ€νΈλ₯Ό ν¬ν¨ν©λλ€. μλ μ E6μλ κ° 100, μ E7μλ κ° 200μ΄ μμ΅λλ€. μ΄κ³Ό νμ λ μ΄λΈ μλμΌλ‘ μ°ΎκΈ° μμλ₯Ό μ ννλ©΄ μ 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.
μμμ μ리
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.