Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

IMSEC function

Returns the secant of a complex number. The secant of a complex number can be expressed by:

``

The result is presented in the string format and has the character "i" or "j" as an imaginary unit.

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

This function is available since Office 3.6.

Syntax

IMSEC(Complex-number)

Complex-number is a complex number whose secant needs to be calculated.

A complex number is a string expression resulting in the form "a+bi" or "a+bj", where a and b are numbers.

If the complex number is actually a real number (b=0), then it can be either a string expression or a number value.

The function always returns a string representing a complex number.

If the result is a complex number with one of its parts (a or b) equal to zero, that part is not displayed.

Examples

=IMSEC("4-3i")
returns -0.0652940278579471+0.0752249603027732i.

=IMSEC(2)
returns -2.40299796172238 as a string. The imaginary part is equal to zero, so it is not displayed in the result.

Open file with example: