Wrap Text in Excel BOM

[sdb999]

I can't seem to get solidworks to maintain the cell format of "wrap text" when inserting the excel BOM into a drawing. Is there a tools/option check box I'm missing?
Thanks.

 

[fcsuper]

I doubt this is a tool/option setting. What method did you use to copy from one to the other? CTRL-V/C? Insert object?

Matt Lorono
CAD Engineer/ECN Analyst
Silicon Valley, CA
Lorono's SolidWorks Resources
Co-moderator of Solidworks Yahoo! Group
and Mechnical.Engineering Yahoo! Group

 

[CorBlimeyLimey]

sdb999,
Is there a reason you are still using the Excel BOM instead of the SW version?

Which version of SW and Excel?

 

[sdb999]

I created the excel file from one of the standard files supplied with S/W 08' sp0.0, Excel 03' sp2. I'm not using the SW boms because they will not do what I need. Although they format nicely. Figures. Thanks guys.

 

[CorBlimeyLimey]

If you expand upon what you need the SW BOM to do, someone may be able to provide a solution.

 

[sdb999]

I just didn't want this thread to spin off topic. Formating in excel doesn't pass into SolidWorks. I was attempting to do costing totals and the SW boms have several issues. If you include a $ the values are ignored. Summing a column works, but isn't dynamic nor can it be stored in a template. There were a few others but those were the big ones. It may be a service pack issue, but I can't change that at this point.
Thanks.

 

[fcsuper]

sdb999,

This may be an OLE issue, and not SolidWorks. With my version of Microsoft Office, borders do not copy over from Excel to Word.



Matt Lorono
CAD Engineer/ECN Analyst
Silicon Valley, CA
Lorono's SolidWorks Resources
Co-moderator of Solidworks Yahoo! Group
and Mechnical.Engineering Yahoo! Group

 

[ctopher]

Sorry to be nit-picky, but $$ shouldn't be on a drawing or BOM anyway.

Chris
SolidWorks/PDMWorks 08 2.0
AutoCAD 06/08
ctopher's home (updated 10-07-07)