[libreoffice-users] Re: Calc Paste Special Defaults

Am 26.07.2015 um 23:17 schrieb Stephen R. Blevins:
> 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).

You might be interested in my macro solution which takes care of a
general setting, the current region of your list range, merged cells and
formulas from the row above.

[Calc, Python] Expand/shrink list ranges
> https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=2350

As a matter of course, all this fiddling with spreadsheet is not by far
as convenient as a database with input forms.


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