Allow Excel Apps for Office to access cell address of selected cells
Enhance the Office JS API to allow apps to read the cell address of selected cells so a better experience can be provided for users who need to see cell references made via their app. Top priority items should include:
1. The ability to read the cell address of cells a user has selected when using addFromPromptAsync pop up. (e.g. Sheet1!$A$1). This is effectively the same address which shows within the addFromPromptAsync textbox currently.
2. Ability to read cell references of any selected cell/cell range.
This enhancement will be useful as currently apps can create a binding to a selection via the addFromPromptAsync pop up form however apps cannot show users where they previously bound to. A common use case of where this employed is where a user needs an app to keep track of certain cells to perform calculations based on their values but the user themselves will forget where those cells are. If apps can access the cell references then they can tell users where their previously bound cells are.
I have this scenario where users are performing reporting and their reporting parameters are inside Excel cells. When a single report can have multiple parameters, my users are finding it difficult to remember where they placed their bound parameters.
Thanks for the feedback. As your feedback is related to Excel Apps, please submit your idea to the Office Excel User Voice forum.