I suggest you ...

Allow Office Add-in in Excel to configure a cell so that user chooses value from a list of values

Enhance the Office JavaScript APIs (for Excel 2016+) to expose a mechanism (perhaps a Validation relationship or property) that allows the developer to configure a cell so that the end-user selects the value for the cell by picking from a list of values. The list of values might be specified by some other range. In a VSTO add-in (and native Excel) this can be achieved by configuring the Data Validation properties on a cell/range.

31 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Shaun Logan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    Shaun, thank you for the feedback! This is in our product roadmap and we plan to implement the API in the near future. This will be available as part of the promise based API set.

    As always, when the design draft is ready, we’ll present the design for review under the open-spec branches of this repository: https://github.com/officedev/office-js-docs.

    Thanks!
    Office Extensibility Team

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base