Is it possible in Gnumeric to paste-special only background colors w/o overwriting foregroudn colors, boldness, etc?

Posted by darenw on Super User See other posts from Super User or by darenw
Published on 2012-12-17T10:22:18Z Indexed on 2012/12/17 11:05 UTC
Read the original article Hit count: 203

Filed under:

copy-paste

|

background

|

gnumeric

I've written a huge complex spreadsheet in Gnumeric, with areas of different background and foreground colors, text and numbers in bold or various colors to indicate meanings. Certain cells ise a diagonal pattern combining the surrounding background color with black - this warns me not to alter those cells when I haven't had my morning coffee.

Big problem is changing just the background color of an area - to do so wipes out boldness, foreground colors and the diagonal-pattern cells. I use "Paste Special" and choose Format to copy-paste colors from one area to another, or make the pattern of bold/normal of several rows match one that's done right.

What I'd like "paste special - just the background colors (but preserve patterns and 2nd colors of backgrounds)" and "paste special - just the text style/fonts" but I've never encountered any such thing. Are the effects I want possible?

© Super User or respective owner

Related posts about copy-paste

Windows7 and Virtual PC guest copy/paste intermittent delay

as seen on Super User - Search for 'Super User'
I've been using Virtual PC for some time now and have not had any issues with copy and paste until I upgraded my host to Windows7 64-bit. After the upgrade sometimes when I copy and paste some text there is like a 15-20 second delay before it completes, this is very frustrating when I'm trying to… >>> More
Fmylife javascript copy-paste into link

as seen on Stack Overflow - Search for 'Stack Overflow'
Fmylife.com has a nifty feature that when you copy the text from a post, it actually copies a LINK (html) so that when you paste it into your email/facebook/instant messenger/twitter/whatever it automatically will link to the post, giving them more traffic and more page views and more ad revenue,… >>> More
Is copy paste programming bad ?

as seen on Programmers - Search for 'Programmers'
With plain google as well as google code search tools it is easy to find how to program using some resource or solve certain problems ( such as a Java class, or a ftp block in perl etc) and so developers are so tempted to just purely copy paste the code (in a way re-use) - is this an incompetency… >>> More
UITextField in UIAlertView doesn't respond to cut/copy/paste on second showing

as seen on Stack Overflow - Search for 'Stack Overflow'
I"m adding a UITextView to a UIAlertView with the following code: UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Enter Name Here" message:@"this gets covered!" delegate:self cancelButtonTitle:@"Dismiss" otherButtonTitles:@"OK!", nil]; UITextField *myTextField = [[UITextField alloc] initWithFrame:CGRectMake(12… >>> More
UITextField in UIAlertView doesn't respond to cut/copy/paste on second showing

as seen on Stack Overflow - Search for 'Stack Overflow'
Edit Reposting... I accidentally marked my previous question as "commuity wiki" and didn't realize that answers to wiki posts don't generate reputation. I"m adding a UITextView to a UIAlertView with the following code: UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Enter Name Here" message:@"this… >>> More

Related posts about background

Twitter Bootstrap styling conflicts with plug-ins like jqGrid and other third part libraries

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Issues:The concern is that the Twitter Bootstrap framework is that some of their css selectors are simply too generic and have incompatibility issues and conflicts with most third party plug-ins and css libraries, like jQuery-UI and jqGrid.My most pressing concern is only with the generic selector… >>> More
Android: Make application background behave like homescreen background

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a big background image for my views's background, which also can be tiled (it's repeadable). When switching from one Activity to another i want the background to behave like on the homescreen (the background moves only a bit, but the foreground moves one screen with). Is this possible… >>> More
SharePoint 2010 Center and Fixed Width of all content on page including the ribbon

as seen on Stack Overflow - Search for 'Stack Overflow'
All, I am trying to make the width of the sharepoint 2010 web site to be within a fixed width and centered across the screen. I would like for it to be 800px and centered. When i do this, it seems like it starts to work until the ribbion bar renters. Here is my attempt so far: body.v4/* _lcid="1033"… >>> More
Full Screen Video Tumblr

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a tumblr theme seen on http://www.kodilane.com and i am trying to make my Video Posts full screen. I have tried editing the code but i can only get the pictures to stretch. I have attached the template i have so far, if you can spot the changes that need to be done to make the video posts stretch… >>> More
UISearchBar clear background color or set background image [iphone sdk]

as seen on Stack Overflow - Search for 'Stack Overflow'
hi how can set image or clear background of search bar ? like note application ? >>> More