Isi

Microsoft Excel wrongly assumes year 1900 to be a leap year and considers the inexistent day of 1900-02-29 as valid in date calculations. Dates prior to 1900-03-01 are therefore different in Excel and Calc.

## Sintaksis

## Contoh

## Returns

Yes

No

Aangka kompleksadalah untaian hasil ekspresi di formulir "a+bi" atau "a+bj", dimana a dan b adalah angka.

Jika angka kompleksadalah sebenarnya angka asli (b=0), lalu itu bisa menjadi untaian ekspresi atau nilai angka.

Fungsi selalu mengembalikan untaian mewakili angka kompleks.

Jika hasil adalah angka kompleks dengan satu dari bagian (a atau b) sama dengan nol, maka bagian tersebut tidak ditampilkan.

Bagian imajiner sama dengan nol, jadi tidak ditampilkan dihasil.

Hasilnya disajikan dalam format string dan memiliki karakter "i" atau "j" sebagai unit imajiner.

String 1 [; String 2 [; … [; String 255]]]

String 1; String 2; … ; String 255 are strings, references to cells or to cell ranges of strings.

Integer 1 [; Integer 2 [; … [; Integer 255]]]

Integer 1; Integer 2; … ; Integer 255 are integers, references to cells or to cell ranges of integers.

Number 1 [; Number 2 [; … [; Number 254]]]

Number 1; Number 2; … ; Number 254 are numbers, references to cells or to cell ranges of numbers.

Number 1 [; Number 2 [; … [; Number 255]]]

Number 1; Number 2; … ; Number 255 are numbers, references to cells or to cell ranges of numbers.

Logical 1 [; Logical 2 [; … [; Logical 255]]]

Logical 1; Logical 2; … ; Logical 255 are boolean values, references to cells or to cell ranges of logical values.

Complex 1 [; Complex 2 [; … [; Complex 255]]]

Complex 1; Complex 2; … ; Complex 255 are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form "x+yi" or "x+yj".

Reference 1 [; Reference 2 [; … [; Reference 255]]]

Reference 1; Reference 2; … ; Reference 255 are references to cells.

This function is always recalculated whenever a recalculation occurs.

The function is always case insensitive, independent from the setting of Case sensitive checkbox in LibreOffice - Preferences Tools - Options - LibreOffice Calc - Calculate. You can however, use the mode modifier (?-i) in regular expressions to force search for a case-sensitive match.