Skip to content

Instantly share code, notes, and snippets.

View MiaofeiWang's full-sized avatar

Miaofei Wang MiaofeiWang

  • Microsoft
View GitHub Profile
name: Set and Save Annotations
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#prepareChart").click(() => tryCatch(prepareChart));
$("#setAnnotation").click(() => tryCatch(setAnnotation));
$("#getAnnotation").click(() => tryCatch(getAnnotation));
$("#clean").click(() => tryCatch(clean));
@MiaofeiWang
MiaofeiWang / Set category label with images.EXCEL.yaml
Last active May 24, 2023 04:57
Put images in the places of category names of axis
This file has been truncated, but you can view the full file.
name: Set category label with images
description: Put images in the places of category names of axis
host: EXCEL
api_set: {}
script:
content: >
$("#prepareChart").click(() => tryCatch(prepareChart));
$("#setCategoryLabelWithIcon").click(() =>
tryCatch(setCategoryLabelWithIcon));
@MiaofeiWang
MiaofeiWang / Icon as data label.EXCEL.yaml
Last active May 23, 2023 05:54
Put images in the places of category names of axis
name: Icon as data label
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#prepareChart").click(() => tryCatch(prepareChart));
$("#setCategoryLabelWithIcon").click(() =>
tryCatch(setCategoryLabelWithIcon));
name: Chart - Find data point with specific xvalue
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@MiaofeiWang
MiaofeiWang / Adding ContentControl Assert be7xq.WORD.yaml
Created April 25, 2022 02:53
This script is to repro the assert issue when adding content control. Only repro on debug mode.
name: Adding ContentControl Assert be7xq
description: >-
This script is to repro the assert issue when adding content control. Only
repro on debug mode.
host: WORD
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
name: 'Repro Bug: only 1st category name shows shen setting them'
description: for bug 5181124
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
$("#addChartFromRange").click(() => tryCatch(addChartFromRange));
$("#onlySetCategoryNames").click(() => tryCatch(setCategoryNames));
name: Get image of chart
description: ''
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#run").click(() => tryCatch(run));
const sheetName = "Sample";
@MiaofeiWang
MiaofeiWang / BugRepro_ChartFormulaDoesnotTakeEffect.EXCEL.yaml
Created May 25, 2021 08:59
This is to repro bug that set formula doesn't take effect (if no refresh) for ChartTitle.setFormula(), ChartAxisTitle.setFormula and ChartDataLabel.formula.
name: BugRepro_ChartFormulaDoesnotTakeEffect
description: >-
This is to repro bug that set formula doesn't take effect (if no refresh) for
ChartTitle.setFormula(), ChartAxisTitle.setFormula and ChartDataLabel.formula.
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#run").click(() => tryCatch(run));
name: Repro Chart data label formula bug
description: ''
host: EXCEL
api_set: {}
script:
content: >
$("#run").click(() => tryCatch(run));
async function run() {
@MiaofeiWang
MiaofeiWang / BugRepro_CannotSetAxisPositionOniPad.EXCEL.yaml
Created April 12, 2021 06:29
This is to repro bug can user cannot set axis.position to 'minimum' on iOS.
name: BugRepro_CannotSetAxisPositionOniPad
description: This is to repro bug can user cannot set axis.position to 'minimum' on iOS.
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#run").click(() => tryCatch(run));
const sheetName = "Sample";