jkpieterse

name: DemoOfLocalizedSystemName
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    async function run() {
      await Excel.run(async (context) => {

jkpieterse

name: FindItAll (5)
description: Finds all cells on a worksheet
host: EXCEL
api_set: {}
script:
  content: >
    document.addEventListener("keydown", function(event) {
      if (event.altKey && event.code === "KeyT") {
        $("#searchText").focus();
        event.preventDefault();

jkpieterse

name: Name a range
description: |-
  Names the selected range
  using TypeScript.
host: EXCEL
api_set: {}
script:
  content: >
    //The event handler of the button to add the name

jkpieterse

cpreg1 = LAMBDA(temp, press,
    LET(
        tau, 1386 / temp,
        pi, 0.1 * press / 16.53,
        -0.001 * rgas_water * tau ^ 2 * gammatautaureg1(tau, pi)
    )
);

cpreg2 = LAMBDA(temp, press,
    LET(

jkpieterse

QuadraticEquation = LAMBDA(a, b, c,
    (-b + {-1, 1} * SQRT(b ^ 2 - 4 * a * c)) / 2 / a
);

jkpieterse

SheetName =LAMBDA(cl,LET(f,CELL("filename",cl),MID(f,FIND("]",f)+1,LEN(f))))

jkpieterse

name: Mutliply range with 5
description: ''
author: jkpieterse
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(run);

        async function run() {

jkpieterse

name: Mutliply range with 5
description: ''
author: jkpieterse
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(run);

        async function run() {

jkpieterse

name: Blank snippet
description: ''
author: jkpieterse
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(run);

        async function run() {

jkpieterse

name: Blank snippet
description: ''
author: jkpieterse
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(run);

        async function run() {