×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel BOM inserts with wrong font

Excel BOM inserts with wrong font

Excel BOM inserts with wrong font

(OP)
I'm trying to set up the new drawing templates where I work, in SW 2007 SP 4.0. I'm running into 2 problems.

I can't link an excel BOM to a blank view.

When I insert the BOM the font in the cells is Century Gothic size 12.  The excel BOM and table and the annotation font for the sheet are both set to Arial, size 8.

What option am I missing?

RE: Excel BOM inserts with wrong font

You're missing the fact that Excel BOMs are not actively supported.  Is there a particular reason you are attached to the old style BOM?

I'm pretty sure Excel BOMs retain the font from their Excel templates and don't take on font from drawing properties.

If you use a new table-style BOM, its font is controlled by the drawing document options.

RE: Excel BOM inserts with wrong font

"I can't link an excel BOM to a blank view."

Neither can anybody else! A BOM (Excel or SW style) cannot be linked to an empty view.

cheers

RE: Excel BOM inserts with wrong font

(OP)
Well, that solves the blank view BOM problem.

TheTick, I made a new BOM with the fields we want and when I saved the excel file I saved it as Arial size 6.  I may just go to the Solidworks BOM, since that appears to update fine.

Is it possible to rotate a table?  I'm trying to get a revision block (excel or SW) to go to 90 deg.

RE: Excel BOM inserts with wrong font

(OP)
I found my mistake.  There is the check box for "Use the document note font when creating the table".  Once I unchecked that everything worked as set up.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources