Bug 80390 - EDITING: No INSERT ROWS ... (dialog box that allows adding a set number of rows)
Summary: EDITING: No INSERT ROWS ... (dialog box that allows adding a set number of rows)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-UX Cell-Management
  Show dependency treegraph
Reported: 2014-06-23 11:56 UTC by icerabbit
Modified: 2019-06-13 14:50 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description icerabbit 2014-06-23 11:56:51 UTC
( Trying to file this as an enhancement request. )

Problem description: 

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:
1. ....
2. ....
3. ....

Current behavior:

Expected behavior:

Operating System: Mac OS X
Version: release
Comment 1 Joel Madero 2014-07-16 20:58:28 UTC
Valid request, might be easy to accomplish:

New (confirmed)
Medium - seems pretty useful for a # of our users who add rows to a spreadsheet (basic task)
Comment 2 Olivier DESCOUT 2014-11-11 08:31:52 UTC
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?
Comment 3 David Riggleman 2015-01-30 01:02:07 UTC
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.
Comment 4 Robinson Tryon (qubit) 2015-12-13 11:20:58 UTC Comment hidden (obsolete)
Comment 5 Thomas Lendo 2019-02-05 23:12:02 UTC
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.
Comment 6 Heiko Tietze 2019-02-06 19:40:19 UTC
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.