( 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. OK. All done in 1 simple step. Steps to reproduce: 1. .... 2. .... 3. .... Current behavior: Expected behavior: Operating System: Mac OS X Version: 4.2.1.1 release
Valid request, might be easy to accomplish: New (confirmed) Enhancement 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) [NinjaEdit]
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.
*** Bug 153171 has been marked as a duplicate of this bug. ***
Sahil Gautam committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/05a1217921b7be283c6750a35b90e4feda6e993e tdf#80390 Extend InsertCells Dialog to allow adding a set of Rows/Columns It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Sahil Gautam committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/695e8742da850bbb15c2e6d2b5d4c99a0daf4925 tdf#80390 Use local copy in anonymous function. It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
In release notes: https://wiki.documentfoundation.org/index.php?title=ReleaseNotes%2F24.8&type=revision&diff=752772&oldid=752771 Verified in: Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 1f15d097cace14ca6e44e7652f460aa3fa7bd150 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded