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

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

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