Context Aware Actions

The main section of xpna Home in the task pane is context aware so that when moving around an Excel workbook and changing the selection, xpna will offer a set of different actions that can be performed based on this context.

General Context

Name	Context	Actions
Empty Cell	A single empty cell is selected	Insert article table
Empty Range	A range of empty cells is selected	Insert article table
Cell	A single non-empty, non-xpna cell is selected	Resolve Members
Range	A range of non-emapty cells is selected	Convert selection to report

Formula Context

Name	Context	Actions
Article Send	A single xpna Article Send cell is selected	View and writeback (all) Article Send formula in workbook
Data	A single xpna Data cell is selected	Drill to transactions
Data Send	A single xpna Data Send cell is selected	View and writeback (all) Data Send formula in workbook
Data Write	A single xpna Data Write cell is selected	Drill to transactions Update number Writeback errors
Member	A single xpna Member cell is selected	Choose a different member Drill down (direction) Collapse

Table Context

Name	Context	Actions
Table	The current selection is inside a standard Excel table	Convert table to articles
Article Table	The current selection is inside a xpna Article table	Refresh article table
Transaction Table	The current selection is inside a xpna Drill To Transactions	N/A