![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
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.) |
|
![]() |
|
![]() |
|
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 |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Excel Formatting in DXL
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.