It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,952

question asked: Jun 07 '10, 8:37 a.m.
question was seen: 4,134 times
last updated: Jun 07 '10, 8:37 a.m.

Related questions

RQMExcelImporter: CR LF not being recognised during import

0
Andrew Trobec (497●13●144●139) | asked Jun 07 '10, 8:37 a.m.
Hello,

I'm trying to import text from an excel sheet into the "Test Case Design" tab for a Test Case, but for some reason the CR LF tag is not being recognised, and so all text is being put onto a single line.

For example, when I import one of the samples:

Start furnace
Wait until it hits 10000 degrees
Toss in hammer
Send in coyote to check on hammer
Stop and cool down furnace
Ensure hammer looks good (coyote looks a little crispy is acceptable)

the result is:

Start furnace Wait until it hits 10000 degrees Toss in hammer Send in coyote to check on hammer Stop and cool down furnace Ensure hammer looks good (coyote looks a little crispy is acceptable)

When analysing the XML file in notepad++, I see:

Start furnace
Wait until it hits 10000 degrees
Toss in hammer
Send in coyote to check on hammer
Stop and cool down furnace
Ensure hammer looks good (coyote looks a little crispy is acceptable)

Has anybody else experienced this problem or does anybody know how to resolve?

Thank you and best regards,

Andrew

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Andrew Trobec (497●13●144●139) | answered Jun 08 '10, 8:29 a.m.
Hello again,

If anybody is interested, I was able to find a solution:

1. Run the following script to replace all LF with <br> 

Sub replaceLf()

Cells.Replace what:=vbLf, replacement:="<br>"

End Sub

2. Import as usual

Please note that this does not preserve advanced formatting like coloured, bold, italic, and underlined text.

Regards,

Andrew

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.