![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Exporting to Excel, losing the heading numbers Topic Summary: Created On: 21-Sep-2004 21:29 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hello,
I've been having problems exporting a module to Excel. The heading numbers do not export. To get around this, I export the module to a .csv, then open and SAVE AS xls. I am using Object Heading & Text as the main column. I have tried all others as the main column, but have not had any luck. What am I missing? Thanks, Patrick |
|
![]() |
|
![]() |
|
I guess that's what I'm asking...Anyone know how to do this?
quote: |
|
![]() |
|
![]() |
|
You can add a layout dxl column with following code
if(isOutline(obj)) display number obj |
|
![]() |
|
![]() |
|
You could realistically create a Layout that simulates the Main column, display that, then export to Excel.
string Text = richTextWithOle(obj."Object Text") string Head = richText(obj."Object Heading") string Para = number(obj) Buffer Results = create() if (!null Head or null Text) { Results += Para // DOORS thinks this is a heading object Results += "\n" } if (!null Head) { Results += Head // non null Heading Results += "\n" } Results += Text display (stringOf(Results)) delete (Results) - Louie Edited: 23-Sep-2004 at 15:23 by Louie Landale |
|
![]() |
|
![]() |
|
You could use the solution offered by Galactic Solutions . It has a very nice interface where you have the choice to include or surpress the heading numbers, amongst a bunch of other features.
------------------------- Pieter de Waard www.nhindustries.com |
|
![]() |
|
![]() |
|
You can save a view with the heading number in one column (only where there is heading text) as below
string s = obj."Object Heading" if (s != "") { string temp = number(obj) display temp } Also have an Object Heading column Also have an Object Text column No main column Export to Excel and format as desired with headings and numbers in bold, if you don't wrap the heading text it will flow across all visible excel columns so the actual heading column can be narrow giving an apparant indent for the object text. If you have any intention of re-importing to DOORS, then heading and text need to be in separate columns anyway. Recording an Excel macro to do the formatting makes life easy for re-exporting. There are very possibly as many solutions to this one as there are readers of it :-) ------------------------- Hazel Woodcock |
|
![]() |
|
![]() |
|
Modify excel.dxl
change the function headingLong to the following (Ugly but works) will handle when you include Heading and text: string headingLong(Object o) { string sss = o.AHeading string ttt = o.ALongText if (null o.AHeading) { return o.ALongText "" } if (sss != "" && ttt != "") then return number o " " o.AHeading "\r" o.ALongText "" if (sss != "") then return number o " " o.AHeading "\r" else return o.ALongText "" } and original line 228 for the choice Heading only change line 228 (that is line 228 before doing the above change) if (doMain == mainHeading) s = o.AHeading "" to if (doMain == mainHeading) { string sss2 = o.AHeading if (sss2 != "") s = number o " " sss2 "" else s = "" } Works for me. ------------------------- Kristian Bøe Extenda AB Kristian.Boe@extenda.se |
|
![]() |
|
![]() |
|
When exporting, I also select "Object heading and text" when prompted, but still no heading numbers.
I have an imported Word document that has numbers in the headings, but when exporting it to Excel (because I've added more columns and want to keep them seperate) there are no heading numbers, just heading titles. In the DOORS module, I'll insert the "Object Number" column then export the module to Excel. Unfortunately, this means the heading numbers are in a different column than the heading text, but at least I now have the heading numbers. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.