jiju-MS

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

jiju-MS

name: Group&UnGroup
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#group").click(() => tryCatch(group));
    $("#ungroup").click(() => tryCatch(ungroup));
    $("#showdetails").click(() => tryCatch(showdetails));
    $("#hidedetails").click(() => tryCatch(hidedetails));

jiju-MS

name: Group&UnGroup (1)
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#group").click(() => tryCatch(group));
    $("#ungroup").click(() => tryCatch(ungroup));
    $("#showdetails").click(() => tryCatch(showdetails));
    $("#hidedetails").click(() => tryCatch(hidedetails));

jiju-MS

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

    $("#test").click(() => tryCatch(test));

jiju-MS

name: Binding
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#add").click(() => tryCatch(run));
    $("#delete").click(() => tryCatch(del));
    async function run() {
      await Excel.run(async (context) => {

jiju-MS

name: Basic custom function (1)
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {number} radius

jiju-MS

name: Blank snippet (6)
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    var fontSize;
    var numFmt;
    var fillColor = "#FFFFFF";
    var fontColor;

jiju-MS

name: Return Error
description: ''
host: EXCEL
api_set: {}
script:
  content: |-
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {any} res

jiju-MS

name: Return Error Demo(Stock)
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |-
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {string | number} res

jiju-MS

/**
 * CustomFunction Return Error
 * @customfunction
 * @param {number} errorCase
 * @returns error
 */
function customErrorReturn(errorCase) {
  switch (errorCase) {
    case 1: {
      var error = new CustomFunctions.Error(