Skip to main content
14-Alexandrite
September 11, 2023
Solved

create a List box in mathcad prime 9 from Excel

  • September 11, 2023
  • 1 reply
  • 1846 views

Hello,

 

I have a list of material size in an Excel column. Is it possible to create a list of these sizes in a dropdown list? In mathcad 15, there was a way to create this list manually using controls.

 

Thanks,

Sam

 

Best answer by Werner_E

@SFares wrote:

Hello,

 

I have a list of material size in an Excel column. Is it possible to create a list of these sizes in a dropdown list? In mathcad 15, there was a way to create this list manually using controls.

 

Thanks,

Sam

 


In real Mathcad you also could do it automatically by using some clever scripting (see for instance Richard's Extra Components -> https://community.ptc.com/t5/Mathcad/Extra-Components-and-Controls/m-p/450450?search-action-id=103996328440&search-result-uid=450450 )

But the dropdown lists in Prime are not capable enough to achieve something similar. PTC promised to implement scripting in the upcoming version of Prime. We have to wait to see if in that version its possible to achieve things which we were able to do real Mathcad since a long time.

 

@terryhendicott  once posted an elaborate method where he modified the xml representation of a Prime file to implement a large dropdown list. Guess this only makes sense if the list is not constantly changing.
I think it was this thread: https://community.ptc.com/t5/Mathcad/Excel-and-combobox/m-p/870154/highlight/true#M206266

or this one: https://community.ptc.com/t5/Mathcad/Populating-a-combo-box/m-p/841967/highlight/true#M204040

or this: https://community.ptc.com/t5/Mathcad/Combo-box-input-is-a-Vector/m-p/814201/highlight/true#M202199

 

 

 

1 reply

Werner_E25-Diamond IAnswer
25-Diamond I
September 11, 2023

@SFares wrote:

Hello,

 

I have a list of material size in an Excel column. Is it possible to create a list of these sizes in a dropdown list? In mathcad 15, there was a way to create this list manually using controls.

 

Thanks,

Sam

 


In real Mathcad you also could do it automatically by using some clever scripting (see for instance Richard's Extra Components -> https://community.ptc.com/t5/Mathcad/Extra-Components-and-Controls/m-p/450450?search-action-id=103996328440&search-result-uid=450450 )

But the dropdown lists in Prime are not capable enough to achieve something similar. PTC promised to implement scripting in the upcoming version of Prime. We have to wait to see if in that version its possible to achieve things which we were able to do real Mathcad since a long time.

 

@terryhendicott  once posted an elaborate method where he modified the xml representation of a Prime file to implement a large dropdown list. Guess this only makes sense if the list is not constantly changing.
I think it was this thread: https://community.ptc.com/t5/Mathcad/Excel-and-combobox/m-p/870154/highlight/true#M206266

or this one: https://community.ptc.com/t5/Mathcad/Populating-a-combo-box/m-p/841967/highlight/true#M204040

or this: https://community.ptc.com/t5/Mathcad/Combo-box-input-is-a-Vector/m-p/814201/highlight/true#M202199

 

 

 

SFares14-AlexandriteAuthor
14-Alexandrite
September 11, 2023

Thank you, Werner!

21-Topaz II
September 11, 2023

The sequence is involved. Post the excel file and describe what is needed in the combo box I will do  it for you.

Cheers

Terry