![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: DOORS to Excel Export Topic Summary: Excel changes the case for Boolean Type values exported from DOORS Created On: 29-Mar-2007 16:45 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I have a problem of Excel converting the case for all Boolean Type values exported from DOORS. e.g. The value True is changed to TRUE. The .csv export does not have this problem, its only with the .xls export.
We have a vbscript that we need to run in Excel to change it back to the original case as it exists in the DOORS module. But, if it is possible to fix this problem in the DOORS to Excel export utility, we would prefer to try that approach. Any suggestions for updating the DOORS - EXCEL utility (or the code if this has been done before) will help. Thanks. |
|
![]() |
|
![]() |
|
Looking at the export script for Excel, it looks to me that Excel itself might be doing this. The export script simply gets the string value of each attribute thats being exported and assigns it to the proper cell. I know Excel often times does store booleans (since Excel does use them) as uppercase so this is what it is likely doing. What you could do is investigate modifying the export script to set the column that the booleans are going into as a Text only column.
------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com |
|
![]() |
|
![]() |
|
Potential solution for you is to add tic mark (ie "'") in file excel.dxl
to the following lines of code as shown: if (null dxl(c)) { s = "'" probeAttrShortDate_(o, attrName c) } If you need greater fidelity than this you could test attrName to see if it is boolean attribute before applying the tick mark. The above tick mark will convert the export to text and excel will not convert. |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
DOORS to Excel Export
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.