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.
Stuart.
Have you tried using ITEM TYPES & Reports tables to read the data from the DGN file. and then use reports to add the table.
Ian
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
Ian Lapper said:Have you tried using ITEM TYPES & Reports tables to read the data from the DGN file. and then use reports to add the table.
No, but they wont what I want which is to keep it simple - drawing with shapes for buildings and a spreadsheet for areas. Paste one into the other. I don't need to over complicate this.
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!!