On Tue, 09 Oct 2007 19:24:49 -0400, Datatude wrote:
>Jonas Svensson wrote:
>> One thing I find very annoying in both MS Office/Word and
>> OpenOffice.org is that paste always keeps formatting when pasting
>> from another program. Is there a way to reverse the paste setting
>> so that regular paste removes formatting and only special paste
>> keeps formatting?
>>
>
>I just played with this for a few minutes. I use NeoOffice (an
>OpenOffice branch for Macs) but I feel reasonably sure this would work
>the same way in OpenOffice. If it will work for you to simply reassign
>the Paste keyboard shortcut (but the Edit/Paste menu choice would not
>change its behavior), you can do this:
>
>1. Copy some formatted text in to your clipboard
>
>2. In Writer, choose Tools/Macros/Record.
>
>3. Using the menu (rather than keyboard shortcut) choose Edit/Paste
>Special/Unformatted text.
>
>4. Click the Stop Recording Button and save the macro with a name such
>as MyPaste.
>
>5. Now assign the Ctrl-V (for Win/Lin) or Cmd-V shortcut to your MyPaste
>macro in Tools/Customize, the Keyboard pane. (If you need details, write
>back after giving it a try)
>
>Now my Cmd-V shortcut pastes unformatted text. If I want to paste
>formatted I press Shift-Cmd-V to open up the Paste Special dialog, or
>choose Edit/Paste Special.
>
>Does that help?
>
>kazar
I am trying to get this to work:
using Win98se, OO.o 2.3(680m5 9221), Opera 9.24:
Copy from cells from bank statement via Opera 9.24 won't auto-paste:
I want to copy rows of 'cells' of a bank statement from Opera & paste
to Calc without the need to confirm the format every time .
When I try to paste to a calc file in OO.o 2.3, a window pops up
asking if I want "Text Import" as "unicode".
I ALWAYS want this.
If I select to 'paste special' I am then asked if I want 'unformatted
text' (only choice). If Ok the same "Text Import" as "unicode" pops
up.....
How do I tell OO.o to DEFAULT to this without the pop-up window ALWAYS
showing??
I always want to default to unformatted text from any other program.
(This was also in OO.o 2.2)
I recorded a macro to do this but I can't get it to 'ENTER' the final
"ENTER' ( I have to type <ENTER> manually)
this is the recorded code:
REM ***** BASIC *****
sub PasteUnformatted
rem
----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem
----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem
----------------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Format"
args1(0).Value = 1
dispatcher.executeDispatch(document, ".uno:PasteSpecial", "", 0,
args1())
end sub
Thanks for any help, Greg
Greg Agent 1.93/32.576 Opera9.24 OOo2.3 Eudora(NG7)6.2.5.6
news.readfreenews.net & news.gmane.org Win98se
for sale: Apple//,Auto Parts/Equip/Manuals:
http://geardoc36.hostingisfree.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
