none
Refresh a chart from Javascript RRS feed

  • Question

  • I am deleting table rows in Excel and  set them again. After that I am calling the table method reapplyFilters. The chart is refreshed with the new data, but is not changed after reapplyFilters.

    Javascript:

    binding.deleteAllDataValuesAsync(function (deleteResult) {
                if (deleteResult.status == "succeeded") {
                  binding.addRowsAsync(myTable.rows, function (addResult) {
                    if (addResult.status === Office.AsyncResultStatus.Failed) {
                      write(addResult.error.name + ": " + error.message);
                    }
                    else {
                      write(myTable.plant, "Returned " + myTable.rows.length + " results.");
                      Excel.run(function (ctx) {
                        var t = ctx.workbook.tables.getItem(tableBinding.tableName);
                        t.reapplyFilters();
                        return ctx.sync();
                      });
                    }
                  });
    
                }
              });
    How to refresh a chart from Javascript.
    Wednesday, April 27, 2016 2:28 PM

Answers

  • Hi Mottor,

    I made a test with reapplyFilters, and I could reproduce your issue.

    For this issue, I suggest you submit a feedback in the link below:

    http://officespdev.uservoice.com

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    • Marked as answer by Mottor Thursday, April 28, 2016 7:44 AM
    Thursday, April 28, 2016 5:30 AM

All replies

  • Hi Mottor,

    I made a test with reapplyFilters, and I could reproduce your issue.

    For this issue, I suggest you submit a feedback in the link below:

    http://officespdev.uservoice.com

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    • Marked as answer by Mottor Thursday, April 28, 2016 7:44 AM
    Thursday, April 28, 2016 5:30 AM
  • Thank you Edward,

    I have made  suggestion

    Best Regards


    Mottor


    • Edited by Mottor Thursday, April 28, 2016 7:27 AM
    Thursday, April 28, 2016 7:26 AM