At 17:17 26/07/2015 -0400, Stephen R. Blevins wrote:
At Sat, 25 Jul 2015 15:55:42 -0700, Brian Ba[r]ker wrote:
At 17:33 25/07/2015 -0400, Stephen R. Blevins wrote:
In Calc, the Paste Special Selection options default to Text,
Numbers, Date & Time. Each time I edit a spreadsheet afresh, I
have to remember to change this to Paste All.
Why would you use Paste Special... if you wanted to paste all?
Well, I suppose you might want to select something under Options,
Operations, or Shift cells - but not that often, surely? Otherwise,
why not use ordinary Paste (Edit | Paste, right-click | Paste, or
Ctrl+V) instead?
My usual practice to update the numerical data on my spreadsheets is
to copy a "template" row (properly formatted) and use Paste Special
(with Shift Cells set to "Down") to insert it into a formula-ranged
matrix (such as SUM, or AVG, etc.).
That's exactly the sort of exceptional case I described, of course.
Doing so this way causes the formula-derived data to be updated
automatically. It is a matter of convenience. It is more convenient
to have these Paste Special options automatically default to my
preferred practice. It also ensures that embedded formulas get
copied, as well (and my "template" rows have them).
But that's not the only way to do this.
Therefore, I humbly request, yet again, "How can I customize these
Paste Special defaults without having to edit and recompile the Calc
source code, or can I?"
If I'd known one, I would have offered it, of course! So my answer
(er, yet again?) is that sorry: I don't know of any. Now that I know
your real problem, here's the solution:
o Select the relevant row - or even just a range of cells.
o Drag the selection to its required new location. (You need to drag
the cells, not the row headers.)
o Hold down the Alt key as you release the mouse to drop the copied
material. Note that this will cut your original material instead of
copying it and may (depending on exactly where the target cells are
in relation to the source cells) shift other material around. If, as
I imagine, you will want to retain your template row in its original
position, hold down Ctrl+Alt instead as you release the mouse.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.