asked 2012-04-28 16:52:08 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Hello, I would like to paint a cell in calc with the same background as last time. So the background color button on the toolbar shows this color, but when I click on it, it doesn't paint the cell with that color, but opens the color dialog and you have to choose the same one. This is anoying and I was wondering if I did something wrong or if there is another easy way to do this.
This feature will be available in LibreOffice 3.6, thanks to Winfried Donkers who implemented it. At least it will be in Writer and Calc.
References:
Actually, there may be a lag, but (unlike Excel) the colour shown in the background colour button on the toolbar should change to that of the currently-selected cell, ie. it doesn't retain the colour from the last cell. Then the only option is to select from the colour dialogue. This seems to be a long-standing issue with OpenOffice/LibreOffice. See:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=3010 and
http://lists.freedesktop.org/archives/libreoffice-ux-advise/2012-February/000834.html
Further on in the above thread, there is an indication that it is already being addressed:
http://lists.freedesktop.org/archives/libreoffice-ux-advise/2012-February/000840.html
As a work-around, you can copy and paste-special, and choose to just paste the formatting, but this may include more than just colour. You can also select multiple, non-adjacent cells using Control-click (Command-click on a mac) and then apply the same background colour to all of them at the same time.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-04-28 16:52:08 +0200
Seen: 249 times
Last updated: Apr 30 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
