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: 255 Chars Limit in oleGet
Topic Summary: 255 Chars Limit in oleGet
Created On: 14-Feb-2007 13:21
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.
 14-Feb-2007 13:21
User is offline View Users Profile Print this message


Irfaan Jamal

Posts: 8
Joined: 11-Apr-2005

Hi,

I was importing an Excel sheet in which many cell values had more than 255 chars. When the excel was imported into DOORS, I could see the column values trimmed to 255 chars. Could anyone help me on this?

I am using the function

oleGet(objCell,"Value",sValue)

Regards
Irfaan

Report this to a Moderator Report this to a Moderator
 14-Feb-2007 14:29
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

I have also seen this but it was when we saved the Excel file to CSV or tab delimited, closed the file, reopened, and imported into DOORS. 

First try using the "Text" property instead of "Value".  This is a better idea anyway because then you're sure you're getting the displayed value of the cell.  For my scripts where I read stuff from Excel, thats the property I use.  Still use the "Value" property if you're writing to Excel though because "Text" is read only.

If that doesn't work, try using the function to copy the cell contents to the clipboard, and then put the contents of the clipboard into DOORS.  It'll be as rich text but you can trim that out if needed.  Here's my function. 



-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com

Edited: 14-Feb-2007 at 14:30 by David Pechacek
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.