OLE Spreadsheet issue in Layout

OLE Spreadsheet issue in Layout

JHK19
Contributor Contributor
1,719 Views
8 Replies
Message 1 of 9

OLE Spreadsheet issue in Layout

JHK19
Contributor
Contributor

I have been using OLE spreadsheets in my layouts for over a year with any issues.  As of this morning I am losing everything but the text after opening the OLE and closing it again.  I have tried printing it anyway and it is printing exactly as displayed, only text.  I have never seen this before and I would appreciate any help I can get.  Thank you.

0 Likes
1,720 Views
8 Replies
Replies (8)
Message 2 of 9

s.borello
Advisor
Advisor

How are you attempting to plot? I was unable to re-create your issue... just plotted using DWG to PDF.pc3 and everything looks as it should. See attached.

Message 3 of 9

cadffm
Consultant
Consultant

@JHK19 

I am sorry to say: There is NOTHING more you can see,

empty modelspace and only 33 Objects in Paperspace, no viewports, only lines text and your embedded OLE.

Take the last *.bak or dwg from the backup.

 

Sebastian

0 Likes
Message 4 of 9

JHK19
Contributor
Contributor

Thank you for replying.  I have attached pdf files of what is happening after opening the spreadsheet and closing it again.  Select the spreadsheet - right click - OLE - Open.  Excel opens.  Close the spreadsheet and everything but the text disappears.

0 Likes
Message 5 of 9

cadffm
Consultant
Consultant

oh, s.borello understood you better than I No problems on my side too.

Please do these steps and saveas after ole->open->close and share the file here.

 

 

 

 

Sebastian

0 Likes
Message 6 of 9

JHK19
Contributor
Contributor

The problem is with the OLE spreadsheet in the layout.  Once opened and closed it loses everything but the text.

0 Likes
Message 7 of 9

cadffm
Consultant
Consultant

Not for us

Sebastian

0 Likes
Message 8 of 9

JHK19
Contributor
Contributor

Ok.  Thank you.  It must be a glitch in my system.  

0 Likes
Message 9 of 9

cadffm
Consultant
Consultant
I can not help more,
but i like to see your "Spreadsheet issue - after.dwg"

Sebastian

0 Likes