Clearance.xls Rounding Issue

[lriemer]

Hello, I'm attempting to customize the clearance.xls to include loose, press, and nominal values for standard dowels. Everything is going well, except that any values I try to pull from the clearance.xls spreadsheet are rounded to 3 places. This rounding obscures the small differences between the fits, so I'd really like to retain 4 decimal places. Is there any way to get hole features pulled from the spreadsheet to use 4 decimals? Thank you.

[rjay75]

In your spreadsheet how is the cell formatted? Is it formatted to show in 4 decimal places?

[lriemer]

I considered that it might be my formatting, so I did some testing. The cells I added are formatted as "Numbers" with 6 decimal places. The default Inventor ones are 3-4 place decimals formatted as "General" cells. Both produce the same behavior. For example, the default #4 SHCS clearance value is .1285 in excel. When placed in Inventor, the hole measures and dimensions with "All decimals" as .129. I was hoping there might be a way to override this rounding somewhere.

[philippe.leefsma · Accepted solution]

Hi Iriemer,

This sounds like a product question, are you using any API in your workflow? If you do, please provide some code sample that can help to reproduce the behavior. Otherwise, please post your question to the Inventor General section of the forum.

Thank you,

Philippe.

[lriemer]

In case anyone else runs into this, it did end up being an issue with the application options rather than the .xls configuration. Changing my Modeling Dimension Display to more than 3 decimal places resolved the issue.