Tag Info

Hot answers tagged

3

To check that cells in excel sheet contain values between 1 and 6 do the following, Select all the cells that you want to check. the header of excel click in Conditional Formatting. In the drop down menu that appears click on new rule. A New Formatting Rule window will appear. Select rule type - Format only cells that contain. Now look at the edit rule ...


3

To motivate a point, I will describe two scenarios from a math class. First, think back to when you took math tests in school. Sometimes your teacher asked you to check your work. One way to check your work is to calculate everything twice, but of course if you miscalculated because of a misunderstanding, you will probably get the same, wrong answer ...


2

These numbers are just temporary numbers rather than serial numbers. It doesn't seem like a good idea to rename (renumber) a test case once it's been defined. When there's a future failure, it's harder to find results for that test case from a previous run if the test case name/serial number has changed. Is it necessary to have the test cases numbered in ...


1

One approach is to check the absolute value against a threshold, something like: =ABS(ROUND(AJ4,6)-ROUND(T4/100,6)) < 0.001 The threshold value has to be chosen knowing the magnitude of values being compared. You might compute the threshold based on the actual values, something like: =(ROUND(AJ4,6)+ROUND(T4/100,6))/(2000) This gives one-thousandth ...


1

You can read/write Excel files with Apache POI or JExcelApi Java libraries. Below are few examples. Apache POI writing spreadsheet example: import java.io.*; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFCell; ...


1

Adding references implies early binding. But early binding is not necessary to use any component registered in the COM registry. You can just use the CreateObject function to get back a late-bound reference to the object. It's not pretty, but it works. You just need to know the fully qualified name of the object. I'm assuming that here it's ...


1

Webdriver is a browser manipulation API only and as such the ability to read office or PDF files is out of scope of its capabilities, but the office interop libraries will allow you to read data from office files in C#, and there will be similar libraries for reading PDF documents.


1

I think I can point you in the right direction for MS Word, at least. You can use the Office Interop Assemblies in C#. Here is an example from .Net Pearls: using System; using Microsoft.Office.Interop.Word; class Program { static void Main() { // Open a doc file. Application application = new Application(); Document document = ...


1

I guess this link should answer all your questions.


1

couple of points/questions 1) what number of defects are we talking about ? If it's UAT and you are getting too many defects to enter manually then maybe you have other problems ? :) 2) Maintaining the defects in QC means there is a history behind them, doing it in Excel loses that. So maybe you gain from ease of use by using Excel but you could lose out ...


1

The dates for the burn down chart in excel for the Agile and CMMI templates are set by the date filters on the chart, you need to right click on the date column in the pivot table and then select the dates you want. For the new agile template, these dates are probably sourced from the start and finish dates on the sprint work item template.


1

What operating system are you using? If it is *nix, you could use html2text.


1

I believe a scripting language (like Perl) would enable you to parse an XLS for certain data, if you knew what you were looking for. Never done it myself though...


1

Our shop uses ALM 11.00 (new version of QC) but on the add-in page it specifically says the following Excel versions are supported: Versions supported: Microsoft Excel 2007 and 2010 (32 bit) with HP ALM 11.00. I would uninstall office 2010 and restall it as a 32 bit version. THe 32 bit version works on a 64 bit machine and I'm able to use the excel plugin ...



Only top voted, non community-wiki answers of a minimum length are eligible