Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

IV2009 Thread.xls sort order in the drop down box

6 REPLIES 6
Reply
Message 1 of 7
dlandisadaptek
527 Views, 6 Replies

IV2009 Thread.xls sort order in the drop down box

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
6 REPLIES 6
Message 2 of 7
Anonymous
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
Message 3 of 7
delete3
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?
Message 4 of 7

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
Message 5 of 7
Anonymous
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
Message 6 of 7

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
Message 7 of 7
ihudson
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.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report