Inventor General Discussion

Inventor General Discussion

Reply
Valued Contributor
dlandisadaptek
Posts: 66
Registered: ‎06-30-2003
Message 1 of 7 (227 Views)

IV2009 Thread.xls sort order in the drop down box

227 Views, 6 Replies
05-01-2009 10:21 AM
Can anyone offer any insight into what determines the order the tap pitches are displayed in the drop down boxes. Thread.xls came default with the course threads above the fine threads in the spreadsheet list and when inserting them in Inventor, they showed up in the drop down box that order SO... I thought I'd organize them so the sizes we use most are shown first (ie, #10-32 instead of #10-24). After restarting Inventor to load the data again, everything seemed to be OK until recently... NOW the thread shown first in the chart is shown last in the drop down box. Any thoughts would be greatly appreciated.

I recently applied Service Pack 2... wondering if they fixed the drop down sort order to match the spreadsheet. Hoping this is the case so it doesn't continue changing randomly.

Thanks,
Dave
*Blair Stunder
Message 2 of 7 (227 Views)

Re: IV2009 Thread.xls sort order in the drop down box

05-01-2009 10:29 AM in reply to: dlandisadaptek

Sort order should come from the "thread.xls" file
and sheet tabs order


--
IV2010pro-suite
Dell 670 dual Xeon - 3.2
3gb memory,
SCSI320-15k rpm
XP-Pro, sp3
Quadro FX3400: Driver: 182.08
Direct3D
SpacePilot Rel V: 3.6.11 Dvr V: 6.6.4 Firmware 3.12
AVG 8.5


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Can
anyone offer any insight into what determines the order the tap pitches are
displayed in the drop down boxes. Thread.xls came default with the course
threads above the fine threads in the spreadsheet list and when inserting them
in Inventor, they showed up in the drop down box that order SO... I thought
I'd organize them so the sizes we use most are shown first (ie, #10-32 instead
of #10-24). After restarting Inventor to load the data again, everything
seemed to be OK until recently... NOW the thread shown first in the chart is
shown last in the drop down box. Any thoughts would be greatly appreciated. I
recently applied Service Pack 2... wondering if they fixed the drop down sort
order to match the spreadsheet. Hoping this is the case so it doesn't continue
changing randomly. Thanks, Dave
Active Contributor
delete3
Posts: 27
Registered: ‎12-05-2005
Message 3 of 7 (227 Views)

Re: IV2009 Thread.xls sort order in the drop down box

05-01-2009 10:41 AM in reply to: dlandisadaptek
A similar instance...
Q: When you ran 2008 out of the box, did the coarse pitch data appear in the dialog as you mention?
Q: Can you tell any differences in the xls file from 2008 to 2009?
Valued Contributor
dlandisadaptek
Posts: 66
Registered: ‎06-30-2003
Message 4 of 7 (227 Views)

Re: IV2009 Thread.xls sort order in the drop down box

05-01-2009 10:50 AM in reply to: dlandisadaptek
Thanks for the response.

I'm aware of the sort order and keeping the tabs inline. Problem I'm having is the sequence that the tapped holes are displayed in the drop down boxes when inserting them into an Inventor part. I've picked the size of hole (#10) and the tap pitch showing by default in the drop down box is #10-24. I want to change that to default as #10-32 so I don't have to pick the drop down box and select the tap pitch I want.

In IV10, I reorganized this list and it worked like a charm. But IV2009, while it worked for awhile has now seemed to revert. Still wondering if SP2 changed the sort order??? If so, I fixed it and I'm done, but if not wonder when it will re-sequence them again?

To answer Ksmedley, we jumped from 10 to 2009... ouch. But reorganizing the list by manually cutting/pasting the lines into the order we wanted to display them in worked great in IV10.

The attached .pdf shows the thread.xls spreadsheet below the insert thread feature dialog. You can see that #10-32 is the first line in the spreadsheet but the drop down displays #10-24 by default when #10 size is selected.

Thanks again.
Dave
*Blair Stunder
Message 5 of 7 (227 Views)

Re: IV2009 Thread.xls sort order in the drop down box

05-01-2009 11:04 AM in reply to: dlandisadaptek

I no longer have IV2009 on my system. A couple of
the SP's changed file opening/selection dialoge boxes. Possibly the
display/sort order for the thread.xls file was changed on SP1, and
then corrected back on SP2 as were a number of dialoge/selection
settings. 


--
IV2010pro-suite
Dell 670 dual Xeon - 3.2
3gb memory,
SCSI320-15k rpm
XP-Pro, sp3
Quadro FX3400: Driver: 182.08
Direct3D
SpacePilot Rel V: 3.6.11 Dvr V: 6.6.4 Firmware 3.12
AVG 8.5


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Thanks
for the response. I'm aware of the sort order and keeping the tabs inline.
Problem I'm having is the sequence that the tapped holes are displayed in the
drop down boxes when inserting them into an Inventor part. I've picked the
size of hole (#10) and the tap pitch showing by default in the drop down box
is #10-24. I want to change that to default as #10-32 so I don't have to pick
the drop down box and select the tap pitch I want. In IV10, I reorganized this
list and it worked like a charm. But IV2009, while it worked for awhile has
now seemed to revert. Still wondering if SP2 changed the sort order??? If so,
I fixed it and I'm done, but if not wonder when it will re-sequence them
again? To answer Ksmedley, we jumped from 10 to 2009... ouch. But reorganizing
the list by manually cutting/pasting the lines into the order we wanted to
display them in worked great in IV10. The attached .pdf shows the thread.xls
spreadsheet below the insert thread feature dialog. You can see that #10-32 is
the first line in the spreadsheet but the drop down displays #10-24 by default
when #10 size is selected. Thanks again. Dave
Valued Contributor
dlandisadaptek
Posts: 66
Registered: ‎06-30-2003
Message 6 of 7 (227 Views)

Re: IV2009 Thread.xls sort order in the drop down box

05-01-2009 11:17 AM in reply to: dlandisadaptek
That's what I'm hoping. It looks to be fine right now. It's a cause for concern though because when you get comfortable that it's sorting as it should and then it changes... that's not good. We scrapped a couple of parts out in the shop because we were comfortable and didn't notice this sort or display order "change".

Thanks again everyone for your input.
Dave
New Member
ihudson
Posts: 2
Registered: ‎07-11-2013
Message 7 of 7 (111 Views)

Re: IV2009 Thread.xls sort order in the drop down box

07-11-2013 12:23 PM in reply to: dlandisadaptek

I am using Inventor 2012 which may not necessarily help your situation, but I just had pretty much the same problem today. I edited the .xls document and no changes occured and I knew that we had edited the spreadsheet in past versions and had it work. I kept messing with stuff and searching and finally discovered that Inventor 2012 uses a new location for the Thread.xls spreadsheet so I was editing the wrong one. I found out that 2012 created a new spreadsheet but did not delete the old one so we were left with two spreadsheets that were nearly identical in all aspects but only one spreadsheet updated the correct information.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.