New Excel Object in 14.5 - please add additional features to new Excel object similar to COM object
New Excel Object in 14.5 - please add additional features like '.RefreshAll', '.Application.Calculate', '.Application.CalculateFullRebuild' just like the Excel.application COM Object features. Though the new Excel object provides options to update the specified cell values, the other dependent cells that are having references to the parent cell are not getting updated automatically. For ex: Sheet1.Cell(A1) value is <Login URL> We are referencing this Sheet1.Cell value in other sheets having test cases as parameters like as follows: Sheet2.Cell(A1) having formula "=CONCATENATE(Sheet1!$A$1,"/page1")" Sheet3.Cell(A1) having formula "=CONCATENATE(Sheet1!$A$1,"/page2")" Currently we are using the'.RefreshAll', '.Application.Calculate', '.Application.CalculateFullRebuild' features of Excel.application Com object feature to refresh/update the excel files for this requirement. All the referenced cells are automatically updated. If this features are available in new Excel object then we can completely do away with Excel installation in Test Execution machines.
TestComplete 11.0 - Memory Issue
Environment Details: Windows 7, 64 Bit, 8 GB RAM TestComplete 11.0 Project Details: Used NameMapping Approach Defined All object references in one script file as Global Variables. There are 3000+ Variables. Reading and Writing Data from Excels Problem: When i open my project. RAM usage is 320-340 MB When i run any of my test function RAM usage will increase to 450-500 MB If i keep on running test functions RAM usage will increase to 800+ MB This is making my test execution go slow and crashing application under test. Anybody faced this kind of issue ? Why RAM usage will be increasing every time ? Is there any memory leakage ? Why after execution RAM usage is not coming to normal ?