I am exporting test case and design step data into excel using the generate excel report from the dashboard. My query returns all the data fine when I run it, but after generating the excel sheet, all my steps and expected results have several squares with ? marks in them. These squares appear to represent what looks to be a carriage return AND a line feed when I try to clean it up in excel using substitution. I can use the clean function in excel, but that removes all the wanted line feeds within the cells.
Any thoughts as to an approach to either make sure they arent there in my query or how to clean it up? Each step within QC only have carriage returns at the end of the line.
example:
(line feed)(carriage return)
(line feed)(carriage return)
(line feed)(carriage return)
(line feed)(carriage return)
line 1 of text within test step(line feed)(carriage return)
(line feed)(carriage return)
line 2 of text within test step(line feed)(carriage return)
(line feed)(carriage return)
(line feed)(carriage return)
(line feed)(carriage return)
I want the cell for the step to simply look like the following(just as it does in QC):
line 1 of text within test step
line 2 of text within test step
I am using QC11 and Excel 2007, using the basic test case / test step query published on other posts on this site.
