Bug 57351

Summary:	Calc: "Insert columns" is not available in the context menu if an autofilter is applied
Product:	LibreOffice	Reporter:	alister.hood
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	alister.hood, jorendc, nightrow, stgohi-lobugs
Version:	3.6.4.3 release
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:

Description alister.hood 2012-11-20 22:51:52 UTC

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.

Comment 1 A (Andy) 2012-12-24 20:00:55 UTC

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.

Comment 2 alister.hood 2012-12-24 20:21:38 UTC

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.

Comment 3 alister.hood 2012-12-24 20:32:12 UTC

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).

Comment 4 Jorendc 2013-01-24 23:59:55 UTC

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)...

Comment 5 A (Andy) 2013-03-03 10:52:59 UTC

@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?

Comment 6 nightrow 2013-03-31 10:29:28 UTC

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

Comment 7 Jorendc 2013-04-01 20:22:01 UTC

(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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.