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: [email protected] 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
