Description: When selecting a large number of columns or rows by mouse "dragging", the moment all populated cells are off the monitor the scrolling speed rapidly accelerates. If the intention is to add say 372 rows/columns then generally, the display overshoots the target location and it's just as tedious trying to reverse the selection. It would be far more productive if the facility existed to simply select one header location and have the option to insert 372 rows/columns from this location. I have been apprised of the various alternatives which are quite clumsy compared with the simple procedure - please insert x rows here, See AskLibre "How to insert a variable number of columns or rows" Motivation: Libre Calc Charts define absolute addresses for the data range. If that range "grows" by simply "dragging" the formulae for a few more rows then the chart reference gets left behind - way behind if a couple of hundred new rows become populated. If the range is originally defined with two "overflow" rows then extended by inserting more rows into the "overflow" margin then the chart range is automatically adjusted to reflect the new end points. Steps to Reproduce: Enhancement Actual Results: No Procedure - yet Expected Results: Enhancement: Doesn't exist yet Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
https://ask.libreoffice.org/t/how-to-insert-a-variable-number-of-columns-or-rows/69928 By the way, Writer Tables has an option to insert an x numbers of rows.