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: Excel Formatting in DXL
Topic Summary: Excel Formatting in DXL
Created On: 12-Sep-2008 18:13
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.
 12-Sep-2008 18:13
User is offline View Users Profile Print this message


Kyle Clements

Posts: 6
Joined: 12-Sep-2008

Is there a way to easily format an entire row in Excel? I want to change it from "General" format to "Text" format.


(Background info on problem: If you export to Excel, then "General" format automatically truncates trailing zeroes on numbers like 9.9010. Also, if you export to "Text" format, then large paragraphs appear as a series of pound (#) signs. So, I need a solution to this (which changing the row formating would work for me, but if there is a better solution, I'm open to it.)
Report this to a Moderator Report this to a Moderator
 15-Sep-2008 13:17
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

See my Excel functions here. There are functions to get a handle on a row and to set the formatting for a range of cells. You will just need to add a function for formatting the selected row. The ole.inc file in the zip file is needed for some of the things. There is also all the formatting options I added into it. You can choose to format that row/cells as a number if you like.

Hmm....maybe I'll change that and other similar functions to do the currently selected cells instead of a specific thing. I use globals because its faster for exports and imports.

Excel Functions

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

Edited: 15-Sep-2008 at 13:18 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 1 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 1 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.