Post

1 follower Follow
0
Avatar

List in cell formatting?

I am trying to use $listInCell to insert the links for Related Documents and Diagrams into a spreadsheet.  I have not been able to insert more than one link into the cell that corresponds to the requirement ID.  

When I use $list it creates a new row for the requirement if it has more than one Related Document.  Each row will include the unique link for the document.

When I use $listAcross it adds the links to unique columns.

When I use $listInCell it will only display one link for the requirement line.

Am I missing something? 

Lopes, Narlyn Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Narlyn,

It turns out that Excel only supports one hyperlink per cell. You can try this yourself in Excel to see what I mean - select Insert / Hyperlink and add a URL or file to a cell, then try to add another - instead of adding another, it updates what you had before.  This is exactly what CaseComplete is doing behind the scenes.

Your workarounds of using $listAcross or $list are about all I can think of at this point. Regarding using $list, you can avoid repeating the requirement in a new row by putting the $listRelatedDocuments on a separate line than the other requirement information. To do this, you would have to change $listRequirements to $repeatRequirements. Here's what it would look like, (where | represents a cell):

| $repeatRequirementsSortID |

| $ID | $Name | ...more properties here if desired... |

| ...as many empty cells that you want if you want to indent your related documents...| $listRelatedDocuments $Name |

| $endRepeatRequirements |

So the bulk of the requirement information will be in the first row, then following that row will be the related documents, each in their own row.

Let me know if that works for you or if you have any questions.

Doug

Doug Earl 0 votes
Comment actions Permalink