It's all about the answers!

Ask a question

Importing testcase retaining excel sheet style


nicolas jeanney (132) | asked Apr 30 '10, 6:14 a.m.
Hi,

If I import testcases in RQM from an Excel spreadsheet, the imported "precondition" and "postcondition" sections are visible only in the form of a plain text without any formatting like underlining or newline...

Does anyone know how to keep the formatting and layout from the excel fields during this import of testcase?

Thanks.

4 answers



permanent link
Michael Amirault (46) | answered May 17 '10, 4:40 p.m.
Hi,

If I import testcases in RQM from an Excel spreadsheet, the imported "precondition" and "postcondition" sections are visible only in the form of a plain text without any formatting like underlining or newline...

Does anyone know how to keep the formatting and layout from the excel fields during this import of testcase?

Thanks.


There is an existing work item that this is contained in. You can track it here.
http://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=23546

permanent link
Karen Steele (1.2k4139148) | answered May 18 '10, 8:45 a.m.
Hi,

If I import testcases in RQM from an Excel spreadsheet, the imported "precondition" and "postcondition" sections are visible only in the form of a plain text without any formatting like underlining or newline...

Does anyone know how to keep the formatting and layout from the excel fields during this import of testcase?

Thanks.


I was given a tooling tip that suggested you can place a pre() after the = on your line item which will retain the formatting in the imported text

e.g.

testcase.precondition=pre()L

permanent link
Andrew Trobec (49713144139) | answered Jun 07 '10, 8:54 a.m.


I was given a tooling tip that suggested you can place a pre() after the = on your line item which will retain the formatting in the imported text

e.g.

testcase.precondition=pre()L


I tried this, but it did not work... any other suggestions?

permanent link
bren buenaventura (1) | answered Jul 04 '12, 10:21 a.m.
you can try this:

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=Pre(L)

where "L" is the column of the pre-condition.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.