row height in BOM table

[nedeljko.sovljanski]

Hi everyone,

Does somebody know how to calculate row height in BOM based on font style, font size, gaps,... ?

[cadman777]

You may find a quicker answer in the Customization forum.

They do a lot with BOMs using iLogic and VBA/VB.Net, so they would know all about that.

[mcgyvr]

What specifically are you trying to do?

Inventor basically handles row height in a parts list based on the text style you use and then has a "row gap" which gives top/bottom padding to each cell. 

If you use a 2mm font and set row gap to 1 mm you will have a 4mm (2+1+1) tall row. 

[nedeljko.sovljanski]

Hi,

I am trying to draw thicker border around some rows in BOM. I will check BOM properties. Thanks.

[A.Acheson]

I would think this work is best done in excel directly to the parts list /BOM export, The part list table has limited options for modifying the table borders like you would do in excel. You will likely be able to find a VBA macro to highlight a range based on range contents. 

Have you a picture of where you wan the finished table to be and what it looks like? 

[nedeljko.sovljanski]

HI @A.Acheson , but after that I need to paste excel table in drawing, and I something changed, table will not be updated.

[A.Acheson]

Here is a few post on ideas about having this functionality implemented. 

https://forums.autodesk.com/t5/inventor-ideas/add-parts-list-border-line-format-settings/idi-p/79090...

With marginal workarounds. 

https://forums.autodesk.com/t5/inventor-forum/parts-list-on-drawing-line-weight-settings/td-p/105658...

[nedeljko.sovljanski · Accepted solution]

Depending on font name, row gap and text in part list cells, heights can vary and easiest way is: let Inventor to calculate and we will just read this values. The values could be found at:

DrawingDocument.Sheets(_number_).PartLists(_number_).PartListRows(_desiredRowNumber_).Height