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: |
    /**
     * Calculates the volume of a sphere.
     * @customfunction
     * @param {any} radius
     * @returns The volume of the sphere.
     */
    function setEntity(radius) {
      return {
        type: "Entity",
        basicType: "Error",
        basicValue: "#VALUE!",
        text: "Entity With API",
        properties: {
          TestDouble: {
            type: "Double",
            basicType: "Double",
            basicValue: 1,
            propertyMetadata: { excludeFrom: { cardView: true } }
          },
          TestString: { type: "String", basicType: "String", basicValue: "Test" }
        }
      };

      // return {
      //   type: "FormattedNumber",
      //   basicValue: 1.23,
      //   numberFormat: "0.00%",
      // };
    }
  language: typescript
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js
  [email protected]/client/core.min.js