Importing sheets which have Formulas

[dvkbabu]

I have two sheets in xls file. I am using Formula(sum) in Sheet2 with the values of Sheet1. Like "=SUM(Sheet1!A2,Sheet1!B2)".

I have imported this xls file(both sheets) to QTP using DataTable.ImportSheet method. When I run the script, Data table is showing correct values for sheet1 but Sheet2 value is shown as #REF! and the formula is shown as (=SUM([]Sheet1!A1,[]Sheet1!B1)) in local data table sheet.

Any workaround for this? I am using QTP 9.2

Vijay

[savita.kale]

Hi vijay,
As it is mentioned in the QTP User's Guide that-
If you import a Microsoft Excel table containing combo
box or list cells, conditional formatting, or other special
cell formats, the formats are not imported and the cells are
displayed in the Data Table with a fixed value.