Navigates and selects an option from the spreadsheet menu.
Object- xPath to the spreadsheet menu (See the Spreadsheet Menu section of Working with xPath) and xPath to the spreadsheet sub menu like Sheet, Edit, Display or Rows delimited by , symbol
Data- The path you want to take in the menu delimited by the character >
Example
‘Rows>Insert Multiple’ will open the insert multiple dialog so that multiple rows can be inserted.
The xPath in the repository would be as follows:
SSMenu = //*[contains(@data-qa-locator,'<data-qa-locator value>')]/div/div/div/i
RowMenu = //*[contains(@data-qa-locator,'<data-qa-locator value>')]/div[2]/table/tbody/tr