To reproduce: - Open a spreadsheet. - Click somewhere in a table then click Data>Filter>Autofilter - Click one of the drop-down arrows and apply a filter. - Right-click on a column header (A,B,C, etc). There is no "Insert Columns" option (although it is still possible to do Insert>Columns from the menu). Why not? - Remove all autofilters and right-click on a column header. "Insert Columns" is available, as expected.
not reproducible with LO 3.6.4.3. (Win7 Home, 64bit) In both cases with and without autofilter there is an INSERT COLUMNS available after a right mouse click on a column header.
I might not be using the right terminology, but are you sure you actually applied a filter? (the third step: "Click one of the drop-down arrows and apply a filter.") I can also reproduce on 32bit linux with 3.6.4.3. "Insert columns" is available after the second step ("Click somewhere in a table then click Data>Filter>Autofilter"), but not after the third step.
Updated "version" and "platform". (Original testing was with 3.6.3.2 on 64bit Windows 7... although I guess the actual libreoffice build was only 32bit).
I also can't reproduce using Mac OSX 10.8.2 with LibreOffice Version 4.1.0.0.alpha0+ (Build ID: b1d0fd4f969976e2133f8eaa37c1fb8360c20f6) TinderBox: MacOSX-Intel@1-built_no-moz_on_10.6.8, Branch:master, Time: 2013-01-24_00:28:35 Also can't reproduce using LibreOffice Versie 3.6.4.3 (Bouw-id: 2ef5aff)...
@Alister: Thanks for your additional comment/clarification. With this I could reproduce it with LO 4.0.0.3 (Win7 Home, 64bit). It is not possible to insert a column with the right-click, but it also not possible for me to insert a column from the menu (Insert -> Columns). But, I am not sure, whether this is a bug. Can anybody else confirm whether this is a bug or not?
I just run on this problem (which is CONFIRMED for me): On LO 4.0.1.2 on Win7, once an simple autofilter is activated, i can't insert row anymore. Right click menu don't display the option, and in the menu the option is grey. Step to reproduce: - Open a new spreadsheet - type a in a cell, b in cell below, a in cell below - select the 3 lines, apply an autofilter (select a only) - try to insert a row somewhere in the document, the bug appears as told - remove autofilter, insertion works back fine
(In reply to comment #6) > I just run on this problem (which is CONFIRMED for me): Thanks for your info and confirmation. Therefore we can mark this bug as NEW. Kind regards, Joren
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1.2 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-03-03
(In reply to alister.hood from comment #2) > I might not be using the right terminology, but are you sure you actually > applied a filter? (the third step: "Click one of the drop-down arrows and > apply a filter.") Could not reproduce, setting to WFM. Win 7 Pro 64-bit, LibO Version: 4.4.1.2 Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale: fi_FI
Again, I don't know whether you're not following the instructions correctly or there is something special about your system (seems unlikely), but I've upgraded to 4.4.1.2 and confirmed that this bug IS still present.
Created attachment 114261 [details] Screenshot from Win 7, LibO 4.4.1.2 Screenshot showing filter applied (blue square in the dropdown) and insert columns left available.
I can also insert rows and columns from the menu and toolbar buttons. I'll set back to NEW per original reporter's experience.
Ah. Maybe you are using an autofilter which doesn't actually hide any rows. If I select "Top 10" when there are less than 10, or "not empty" when there aren't any empty cells, then "Insert columns left" is available.
Actually, not "maybe". I can see this is the case from your screenshot.
(In reply to alister.hood from comment #13) > Ah. Maybe you are using an autofilter which doesn't actually hide any rows. > If I select "Top 10" when there are less than 10, or "not empty" when there > aren't any empty cells, then "Insert columns left" is available. Yep, that was it. Could reproduce after making the filter hide rows. Adjusted title to make it clear.
I have tested the LO Master build Version: 4.5.0.0.alpha0+ Build ID: 31e24f487e5a4e917bb35fd396cf9f3ad84982a8. Following are my observation 1. Apply the filter on column (let's say empty) after Autofilter is set. And Select the column. a. The "column" menu item from menu "Insert" is disabled. b. The "insert columns left" menu item from Right Contextual menu is disabled. 2. Apply the filter on column (let's say empty) after Autofilter is set. And Select any cell from the same column a. Right Click on the Cell and Select "Insert" menu item from contextual menu b. The dialog box appears and then Select "Entire Column" and press OK c. Not the column is getting properly inserted. Could you please anyone tell me what should be the correct behaviour ? As far as I know, we should also allow to insert the column in case 1 as well.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
Tested again in 5.1.2 on Arch Linux. Still present.
Hi Ravindra, I'm setting this ticket back to NEW as it has been inactive for more than 3 months. Feel free to assign it back to you if you're still working on this. Regards
NOT / No longer reporducible with Version: 5.4.2.2 Build-ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU-Threads: 4; Betriebssystem:Windows 6.1; UI-Render: Standard; Gebietsschema: de-DE (de_DE); Calc: group
(In reply to Rainer Bielefeld Retired from comment #20) > NOT / No longer reporducible with Version: 5.4.2.2 > Build-ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 > CPU-Threads: 4; Betriebssystem:Windows 6.1; UI-Render: Standard; > Gebietsschema: de-DE (de_DE); Calc: group Hi Rainer, Are you sure? It certainly still reproduces in 5.4.2, and it seems rather unlikely, given that you've just filed #113980 which matches this comment above, and seems like it would have the same underlying cause: > it also not possible for me to insert a column from the menu (Insert -> Columns) Note as described above that it only reproduces if the autofilter actually hides some rows.
(In reply to alister.hood from comment #21) a) No! Because of your objective I did some additional tests, and I can still reproduce this one. There are some common STR with Bug 113980 how to reproduce, but also cases which only reproduce this one or only reproduce Bug 113980. I will have to do some more research in the evening.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still present. Version: 6.2.5.2 Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 CPU threads: 8; OS: Mac OS X 10.14.5; UI render: default; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded Context menu when no filter: https://imgur.com/APPfEc1.png Context menu when filtered: https://imgur.com/wK62BYq.png Menu > Sheet > Insert Columns (when filtered): https://imgur.com/9XRYx6Q.png
Cooooonfirmed on Linux (NixOS). LibreOffice: Version: 6.4.3.2 Build ID: 40(Build:2) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: ru-RU (en_DK.UTF-8); UI-Language: en-US Calc: threaded Also, seen on a few other distributions on 5.x.x versions of LibreOffice in the past. Shall try to test on ver. 7.0 Beta and report back.
(In reply to likivik from comment #25) > Shall try to test on ver. 7.0 Beta and report back. Still happens with 7.0.2.2. (I was just about to report this behaviour as a bug and stumbled accross this report in Bugzilla.)
I can confirm this on 7.0.3.1 (x64) win10.
Still present in 7.0.3.1 on Linux. Version: 7.0.3.1 Build ID: 00(Build:1) CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.0.3-0ubuntu0.20.10.1 Calc: threaded
*** Bug 135914 has been marked as a duplicate of this bug. ***
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a2c4a033d49c23d20761b2881135ec3a72f25b01 tdf#57351 sc UI: fix disabled Insert Columns options It will be available in 7.2.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.
It's ok now. Verified in Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: 42d2b2d55a27f11153ea1713737d93540a19211d CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded