HEX2OCT function

PRO BASIC

In Jspreadsheet Formulas Pro, the HEX2OCT function is utilized to transform a hexadecimal number into an octal number. Hexadecimal numbers are a base-16 counting system, often used in computing, while octal numbers use a base-8 system. When you input a hexadecimal number into the HEX2OCT function, it will output the equivalent number in octal format. This is particularly useful in certain computing and programming contexts.

Documentation

Converts a hexadecimal number to octal.

Syntax

HEX2OCT(number,[places])

Parameter	Description
`number`	The hexadecimal number you want to convert to octal.
`[places]`	Optional. The number of characters to pad the octal result. If omitted, the function uses the minimum required digits.

Behavior

The HEX2OCT function takes a hexadecimal number as an input and converts it into an octal number. Here's how it handles different types of input:

Empty cells: If an empty cell is provided as an argument, HEX2OCT will return an error, as it expects a hexadecimal number as input.
Text: If a text string that isn't a valid hexadecimal number is provided, HEX2OCT will return an error. However, if the text string represents a valid hexadecimal number (for example, 'A'), it will be converted to its octal equivalent.
Booleans: Boolean values are not valid inputs for this function and will result in an error.
Errors: If the input cell has an error, the HEX2OCT function will also return an error.
Numeric values: Numeric values will be treated as hexadecimal numbers and will be converted to their octal equivalent. For instance, if the input is '10' (which is a hexadecimal number), the output will be '20' (its octal equivalent).

Common Errors

Error	Description
#NUM!	Occurs if the hexadecimal number is negative or outside the valid range (up to '1FFFFFFF').
#VALUE!	Occurs when the input argument is not a valid hexadecimal number, or the input cell is empty or contains non-numeric characters

Best practices

Always ensure that the inputs to the HEX2OCT function are valid hexadecimal numbers. Invalid inputs will result in errors.

Be cautious when inputting numeric values. The function will assume that they are hexadecimal numbers and will convert them accordingly.

Remember that HEX2OCT only accepts hexadecimal numbers up to '1FFFFFFF'. Anything beyond this will generate a #NUM! error.

Always check for error messages and understand what they signify to correctly use the HEX2OCT function.

Usage

A few examples using the HEX2OCT function.

HEX2OCT("B", 2) // Result: "13"
HEX2OCT("FF", 4) // Result: "0377"
HEX2OCT("1AC") // Result: "654"
HEX2OCT(255) // Result: "1125"

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Hex Value",
        "Octal (Auto)",
        "Octal (4 places)"
    ],
    [
        "A",
        "=HEX2OCT(A2)",
        "=HEX2OCT(A2,4)"
    ],
    [
        "FF",
        "=HEX2OCT(A3)",
        "=HEX2OCT(A3,4)"
    ],
    [
        "1AC",
        "=HEX2OCT(A4)",
        "=HEX2OCT(A4,4)"
    ],
    [
        "B",
        "=HEX2OCT(A5)",
        "=HEX2OCT(A5,4)"
    ]
]
  }]
});
</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('ZmM5MDY5YjRhZDVmMzU2OGEwMTVlNWU4MzQwNGVkOTQ4MTVlMTY4YTUyZGRlMTA0NWMyYTUxN2Y2MWRiOTIwMTkwMGNiODJhZmM1OTVhZmMwOWYxOTllMzFhNjg5ZmZmMGVlNzQ5ZTc3NTA4ZmI4YTc0NjJiNDY0M2U5NGIyMDEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBPRFExTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Hex Value",
        "Octal (Auto)",
        "Octal (4 places)"
    ],
    [
        "A",
        "=HEX2OCT(A2)",
        "=HEX2OCT(A2,4)"
    ],
    [
        "FF",
        "=HEX2OCT(A3)",
        "=HEX2OCT(A3,4)"
    ],
    [
        "1AC",
        "=HEX2OCT(A4)",
        "=HEX2OCT(A4,4)"
    ],
    [
        "B",
        "=HEX2OCT(A5)",
        "=HEX2OCT(A5,4)"
    ]
];

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

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Hex Value",
        "Octal (Auto)",
        "Octal (4 places)"
    ],
    [
        "A",
        "=HEX2OCT(A2)",
        "=HEX2OCT(A2,4)"
    ],
    [
        "FF",
        "=HEX2OCT(A3)",
        "=HEX2OCT(A3,4)"
    ],
    [
        "1AC",
        "=HEX2OCT(A4)",
        "=HEX2OCT(A4,4)"
    ],
    [
        "B",
        "=HEX2OCT(A5)",
        "=HEX2OCT(A5,4)"
    ]
]

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

// 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: [
    [
        "Hex Value",
        "Octal (Auto)",
        "Octal (4 places)"
    ],
    [
        "A",
        "=HEX2OCT(A2)",
        "=HEX2OCT(A2,4)"
    ],
    [
        "FF",
        "=HEX2OCT(A3)",
        "=HEX2OCT(A3,4)"
    ],
    [
        "1AC",
        "=HEX2OCT(A4)",
        "=HEX2OCT(A4,4)"
    ],
    [
        "B",
        "=HEX2OCT(A5)",
        "=HEX2OCT(A5,4)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub