OCT2HEX function

PRO BASIC

The OCT2HEX function in Jspreadsheet Formulas Pro is a tool that allows you to convert an octal number into a hexadecimal number. Octal numbers are based on the number 8 and include digits from 0 to 7. Hexadecimal numbers, on the other hand, are based on the number 16 and include digits from 0 to 9 and letters from A to F. By using the OCT2HEX function, you can easily change a number from the octal system to the hexadecimal system.

Documentation

Converts an octal number to hexadecimal.

Syntax

OCT2HEX(num, [places])

Parameter	Description
`num`	The octal number you want to convert to hexadecimal. The number cannot contain more than 10 characters (digits).
`[places]`	An optional argument that specifies the minimum number of characters (digits) to use for the hexadecimal number.

Behavior

The OCT2HEX function is used to convert octal numbers to hexadecimal. Here is how it behaves:

It takes two arguments: the octal number to convert and an optional argument to specify the number of characters to use.
If the optional argument is not supplied, the function will use the minimum number of characters necessary to represent the number.
The function will ignore empty cells and treat them as 0s.
Boolean values are treated as numbers (TRUE = 1, FALSE = 0), so they are converted instead of returning an error. Non-numeric text still throws an error.
If the resulting hexadecimal number has more characters than specified by the optional argument, the function will return an error.

Common Errors

Error	Description
#NUM!	Occurs if the octal number is not valid (contains digits outside 0–7) or if the resulting hexadecimal number exceeds the maximum supported length.
#VALUE!	Occurs if a text string that cannot be interpreted as an octal number is passed. Boolean values are treated as numbers and converted instead of returning an error.
#N/A	Occurs if the required octal number argument is not provided.

Best practices

Always ensure that the octal number you're converting is a valid octal number and is not negative to avoid #NUM! errors.

Use the optional argument to specify the number of characters to use if you need a specific number of characters in your resulting hexadecimal number.

Be aware that the function will ignore empty cells and treat them as 0s. If this is not your intention, you should handle empty cells in your formula.

Avoid passing text strings or boolean values to the function to prevent #VALUE! errors.

Usage

A few examples using the OCT2HEX function.

OCT2HEX(63) returns 33  
OCT2HEX(72) returns 3A  
OCT2HEX(777,4) returns 01FF

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Octal Input",
        "Hex Output",
        "Hex (4 places)"
    ],
    [
        63,
        "=OCT2HEX(A2)",
        "=OCT2HEX(A2,4)"
    ],
    [
        72,
        "=OCT2HEX(A3)",
        "=OCT2HEX(A3,4)"
    ],
    [
        777,
        "=OCT2HEX(A4)",
        "=OCT2HEX(A4,4)"
    ],
    [
        154,
        "=OCT2HEX(A5)",
        "=OCT2HEX(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('Nzg2NGMzM2Y1NTBjMjIyMjNiOTA0NmQ2NzlmYWMxZDkyZWVmNmE3NDBmZGI5OGRhMDEwZWUyMjVlNTU2NjIxODNhNzUxYzYxYjQxNzlhYzcxYjkxNTc5ZGQzN2NjOTgyMDdmNTAzNmQ0NDgzODkzYWE0MjJkNGM1NjQwYWVlZGYsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpZeU1qVTJPVGM1TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0ltTm9ZWEowY3lJc0ltWnZjbTF6SWl3aVptOXliWFZzWVNJc0luQmhjbk5sY2lJc0luSmxibVJsY2lJc0ltTnZiVzFsYm5Seklpd2lhVzF3YjNKMFpYSWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0lzSW5CeWFXNTBJaXdpYzJobFpYUnpJaXdpWTJ4cFpXNTBJaXdpYzJWeWRtVnlJaXdpYzJoaGNHVnpJaXdpWm05eWJXRjBJbDBzSW1SbGJXOGlPblJ5ZFdWOQ==');

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

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

    // Worksheet data
    const data = [
    [
        "Octal Input",
        "Hex Output",
        "Hex (4 places)"
    ],
    [
        63,
        "=OCT2HEX(A2)",
        "=OCT2HEX(A2,4)"
    ],
    [
        72,
        "=OCT2HEX(A3)",
        "=OCT2HEX(A3,4)"
    ],
    [
        777,
        "=OCT2HEX(A4)",
        "=OCT2HEX(A4,4)"
    ],
    [
        154,
        "=OCT2HEX(A5)",
        "=OCT2HEX(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('Nzg2NGMzM2Y1NTBjMjIyMjNiOTA0NmQ2NzlmYWMxZDkyZWVmNmE3NDBmZGI5OGRhMDEwZWUyMjVlNTU2NjIxODNhNzUxYzYxYjQxNzlhYzcxYjkxNTc5ZGQzN2NjOTgyMDdmNTAzNmQ0NDgzODkzYWE0MjJkNGM1NjQwYWVlZGYsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpZeU1qVTJPVGM1TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0ltTm9ZWEowY3lJc0ltWnZjbTF6SWl3aVptOXliWFZzWVNJc0luQmhjbk5sY2lJc0luSmxibVJsY2lJc0ltTnZiVzFsYm5Seklpd2lhVzF3YjNKMFpYSWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0lzSW5CeWFXNTBJaXdpYzJobFpYUnpJaXdpWTJ4cFpXNTBJaXdpYzJWeWRtVnlJaXdpYzJoaGNHVnpJaXdpWm05eWJXRjBJbDBzSW1SbGJXOGlPblJ5ZFdWOQ==');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Octal Input",
        "Hex Output",
        "Hex (4 places)"
    ],
    [
        63,
        "=OCT2HEX(A2)",
        "=OCT2HEX(A2,4)"
    ],
    [
        72,
        "=OCT2HEX(A3)",
        "=OCT2HEX(A3,4)"
    ],
    [
        777,
        "=OCT2HEX(A4)",
        "=OCT2HEX(A4,4)"
    ],
    [
        154,
        "=OCT2HEX(A5)",
        "=OCT2HEX(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('Nzg2NGMzM2Y1NTBjMjIyMjNiOTA0NmQ2NzlmYWMxZDkyZWVmNmE3NDBmZGI5OGRhMDEwZWUyMjVlNTU2NjIxODNhNzUxYzYxYjQxNzlhYzcxYjkxNTc5ZGQzN2NjOTgyMDdmNTAzNmQ0NDgzODkzYWE0MjJkNGM1NjQwYWVlZGYsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpZeU1qVTJPVGM1TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2liRzlqWVd4b2IzTjBJbDBzSW5Cc1lXNGlPaUl6TkNJc0luTmpiM0JsSWpwYkluWTNJaXdpZGpnaUxDSjJPU0lzSW5ZeE1DSXNJbll4TVNJc0ltTm9ZWEowY3lJc0ltWnZjbTF6SWl3aVptOXliWFZzWVNJc0luQmhjbk5sY2lJc0luSmxibVJsY2lJc0ltTnZiVzFsYm5Seklpd2lhVzF3YjNKMFpYSWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0lzSW5CeWFXNTBJaXdpYzJobFpYUnpJaXdpWTJ4cFpXNTBJaXdpYzJWeWRtVnlJaXdpYzJoaGNHVnpJaXdpWm05eWJXRjBJbDBzSW1SbGJXOGlPblJ5ZFdWOQ==');

// 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: [
    [
        "Octal Input",
        "Hex Output",
        "Hex (4 places)"
    ],
    [
        63,
        "=OCT2HEX(A2)",
        "=OCT2HEX(A2,4)"
    ],
    [
        72,
        "=OCT2HEX(A3)",
        "=OCT2HEX(A3,4)"
    ],
    [
        777,
        "=OCT2HEX(A4)",
        "=OCT2HEX(A4,4)"
    ],
    [
        154,
        "=OCT2HEX(A5)",
        "=OCT2HEX(A5,4)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub