QTP and excel
I use QTP 9.0 version. I find the following problems with the default.xls.
1)Open default.xls spreadsheet outside QTP tool (from Excel application)
2)Create a 'data validation' on any column. (Select any column -> data -> Validation-> List ->select the area in excel for the values and click ok.)
This will enable you to select a value from the filter for any row of the above column.
3) close this and open the test (from QTp) with this default.xls.
I can't see this dropdown from QTP data table pane. So does it mean QTp doesnt support this functionality of excel?
Re: QTP and excel
Yes. You can't expect all the excel functionalities to work in QTP data table.