IMSEC function

PRO BASIC

In Jspreadsheet Formulas Pro, the IMSEC function is used to calculate the secant of a complex number. This function is quite useful when you're dealing with complex numbers, where traditional mathematical operations can be challenging. You simply input the complex number into the function, and it gives you the secant value of that number. It's a great tool for those working with complex number calculations in Jspreadsheet.

Documentation

Returns the secant of a complex number.

Syntax

IMSEC(inumber)

Parameter	Description
`inumber`	The complex number for which you want to calculate the secant.

Behavior

The IMSEC function is used to return the secant of a complex number. The complex number is given in the format x+yi or x+yj.

If an empty cell is used as a reference, the function will treat it as zero.
When given text or strings that cannot be interpreted as a complex number, the function will return a #VALUE! error.
If a boolean value is used, it will be converted into numbers, with TRUE being 1 and FALSE being 0.
If the function encounters an error, it will return an error that corresponds to the problem, such as #VALUE!, #DIV/0!, or #NUM!.

Common Errors

Error	Description
#VALUE!	This error is returned when the given argument is non-numeric or cannot be interpreted as a complex number.
#NUM!	Occurs when the calculation results in a number too large to represent, or if the complex input produces an undefined secant value.
#DIV/0!	This error is returned when a division by zero occurs in the calculations.

Best practices

Always ensure that the complex number is in the correct format (x+yi or x+yj) for the IMSEC function to work correctly.

Use the IMSEC function with other complex number functions for more complex calculations.

Be aware of the limitations of the number size and the potential for #NUM! errors.

Handle possible errors such as #VALUE!, #DIV/0!, and #NUM! to make your spreadsheet more robust and reliable.

Usage

A few examples using the IMSEC function.

IMSEC("1+i") returns 0.498337030555187+0.591083841721045i
IMSEC("2+2i") returns -0.117475142661415+0.24745418582076i
IMSEC("5-3i") returns 0.0284335309099717+0.0956446409552864i

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ZGVkOGMzMzExOTJjYTQ1OTdmNTFiNDNjM2UxYjgwMTQwYTk0ZjMyNzE2Y2MxN2EyM2YxMTQwODc4MzJjNzVjOGU3ZDg2MjFmOTU5MjM1N2MxZjFiNDk3ZDMyMWYxMjEwMGE0OGM0MTIyMjhiODk5OTVlZjhlNjBkYjk0MDc4NGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE14TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Complex Number",
        "Secant"
    ],
    [
        "1+i",
        "=IMSEC(A2)"
    ],
    [
        "2+2i",
        "=IMSEC(A3)"
    ],
    [
        "5-3i",
        "=IMSEC(A4)"
    ],
    [
        "-1+2i",
        "=IMSEC(A5)"
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('ZGVkOGMzMzExOTJjYTQ1OTdmNTFiNDNjM2UxYjgwMTQwYTk0ZjMyNzE2Y2MxN2EyM2YxMTQwODc4MzJjNzVjOGU3ZDg2MjFmOTU5MjM1N2MxZjFiNDk3ZDMyMWYxMjEwMGE0OGM0MTIyMjhiODk5OTVlZjhlNjBkYjk0MDc4NGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE14TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Complex Number",
        "Secant"
    ],
    [
        "1+i",
        "=IMSEC(A2)"
    ],
    [
        "2+2i",
        "=IMSEC(A3)"
    ],
    [
        "5-3i",
        "=IMSEC(A4)"
    ],
    [
        "-1+2i",
        "=IMSEC(A5)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('ZGVkOGMzMzExOTJjYTQ1OTdmNTFiNDNjM2UxYjgwMTQwYTk0ZjMyNzE2Y2MxN2EyM2YxMTQwODc4MzJjNzVjOGU3ZDg2MjFmOTU5MjM1N2MxZjFiNDk3ZDMyMWYxMjEwMGE0OGM0MTIyMjhiODk5OTVlZjhlNjBkYjk0MDc4NGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE14TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Complex Number",
        "Secant"
    ],
    [
        "1+i",
        "=IMSEC(A2)"
    ],
    [
        "2+2i",
        "=IMSEC(A3)"
    ],
    [
        "5-3i",
        "=IMSEC(A4)"
    ],
    [
        "-1+2i",
        "=IMSEC(A5)"
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ZGVkOGMzMzExOTJjYTQ1OTdmNTFiNDNjM2UxYjgwMTQwYTk0ZjMyNzE2Y2MxN2EyM2YxMTQwODc4MzJjNzVjOGU3ZDg2MjFmOTU5MjM1N2MxZjFiNDk3ZDMyMWYxMjEwMGE0OGM0MTIyMjhiODk5OTVlZjhlNjBkYjk0MDc4NGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE14TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Complex Number",
        "Secant"
    ],
    [
        "1+i",
        "=IMSEC(A2)"
    ],
    [
        "2+2i",
        "=IMSEC(A3)"
    ],
    [
        "5-3i",
        "=IMSEC(A4)"
    ],
    [
        "-1+2i",
        "=IMSEC(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub