Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Pasting without formatting???!!!
Pasting without formatting???!!!
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
tomot
Blue Pill


Joined: Feb 13, 2009
Posts: 4

PostPosted: 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
narf
The Anomaly


Joined: Jan 21, 2007
Posts: 1075

PostPosted: 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
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: 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
tomot
Blue Pill


Joined: Feb 13, 2009
Posts: 4

PostPosted: 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
tomot
Blue Pill


Joined: Feb 13, 2009
Posts: 4

PostPosted: 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
Back to top
narf
The Anomaly


Joined: Jan 21, 2007
Posts: 1075

PostPosted: 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
tomot
Blue Pill


Joined: Feb 13, 2009
Posts: 4

PostPosted: 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
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: Sun Feb 22, 2009 2:03 pm    Post subject:

That's why I said that version was specifically for Calc Smile. 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
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.