Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Rich Text from Excel
Topic Summary:
Created On: 22-Jan-2007 19:12
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Reik Schroeder, on Wednesday, January 24, 2007 2:44 PM

Answer:
Hi David,

you could use Copy and Paste to get the RTF ...

so in Excel it is the Copy Method of Range-Object....
... and in Doors it is
RTF_string__ richClip()


Greetings
Reik
 22-Jan-2007 19:12
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Is there any way in OLE to get rich text out of a cell in Excel into a rich text dialog box? 

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 23-Jan-2007 12:21
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Answer Answer
Hi David,

you could use Copy and Paste to get the RTF ...

so in Excel it is the Copy Method of Range-Object....
... and in Doors it is
RTF_string__ richClip()


Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 24-Jan-2007 14:44
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Thanks.  Appreciate it. 

Only issue is the possibility of truncation from the copy and paste.  I don't know if others have this issue but we're still using Office 2000 and do.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 4-Jun-2008 17:14
User is offline View Users Profile Print this message


Bastian Könings

Posts: 5
Joined: 7-Aug-2007

This unfortunately works only for Cells having less than 1024 Characters.
Does anyone know a different method to do this?
Report this to a Moderator Report this to a Moderator
 4-Jun-2008 18:16
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

I haven't yet. I just check for truncations in my import tool (is the rich text value I copied into doors the same length as non-RTF value in excel). If they aren't the same, the user had made a prior decision about what to do. Either use the non-RTF value, use the truncated RTF value, or halt the import.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 2 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.