First time here? Check out the FAQ!
asked 2012-09-07 09:03:31 +0200DeepDreamer
I cannot find shortkey for FormatPaintBrush action. It seems that there is no such shortkey. But it is so useful for formating spreadsheets.
I suppose it should be implemented by developers, using Ctrl+Shift+C combination for getting format and Ctrl+Shift+V for applying copied format to active cells
answered 2012-09-09 12:17:59 +0200tohuwawohu
There are already two ways to apply Format Paintbrush using the keyboard:
use "Paste Special": CTRL+C to copy, select the target cells, hit CTRL+SHIFT+V, and deselect every option in the "Selection" area instead of "Formats";
just assign Format Paintbrush to your desired keyboard shortcut. Select Menu "Tools" -> "Customize" -> "Keyboard", select "Edit" from the "Functions" list at bottom left, select "Format Paintbrush" from the next listbox, select a shortcut from the list above (for example CTRL+P), hit "Modify". After this, you can proceed like this:
IMHO the key combination CTRL+SHIFT+V isn't suited as you've proposed, since this triggers the "Paste Special" feature that's very important for many users.
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-09-07 09:03:31 +0200
Seen: 54 times
Last updated: Sep 09 '12