Hide Excel border in a cell while printing SW drawing?

[Standing]

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

 

[TateJ]

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[/u]​

 

[Standing]

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

 

[SBaugh]

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

 

[TateJ]

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[/u]​

 

[Standing]

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

 

[TheTick]

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.

 

[TheTick]

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.

 

[Standing]

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

 

[sloth4z]

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.

 

[Standing]

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