Calculates the volume of a sphere.

Basic custom function.EXCEL.yaml

name: Basic custom function
description: Calculates the volume of a sphere.
host: EXCEL
api_set: {}
script:
  content: |


    /**
     * Searches and creates snips for the results
     * @customfunction
     * @param {string} searchValue
     * @param {string} scope -> filepath.pdf, filename.pdf, group, All Documents
     * @returns searchValue if found
     */
    async function SnipSearch(searchValue, scope) {
      console.log("Cell is registered automated snip creation");
      return searchValue;
    }


    /**
     * Creates snip at certail location
     * @customfunction 
     * @param filename
     * @param pageNumber
     * @param x
     * @param y
     * @param width
     * @param height
     * @returns newValue and has as sight effect that the cell will be transformed to a snip
     */
    function SnipArea(filename, pageNumber, x, y, width, height) {
      console.log("Cell is registered automated snip creation");

      return "some value";
    }

    /**
     * Create a snip by matching in scope
     * @customfunction
     * @param {string} value
     * @param {string} scope
     * @returns newValue and has as sight effect that the cell will be transformed to a snip
     */
    function SnipMatch(value, scope) {
      console.log("Cell is registered automated snip creation");

      return value;
    }

    function DataSnipperXML() {
      // just an idea
      return "<xml></xml>";
    }
  language: typescript
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js
  [email protected]/client/core.min.js