SECH function

PRO BASIC

The SECH function in Jspreadsheet Formulas Pro is a mathematical formula that gives you the hyperbolic secant of a number. Basically, this means it performs a specific trigonometric calculation on the number you provide. You use it by typing =SECH() into a cell, then putting the number you want to calculate inside the parentheses. It's a useful formula for more complex calculations in fields like engineering or physics.

Documentation

Returns the hyperbolic secant of a number.

Syntax

SECH(number)

Parameter	Description
`number`	The numeric value for which to calculate the hyperbolic secant.

Behavior

The SECH function returns the hyperbolic secant of a number. Here's how it handles different inputs:

Numbers: If the input is a number, the function calculates the hyperbolic secant of the number.
Empty Cells: If a cell reference is empty, the function treats it as zero.
Non-Numeric Values: If the cell contains text, boolean values, or error values, the function will return an error.
Boolean Values: Boolean values are treated as numbers: TRUE is regarded as 1 and FALSE as 0.
Error: If any error occurs in the calculation or the input values, the function will return an error.

Common Errors

Error	Description
#VALUE!	If the function encounters a non-numeric value, it returns a #VALUE! error.
#NUM!	If the calculation results in a number that's too large or too small for the spreadsheet to handle, it returns a #NUM! error.

Best Practices

Always ensure that the input to the SECH function is a numeric value. Non-numeric values like text, boolean values or errors will cause the function to return an error.

Be aware that the SECH function treats an empty cell as zero, which might not always be the desired behavior.

Use error handling techniques to manage possible errors when using the SECH function. This will make your spreadsheet more robust and less likely to break with unexpected input values.

Keep in mind that the SECH function expects a real numeric input, not an angle in degrees or radians.

Usage

A few examples using the SECH function.

SECH(0.5) returns 0.886818884
SECH(1) returns 0.648054274

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('YjdmMjY0YTgzY2NkMGZjYjRlMDk2YmJlMWIxZDZiZGU2ZjMwNjRlYmVkNTBjOTJjNGU4NTdmYzIxMTZhNzU2MWE4NjZhYzZiZTExYTU1NjY1ZTEwMGE1MjQ0ODBjNTViN2JmM2VmMmNjMTNhYzJiNzhlMDU1MTk1YTU5Y2QzMjQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNemt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Angle (radians)",
        "Hyperbolic Secant"
    ],
    [
        0,
        "=SECH(A2)"
    ],
    [
        0.5,
        "=SECH(A3)"
    ],
    [
        1,
        "=SECH(A4)"
    ],
    [
        1.5,
        "=SECH(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('YjdmMjY0YTgzY2NkMGZjYjRlMDk2YmJlMWIxZDZiZGU2ZjMwNjRlYmVkNTBjOTJjNGU4NTdmYzIxMTZhNzU2MWE4NjZhYzZiZTExYTU1NjY1ZTEwMGE1MjQ0ODBjNTViN2JmM2VmMmNjMTNhYzJiNzhlMDU1MTk1YTU5Y2QzMjQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNemt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Angle (radians)",
        "Hyperbolic Secant"
    ],
    [
        0,
        "=SECH(A2)"
    ],
    [
        0.5,
        "=SECH(A3)"
    ],
    [
        1,
        "=SECH(A4)"
    ],
    [
        1.5,
        "=SECH(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('YjdmMjY0YTgzY2NkMGZjYjRlMDk2YmJlMWIxZDZiZGU2ZjMwNjRlYmVkNTBjOTJjNGU4NTdmYzIxMTZhNzU2MWE4NjZhYzZiZTExYTU1NjY1ZTEwMGE1MjQ0ODBjNTViN2JmM2VmMmNjMTNhYzJiNzhlMDU1MTk1YTU5Y2QzMjQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNemt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Angle (radians)",
        "Hyperbolic Secant"
    ],
    [
        0,
        "=SECH(A2)"
    ],
    [
        0.5,
        "=SECH(A3)"
    ],
    [
        1,
        "=SECH(A4)"
    ],
    [
        1.5,
        "=SECH(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('YjdmMjY0YTgzY2NkMGZjYjRlMDk2YmJlMWIxZDZiZGU2ZjMwNjRlYmVkNTBjOTJjNGU4NTdmYzIxMTZhNzU2MWE4NjZhYzZiZTExYTU1NjY1ZTEwMGE1MjQ0ODBjNTViN2JmM2VmMmNjMTNhYzJiNzhlMDU1MTk1YTU5Y2QzMjQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNemt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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: [
    [
        "Angle (radians)",
        "Hyperbolic Secant"
    ],
    [
        0,
        "=SECH(A2)"
    ],
    [
        0.5,
        "=SECH(A3)"
    ],
    [
        1,
        "=SECH(A4)"
    ],
    [
        1.5,
        "=SECH(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub