Re: [libreoffice-users] Calc Paste Special Defaults

At  Sat, 25 Jul 2015 15:55:42 -0700, Brian Baker 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.).  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).

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?"

-- 
Stephen R. Blevins
stephen.r.blevins@gmail.com


-- 
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