×
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

Hide Excel border in a cell while printing SW drawing?

Hide Excel border in a cell while printing SW drawing?

Hide Excel border in a cell while printing SW drawing?

(OP)
I am trying to put a space between the Bill of Materials tables or columns as they are placed to the left. I must use the Bill of Materials Properties, Control “Split tables”. When I do this, my tables or columns are butted up against one another. Leaving no space between them.  Can SolidWorks Bill of Materials have space between the Bill of Materials Split tables and not print the excel border? I have tried hiding a column, set line style to none, and set line style to color white. Nothing seems to help. Any ideas?

Bradley

RE: Hide Excel border in a cell while printing SW drawing?

You could create a dummy column at right-most column of your BOM - but it would be there even if you don't split the BOM.
There should be some decent documentation in the HELP stuff to 'splain how to customize an excel file for a BOM.
I think this is as close to what you want as you're gonna get.


Read my profile & make me an offer... now!
tatejATusfilter.com

RE: Hide Excel border in a cell while printing SW drawing?

(OP)
TateJ
I tried the extra column, which worked well in my opinion. Management did not like the extra lines still showing up in the BOM.

Bradley

RE: Hide Excel border in a cell while printing SW drawing?

There is no way to hide those columns lines either.

I have one suggestion but I don't think you and definetly management won't like it. It's worth a laugh though... You could print it out, then break out the white out and cover up those pesky columns lines. j/k

I don'[t have a good suggestion at this point. When i find time I'll play with it if TheTick doesn't beat me too it.

Regards,

Scott Baugh, CSWP
3DVision Technologies
http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
When in doubt, always check the help

RE: Hide Excel border in a cell while printing SW drawing?

How 'bout this:
Make your drawing 2 sheets - sheet 1 = BOM.
You could even make sheet 1 8.5 x 11.


Read my profile & make me an offer... now!
tatejATusfilter.com

RE: Hide Excel border in a cell while printing SW drawing?

(OP)
TateJ,
We do put only the BOM on sheet 1 if there are enough items. The reason we want a space is to put a delta on the left side of the column to show revision change.

SBaugh,
Management did not think the white out idea was funny.  I did, got a great laugh out of the idea.

Bradley

RE: Hide Excel border in a cell while printing SW drawing?

I tried playing with Excel cell borders.  they don't carry through.

One possible solution:
Add a column at the end with just a space character in the header.  The column comes in one character wide, but can be manually narrowed, making the column appear as a double-line.  Maybe that will make your people happy.

Good and evil: wrap them up and disguise it as people.

RE: Hide Excel border in a cell while printing SW drawing?

From the archives of the "Lame-ideas-you're-just-gonna-hate" department:

Lame idea #17:
Manually draw thick lines between the stacks of your BOM.  At least it looks right.  You may want to disable the automatic BOM update.

Lame idea #438:
Export you BOM to Excel.  Make the BOM look the way you want with borders, etc.  Use page break to break the stacks.  Print to a PDF or bitmap file and paste the PDF or bitmap into you drawing.

Good and evil: wrap them up and disguise it as people.

RE: Hide Excel border in a cell while printing SW drawing?

(OP)
TheTick,
Thanks for the ideas.
We would rather keep things automatic then manual. Even at a small cost. Looks to me like we will not get the space to the left of our columns.

Bradley

RE: Hide Excel border in a cell while printing SW drawing?

I realise that this is an old thread, but I recently had a similar problem and seeing how this was never actually answered, I figured some of you might appreciate one. I actually found the answer in a much older post.

To hide borders in an inserted excel document you must fill the cells in as white (not "No Fill"). This removes the borders unless you chose to put a border in. I don't know why you have to do it this way, but it works.

RE: Hide Excel border in a cell while printing SW drawing?

(OP)
sloth4z,
Your right, it worked great when I insert an excel sheet into my drawing. However when inserting a Bill of Material the boarder still shows.
Thanks for the idea.

Bradley

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