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
Regards
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?
stuartw said:I tried 'Load key in mdl load olecntr; olecntr pastemethod' as noted above which didn't work.
Yes, because no key-in "load key..." exists:
Regards,
Jan
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point
Jan Ĺ legr said:I tried 'Load key in mdl load olecntr; olecntr pastemethod' as noted above which didn't work. Yes, because no key-in "load key..." exists:
I tried 'Load key in mdl load olecntr; olecntr pastemethod' as noted above which didn't work.
You need to let Marc know about that one as that's were it cam from :-)
Looks like some confusion due to a typo on Marcs reply the key-in is "mdl load olecntr; olecntr pastemethod" see image below:
Afterwards you should see the following in the message center:
Answer Verified By: Marc Thomas
did you try paste special like v8i
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
original post corrected for future reference.
Marc Thomas said:original post corrected
It continues to read 'Load key in mdl load olecntr; olecntr pastemethod'
There are two statements; the first loads the OLECNTR app, the second invokes an OLECNTR app command:
mdl load OLECNTR
olecntr pastemethod
As usual with a MicroStation key-in, two statements can be concatenated on one line using a semi-colon to separate them:
mdl load OLECNTR;olecntr pastemethod
It's the 'Load key in' preamble which should be excluded.
Regards, Jon Summers LA Solutions
That's weird, I definitely corrected the post, maybe the edit failed to write...