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=21t=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+unsubscr...@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