( Trying to file this as an enhancement request. )
I cannot find a dialog box or screen that allows me to add a custom number of rows in one step.
Current behavior: With right click or through the menu, I have to either add one row at a time or highlight the desired number of rows exactly and then do add row.
This is not a problem if you only need a handful of rows, but becomes tedious when you start to need 7, 12, 31 ... (to add weekdays, months,workdays)
Expected behavior / enhancement:
ADD ROWS... dialog (additional option, so there'd be old "ADD ROW" and new "ADD ROWS ...")
Enter number of rows to be added.
Select add above or add below.
All done in 1 simple step.
Steps to reproduce:
Operating System: Mac OS X
Version: 22.214.171.124 release
Valid request, might be easy to accomplish:
Medium - seems pretty useful for a # of our users who add rows to a spreadsheet (basic task)
Several rows can already be added at once in the spreadsheet if you first select several rows you want to insert (more precisely, select as many rows you want to insert).
For instance, select 5 rows, then click right and choose "Insert Rows Above". 5 rows are then inserted above the first one you selected (and the inserted rows become the ones selected).
That's the way it works for years in spreadsheet applications (including Microsoft Excel), and it allows inserting hundreds or thousands of rows at once if you want to. Doesn't this perfectly fit the requirement?
I was about ready to submit a similar enhancement request when I came accross this. While you are correct that the feature doesn't exist in Microsoft Office, it does exist in WPS Office (formerly Kingsoft Office) and was one of the features that I was pleasantly surprised by as it definitely had a positive impact on productivity for my context. You might take a look at how it's done in WPS Office as an example. I would love to see it implemented in LibreOffice if possible.
Migrating Whiteboard tags to Keywords: (needsDevEval)
I've nothing against this request in addition to the existing ways as it would be easier to set a number in a textfield instead of selecting 57 rows (for example) to insert this number of rows.
Let's do that. For simplicity I suggest to use the dialog Insert Cells and have a spinner next to Entire Row and Entire column defaulting to 1.
Could be an interesting easyhack.