I have just noticed Paste from Clipboard (Ctrl+V) doesn't work the same in CE as it does in SS4. I have a spreadsheet of floor areas that I select in excel and Ctrl+C. If I paste into a drawing sheet opened in SS4 I get:
but in CEU14 I get
Why does it not paste in the same? WE use this a lot so for the program to not work the same as SS4 is a problem and another reason to stay with v8i.
Hello Stuart,
This is embedded in the Place Table feature so you have more control over your Excel content:
For more details see help topic Home > Drawing Composition > Scheduling and Reporting > Tables > Place Table
Marc
Marc. Thanks for coming back to me but that doesn't work as it wants to import the whole sheet. I just want a small selection from the spreadsheet.
I did try what you suggested with tables but it spent 2 mins 'generating table' which I cancelled out of in the end.
How do I import (paste?) a small selection from a spreadsheet that keeps all the formatting of the original?
More to the point why has this changed from the way SS4 does it?
You're expecting this?
If so which options do you pick?
I am expecting this but don't get that one! If I paste to the drawing I get:
How do you get that dialog?
key-in
'mdl load olecntr; olecntr pastemethod'
'Load key in mdl load olecntr; olecntr pastemethod' previous incorrect text with apostrophe in the wrong place...
These two command load up the OLE paste methods, this is being fixed for U15.
Oh, and you can add olecntr to the list defined by MS_DGNAPPS to save having to run the key in
For reference this is covered by Defect 1090927
...and as Ian says, if you are working with areas there is lots you can do with Item Types to make this all easier
Marc. I have to say that this is just bull. Why doesn't CE work as V8i without going through hoops to get the same result. You (Bentley) are forcing us to use a program that it not as good as it's predecessor. Why? Why can't you just get the basis right?
I am trying to get others in our office to use CE but it's an uphill struggle because they just don't like it. It's hard work to use!!
Marc Thomas said:'Load key in mdl load olecntr; olecntr pastemethod'
That doesn't work for me? Why has it taken 14 releases for this to be found and more to the point why doesn't it work as v8i?
stuartw said:That doesn't work for me?
Do you see a confirming message OLECNTR loaded?
What doesn't work? Can you paste your spreadsheet into a DGN model?
stuartw said:Why has it taken 14 releases for this to be found?
It hasn't taken 14 releases. It used to work but was broken in Update 12 or thereabouts. Search this Forum for more detail.
Regards, Jon Summers LA Solutions
Jon Summers said:Do you see a confirming message OLECNTR loaded?
The key in doesn't work - "unknown keyin or command"