UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.
This website uses cookies. By continuing to browse or login to this website, you consent to the use of cookies. Learn more.
OK
swami_1
Cadet 1st Class
Cadet 1st Class
‎2008-12-05 17:53
84 views

Datatable without forumulas

Hi,

I just have a small question on the Datatable in QTP. I have an excel file with formulas in it. when the file is imported only the formulas are copied into Datatable.
However i need only the values in those cells.

Can somebody help me?
Hope this question is repeated again here.

thanks
0 Likes
Reply
Report Inappropriate Content
2 Replies
Rhonda Robinson
Absent Member.
Absent Member.
‎2008-12-05 18:17

The Datatables in QTP are not a full version of Excel. They are really only a spreadsheet of data. There is no support for formulas within the datatables.
0 Likes
Reply
Report Inappropriate Content
swami_1
Cadet 1st Class
Cadet 1st Class
‎2008-12-05 19:12

Thank you.
0 Likes
Reply
Report Inappropriate Content
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.