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?
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?
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?
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.
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?
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?
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?
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.
RE: Hide Excel border in a cell while printing SW drawing?
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.
RE: Hide Excel border in a cell while printing SW drawing?
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?
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?
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 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!