Bug 113980 - Insert Row and Insert Column in Standard Toolbar not available after (Auto-) Filter has been applied
Summary: Insert Row and Insert Column in Standard Toolbar not available after (Auto-) ...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.2.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard: target:6.1.0 target:6.0.0.2
Keywords: bibisectRequest, regression
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
 
Reported: 2017-11-21 19:07 UTC by Rainer Bielefeld Retired
Modified: 2020-03-05 07:19 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Sampe Document (30.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-11-28 18:54 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2017-11-21 19:07:17 UTC
Steps how to reproduce 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:

1. Open existing complex Spreadsheet document
2. Apply any auto filter
3. Click a cell in the middle of an area of joint rows
4. Try to click 'Insert Row' or 'Insert Column' icon in Standard Toolbar
   Expected: works, Pulldown menu opens
   Actual: Nothing happens until Document has been saved (by click on 'Save'
           icon
Comment 1 Rainer Bielefeld Retired 2017-11-21 19:10:36 UTC
Additional information:
-------------------------
a) No obvious DUP found with <https://bugs.documentfoundation.org/buglist.cgi?cmdtype=dorem&remaction=run&namedcmd=DUPs113980&sharer_id=19321>
b) also see "Bug 57351 - Calc: "Insert columns" is not available in the context menu if an autofilter to hide rows is applied"
Comment 2 Rainer Bielefeld Retired 2017-11-21 19:12:53 UTC
c) It seems the issue only appears if Autofilter has been applied as
   Standard Filter
Comment 3 Rainer Bielefeld Retired 2017-11-22 05:43:09 UTC
Currently only reproduced with WIN
Comment 4 Xavier Van Wijmeersch 2017-11-22 13:30:31 UTC
Cannot reproduce with and insert cell or column is not a problem

Version: 5.4.4.0.0+
Build ID: 19a50ab615497bec8effbadbfc5d8a5d8b633520
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.0.0.0.alpha1+
Build ID: f1a55c4bfc6afcd9fd316e055e626097e0666ea8
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Comment 5 Rainer Bielefeld Retired 2017-11-22 13:45:45 UTC
Still REPRODUCIBLE with Version: 6.0.0.0.alpha1+ (x64)
Build ID: a5af0fd9f27af42cf2e8571f659cdad6e606215b
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-11-07_00:30:02
Locale: de-DE (de_DE); Calc: CL

But some minor aspects changed.

In the evening, I will do some more tests together with 57351, because the problem only is reproducible under some additional particular conditions not completely mentioned in original report.
Comment 6 Rainer Bielefeld Retired 2017-11-28 18:54:16 UTC
Created attachment 138048 [details]
Sampe Document

The document contains a test area and an additional table with STR and test results. I steps 12,13 you see a difference to Bug 57351

We should try to find out with which Version this one started.
Comment 7 Buovjaga 2017-11-30 18:07:49 UTC
(In reply to Rainer Bielefeld Retired from comment #6)
> Created attachment 138048 [details]
> Sampe Document

Reproduced.

In 5.0.2.2 and 4.4.7.2, step 12 works as expected. Step 13 and 14 are the same as 5.4 and newer.

So let's call for a bibisect for the step 12.

Version: 6.1.0.0.alpha0+ (x64)
Build ID: 42dafb5c7bd218f4d368fbd1113fa4a0fcd7f0cb
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-11-29_23:13:56
Locale: fi-FI (fi_FI); Calc: group threaded
Comment 8 Maxim Monastirsky 2017-11-30 20:25:08 UTC
Assuming that I correctly understand this report, this seems to fix step 12:

https://gerrit.libreoffice.org/45614/

step 14 is an exact duplicate of Bug 57351 IMHO.
Comment 9 Commit Notification 2017-12-03 18:56:12 UTC
Maxim Monastirsky committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=4b65a67caacee1ef0b31219d55bfe0cc6032c9f3

tdf#113980 Refresh row/column buttons state after selection change

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 10 Buovjaga 2017-12-09 16:49:49 UTC
I confirm the fix. Thanks, Maxim.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: d4a54ec92674773bc0f9358a3d9090915a3c8fb0
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on December 9th 2017
Comment 11 Commit Notification 2018-01-07 14:21:57 UTC
Maxim Monastirsky committed a patch related to this issue.
It has been pushed to "libreoffice-6-0":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=081a544b92ab7adbdfe29d56d91019556ffc07c9&h=libreoffice-6-0

tdf#113980 Refresh row/column buttons state after selection change

It will be available in 6.0.0.2.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 12 Emersson Augusto Suarez Ortiz 2020-03-05 00:32:06 UTC
Hi Every Body, this bug is still present, you're able to insert a new column or row if you're in the column that has apply the filter, if your on another column you can't insert a new column.

To reproduce that, you still can open the file, then apply the filter in any column, then move to another column and try to insert a column.
Comment 13 Buovjaga 2020-03-05 07:19:21 UTC
(In reply to Emersson Augusto Suarez Ortiz from comment #12)
> Hi Every Body, this bug is still present, you're able to insert a new column
> or row if you're in the column that has apply the filter, if your on another
> column you can't insert a new column.
> 
> To reproduce that, you still can open the file, then apply the filter in any
> column, then move to another column and try to insert a column.

This is an old report. Please open a new one.