×
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

OLE limitation in SW drawings

OLE limitation in SW drawings

OLE limitation in SW drawings

(OP)
So, for years I've been using OLE objects and has always bugged me about the size limitations.  Especially Excel, you can only go so wide and tall before it truncates the file. This forces you into splitting the table, or making the text very small and increasing it's aspect ratio, but then just a simple reset size to mess it up.  I've requested this fix many times, but keeps coming back as a Microsoft problem....why can't they fix it?

Any comments or fixes out there?

John

RE: OLE limitation in SW drawings

You can't fix something in one program that is a caused by another. MS would have to fix it and I don't think they can since it's been here since SW introduced Excel tables into their software.

I found this http://support.microsoft.com/default.aspx?scid=kb;en-us;89630 not really sure if it expalins it in full, but SW KBA as some explaination.

Regards,

Scott Baugh, CSWP
3DVision Technologies

www.3dvisiontech.com
www.scottjbaugh.com
FAQ731-376
FAQ559-716 - SW Fora Users

RE: OLE limitation in SW drawings

(OP)
Yes, I know, but if large software corporation can put pressure on Microsoft to investigate these limitations, it's a win win situation.  If I tell MS they have a problem it's a different reaction then if the #1 Solid modeling company tells them they have a limitation.  That's why I've pushing thru SW.  Thanks, I'll check out the link.

John

RE: OLE limitation in SW drawings

(OP)
That link refer to filename length Scott.  Too bad, I've never really heard exactly why the OLE files act the way they do.  Some it has to do with Page setup, but it only partially controlling.

keep trying though.

John

RE: OLE limitation in SW drawings

I am running into the same problem right now.  Being Micro$oft compatible isn't always a good thing, I suppose.  It's unlikely that Micro$oft will ever improve that just to placate SolidWorks users because they represent a very small percentage of Micro$oft's total user base.

RE: OLE limitation in SW drawings

This has been a problem since SW started using Excel in SW. There is nothing more you can do for this issue and it will probably never get fixed. You will have simply make text smaller and shorten your columns, etc...

SW has a KBA on this issue and what you can do to help it, but there is no workaround to this issue directly and there never will be since the problem is outside of SW.

Regards,

Scott Baugh, CSWP
3DVision Technologies

www.3dvisiontech.com
www.scottjbaugh.com
FAQ731-376
FAQ559-716 - SW Fora Users

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