View previous topic :: View next topic |
Author |
Message |
tomot Blue Pill
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Feb 13, 2009 Posts: 4
|
Posted: Fri Feb 13, 2009 11:31 am Post subject: Pasting without formatting???!!! |
|
In a spreadsheet, for example, if I want to paste a number into the spreadsheet WITHOUT the source document formatting (as is the case 99.999% of the time), I seem to have to, in NeoOffice, do this:
1) SHIFT COMMAND V
2) Select Unformatted Text
3) Click OK
4) Click OK for subsequent Text Import Window
Four separate actions just to paste a number is too much work.
Q - Am I missing an easy way to do this?
If not, where's the suggestion box?
Thanks! |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
narf The Anomaly
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Jan 21, 2007 Posts: 1075
|
Posted: Fri Feb 13, 2009 11:53 am Post subject: |
|
Pasting formatted text is the default behavior in Neooffice's underlying OpenOffice.org code and OpenOffice.org does not provide any way to change the default.
Unfortunately, our very limited funding and developer resources limits the current scope of the NeoOffice project to keeping a native version of OpenOffice.org running on Mac OS X and significant changes to OpenOffice.org features is outside that scope.
You can file a feature request in the OpenOffice.org issue tracker to get it on the radar of the core OpenOffice.org developers and if they add this feature, the new behavior will get included in a future release of NeoOffice:
http://qa.openoffice.org/issue_handling/pre_submission.html
Note : our advice is to not mention NeoOffice as mentioning NeoOffice may cause OOo volunteers to accidentally close it without actually reviewing your bug.
--fran |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
yoxi Cipher
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Sep 07, 2004 Posts: 1799 Location: Dawlish, Devon
|
Posted: Sun Feb 15, 2009 11:56 am Post subject: |
|
This macro:
Code: | sub UnformattedCalc
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 |
will perform the whole thing for you - just assign it to a key combo and then you'll get the function in one keystroke. Not that this version is specifically for Calc.
- padmavyuha |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
tomot Blue Pill
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Feb 13, 2009 Posts: 4
|
Posted: Fri Feb 20, 2009 9:26 pm Post subject: |
|
Thanks you guys! I'm going to file a suggestion in OpenOffice, and give that macro a try!! |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
tomot Blue Pill
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Feb 13, 2009 Posts: 4
|
Posted: Fri Feb 20, 2009 9:32 pm Post subject: |
|
Er, where I find instructions on how to save your macro code in N-O? ![Smile](modules/Forums/images/smiles/icon_smile.gif) |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
narf The Anomaly
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Jan 21, 2007 Posts: 1075
|
Posted: Fri Feb 20, 2009 11:15 pm Post subject: |
|
Take a look at this NeoWiki article on Using Macros.
Hopefully this will help give you a start. Let us know if you have any questions.
--fran |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
tomot Blue Pill
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Feb 13, 2009 Posts: 4
|
Posted: Sun Feb 22, 2009 1:06 pm Post subject: Unformatted pasting... |
|
Wow, that was quite a setup procedure. It works great! In Calc. I set it up to work in all NeoOffice modules (eg Write). However, in Write, it goes straight to the dialogue that asks you, Unformatted or Formatted Text. Well, good enough. Thanks again. |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
yoxi Cipher
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Sep 07, 2004 Posts: 1799 Location: Dawlish, Devon
|
Posted: Sun Feb 22, 2009 2:03 pm Post subject: |
|
That's why I said that version was specifically for Calc . If you want to make one for Writer, do what I did to generate the macro - turn on Macro Record, then do the Paste Special thing (in a Writer doc) manually, then Stop Recording and save the macro as prompted, giving it a useful name - then assign that macro to a key combo. The two modules need different macros because there's an extra step in Calc's Paste Special as compared to Writer's.
- padmavyuha |
|
Back to top |
|
![](modules/Forums/templates/subSilver/images/spacer.gif) |
|