Bug 153171 - suggestion: add option to add x number of rows/columns in the menu
Summary: suggestion: add option to add x number of rows/columns in the menu
Status: RESOLVED DUPLICATE of bug 80390
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Blocks: Cell-Add-Delete
  Show dependency treegraph
Reported: 2023-01-23 21:41 UTC by maximuszen
Modified: 2023-12-15 12:52 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description maximuszen 2023-01-23 21:41:21 UTC
the option to add single lines is also available in the context menu on the row label
Comment 1 Stéphane Guillou (stragu) 2023-01-24 09:17:59 UTC
As a workaround, you can select several columns or rows so it inserts the same number of columns or rows.
See: https://help.libreoffice.org/7.4/en-US/text/scalc/01/04040000.html

UX, do you think a solution via (context) menu is doable and desirable? It could make the feature more accessible and discoverable. Should be implemented along with a fix for bug 141315.
I couldn't find a duplicate.
Comment 2 Rafael Lima 2023-01-24 18:29:31 UTC
I personally never felt the need for such a feature. But maybe some users want to insert exactly f.i. 125 lines above/below and then this request might be valid. In summary, this feature would be interesting when the number of rows to be created is large enough, so that the workaround in Comment #1 is impractical.

The main problem is how/where to add this new command? Currently the poppup menu is very crowded with 15 commands.

Should we the 16th? It could be called "Insert Rows..." and would open a simple dialog allowing the user to insert the number of rows to insert and select whether they'll be inserted "Above" or "Below".

If we implement this, then we should create the same command for columns as well.
Comment 3 Heiko Tietze 2023-01-25 07:35:50 UTC
I don't buy the use case to insert exactly 125 rows. What scenario requires this and why should we bother not only development but also users with another function? Question to OP/Maximums...
Comment 4 maximuszen 2023-01-25 16:52:08 UTC
Thank you, stragu.

That workaround is great. It is a hidden gem!

Inserting 10, 20, or 30 rows is cumbersome for a lazy typist.

I didn't think of it but I could have just copied and pasted empty rows/columns.

I don't use the product so much. When Excel came out inserting multiple columns/rows was an option.

Thank you for all your attention. I'm sure you have many real "bugs" to address.

Thank you for a great alternative produce.
Comment 5 QA Administrators 2023-01-26 03:24:24 UTC Comment hidden (obsolete)
Comment 6 Heiko Tietze 2023-01-26 08:09:54 UTC
Another option is to utilize the Edit > "Repeat" function (shift+ctrl+V), which just repeats the last command.

Resolving WF the request to show a dialog how many rows/cols to insert.
Comment 7 maximuszen 2023-01-27 15:20:14 UTC
Yes, I didn't know about that. That's useful.
Comment 8 Stéphane Guillou (stragu) 2023-12-15 12:52:04 UTC
Let's mark as a duplicate of bug 80390, as it's essentially the same ask.

*** This bug has been marked as a duplicate of bug 80390 ***