Last active
March 19, 2019 06:14
-
-
Save crazygao/a38284b6ef3cfaefb75e56d3695990e3 to your computer and use it in GitHub Desktop.
Reproduce a bug
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Blank snippet (1) | |
description: Create a new snippet from a blank template. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
Office.initialize = function() { | |
const testKey = "test-pear-deck"; | |
Office.context.document.settings.refreshAsync(function (asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to refresh settings"); | |
} else { | |
const result = asyncResult.value.get(testKey); | |
console.log("settings: test-pear-deck = " + result); | |
} | |
}); | |
Office.context.document.settings.set(testKey, "string=value"); | |
Office.context.document.settings.saveAsync(function (asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to save"); | |
} else { | |
console.log("successful save"); | |
} | |
}); | |
console.log("Office initialize"); | |
} | |
$("#run").click(() => tryCatch(run)); | |
async function run() { | |
await Excel.run(async (context) => { | |
const sheet = context.workbook.worksheets.getActiveWorksheet(); | |
console.log("Your code goes here"); | |
await context.sync(); | |
}); | |
} | |
/** Default helper for invoking an action and handling errors. */ | |
async function tryCatch(callback) { | |
try { | |
await callback(); | |
} catch (error) { | |
// Note: In a production add-in, you'd want to notify the user through your add-in's UI. | |
console.error(error); | |
} | |
} | |
language: typescript | |
template: | |
content: | | |
<button id="run" class="ms-Button"> | |
<span class="ms-Button-label">Run</span> | |
</button> | |
language: html | |
style: | |
content: |- | |
section.samples { | |
margin-top: 20px; | |
} | |
section.samples .ms-Button, section.setup .ms-Button { | |
display: block; | |
margin-bottom: 5px; | |
margin-left: 20px; | |
min-width: 80px; | |
} | |
language: css | |
libraries: | | |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js | |
@types/office-js | |
[email protected]/dist/css/fabric.min.css | |
[email protected]/dist/css/fabric.components.min.css | |
[email protected]/client/core.min.js | |
@types/core-js | |
@microsoft/[email protected]/dist/office.helpers.min.js | |
@microsoft/[email protected]/dist/office.helpers.d.ts | |
[email protected] | |
@types/[email protected] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Document.Settings. | |
description: Reproduce a bug | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
Office.initialize = function() { | |
const testKey = "test-pear-deck"; | |
Office.context.document.settings.refreshAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to refresh settings"); | |
} else { | |
const result = asyncResult.value.get(testKey); | |
console.log("settings: test-pear-deck = " + result); | |
} | |
}); | |
Office.context.document.settings.set(testKey, "string=value"); | |
Office.context.document.settings.saveAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to save"); | |
} else { | |
console.log("successful save"); | |
} | |
}); | |
console.log("Office initialize"); | |
}; | |
$("#run").click(() => tryCatch(run)); | |
async function run() { | |
await Excel.run(async (context) => { | |
const sheet = context.workbook.worksheets.getActiveWorksheet(); | |
console.log("Your code goes here"); | |
await context.sync(); | |
}); | |
} | |
/** Default helper for invoking an action and handling errors. */ | |
async function tryCatch(callback) { | |
try { | |
await callback(); | |
} catch (error) { | |
// Note: In a production add-in, you'd want to notify the user through your add-in's UI. | |
console.error(error); | |
} | |
} | |
language: typescript | |
template: | |
content: | | |
<button id="run" class="ms-Button"> | |
<span class="ms-Button-label">Run</span> | |
</button> | |
language: html | |
style: | |
content: |- | |
section.samples { | |
margin-top: 20px; | |
} | |
section.samples .ms-Button, section.setup .ms-Button { | |
display: block; | |
margin-bottom: 5px; | |
margin-left: 20px; | |
min-width: 80px; | |
} | |
language: css | |
libraries: | | |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js | |
@types/office-js | |
[email protected]/dist/css/fabric.min.css | |
[email protected]/dist/css/fabric.components.min.css | |
[email protected]/client/core.min.js | |
@types/core-js | |
@microsoft/[email protected]/dist/office.helpers.min.js | |
@microsoft/[email protected]/dist/office.helpers.d.ts | |
[email protected] | |
@types/[email protected] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment