Zlatkovsky

name: 'Find available range (SO:50640779)'
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(() => tryCatch(run));

        async function run() {

Zlatkovsky

name: 'Custom Function Demo'
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        /** @CustomFunction */
        async function randomComment(id: number, fieldName: string): Promise<string> {
            let result = await (await fetch(`https://jsonplaceholder.typicode.com/comments/${id}`)).json();

Zlatkovsky

name: 'Get table intersection (StackOverflow:39729658)'
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(() => tryCatch(run));

        async function run() {

Zlatkovsky

name: Kiwi starter
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(() => tryCatch(run));

        async function run() {

Zlatkovsky

name: Table slow-perf workaround
description: 'https://github.com/OfficeDev/office-js/issues/12'
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |+

        wireUp("#setup", setup);
        wireUp("#run1", run1);

Zlatkovsky

name: Color Converter (Custom Function)
description: ''
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |+
        /** @customfunction */
        function toHex(input: string): string {
            return getColorOrInvalid(input, "toHexString");

Zlatkovsky

name: Merge namespaces
description: ''
author: Zlatkovsky
host: WEB
api_set: {}
script:
    content: |
        $("#run").click(run);

        function run() {

Zlatkovsky

name: Population analysis - JS ES5 (from "Building Office Add-ins")
description: Demonstrates a canonical Excel automation scenario using Office.js.
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(runAnalysis);
        $("#setup").click(setupPopulationData);

Zlatkovsky

name: Population analysis - single function (from "Building Office Add-ins")
description: Demonstrates a canonical Excel automation scenario using Office.js.
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |
        $("#run").click(() => tryCatch(runAnalysis));
        $("#setup").click(() => tryCatch(setupPopulationData));

Zlatkovsky

name: Gradient
description: Uses range formatting and external libraries to draw a colorful gradient within a range. Modified from sample by Alexander Zlatkovski.
author: Zlatkovsky
host: EXCEL
api_set: {}
script:
    content: |-
        initializeColorPickers();

        // Set up the click handler: