Summary: | Insert multiple columns/rows at once with non-contiguous selection | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | J22Gim |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | erack, heiko.tietze, karos.oscar, peter.cooke.pcdc, stephane.guillou |
Priority: | medium | ||
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=80390 https://bugs.documentfoundation.org/show_bug.cgi?id=39936 https://bugs.documentfoundation.org/show_bug.cgi?id=46930 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108364 | ||
Attachments: | case explained graphically |
Description
J22Gim
2023-11-27 12:17:55 UTC
Created attachment 191061 [details]
case explained graphically
(In reply to J22Gim from comment #0) > Description: > It would be good to be able to insert several non-contiguous columns at once. > It is currently not possible, what is the specific reason for this? > > Steps to Reproduce: > 1. Create a spreadsheet with columns A, B, C, D. Populate a few rows of each > of those columns (see attachment). > 2. Objective: insert blank columns in B and D, in one step. > 3. Select columns B and C > 4. Go to Sheet -> Insert Columns > > Actual Results: > The options are greyed out; It is not possible to insert columns when more > than one column is selected. > > Expected Results: > Blank columns are inserted at B and C, therefore now I have columns A, B, C, > D, E, F, where B and D are empty. > > I am not sure why this option is not available... I guess it might be > related to potential problems on how to approach this (i.e. if a column > changes its location because another one was inserted before, then how to > deal with the next insertion?). I suppose a sensible way would be to do it > sequentially (eg. starting from left to right). > > > Reproducible: Always > > > User Profile Reset: No > > Additional Info: > Version: 7.6.3.2 (X86_64) / LibreOffice Community > Build ID: 60(Build:2) > CPU threads: 24; OS: Linux 6.2; UI render: default; VCL: qt5 (cairo+xcb) > Locale: en-US (en_US.UTF-8); UI: en-US > Ubuntu package version: 4:7.6.3~rc2-0ubuntu0.22.04.1~lo3 > Calc: threaded I forgot one thing (although it is obvious, it helps make the case): the only current way of doing what I intended is to insert the columns one by one. When you have to insert several dozens this becomes cumbersome... Makes sense to me. Would help with column/row manipulation, along with bug 80390, bug 46930 and bug 39936. Setting to "new" as a better solution than a greyed-out command, and an obvious effect of using such command, but UX/Design can confirm? Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7d357628d6e8ce3f9e3c3a567ada21f02bce8d42 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Same in OOo 3.3. You can "insert multiple rows/columns" actually insert the number of selected, just not if the selection is non-contiguous. And good reason, Eike? (Would have bet that this has been asked before multiple times) (In reply to Heiko Tietze from comment #4) > You can "insert multiple rows/columns" actually insert the number of > selected, just not if the selection is non-contiguous. Exactly, the ask is to do it at different positions at the same time. You can do that in MS Office. > (Would have bet that this has been asked before multiple times) Thought so too but could not find a ticket... (In reply to Heiko Tietze from comment #4) > And good reason, Eike? Well, it's not implemented. Inserting/deleting rows/columns needs references and a bunch of other things adjusted. Multiple non-contiguous selections would have to be treated as a list and each contiguous selection therein be processed individually. Then let's do it. Nice topic for GSoC (In reply to Heiko Tietze from comment #7) > Then let's do it. Nice topic for GSoC Yeah, agree nice topic. :) Btw already have a halfly done patch on my local branch related to this new feature: https://bugs.documentfoundation.org/show_bug.cgi?id=39936 Had no time to finish it, but also didn't want to push yet since it is not in that condition. But as I see this topic is different and only related to inserting multiple columns/rows, before/after non-contiguous selections. *** Bug 145996 has been marked as a duplicate of this bug. *** *** Bug 141315 has been marked as a duplicate of this bug. *** |