Bug 112171 - Visible criteria not visible as caption when EDITING using FILTER in PIVOTTABLE
Summary: Visible criteria not visible as caption when EDITING using FILTER in PIVOTTABLE
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.1.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2017-09-01 21:48 UTC by lobaluna
Modified: 2017-10-28 14:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
A small example of the feature requested (19.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-14 03:28 UTC, lobaluna
Details

Note You need to log in before you can comment on or make changes to this bug.
Description lobaluna 2017-09-01 21:48:04 UTC
Description:
I have a pivot table coming from a large table. I am using the filter option when creating the pivot table, and when I click the Filter button on the pivot table itself, I can create a criteria for filtering a large amount of data, but the criteria itself is NOT showing on the pivot table, nor a sign that the data is filtered (like a caption).

I am not refering to the buttons with small black triangles because these ones turn to blue-with-dot when some filtering is made.

I mean the left-uppermost button named Filter on the pivot table.

This is NOT a bug, but a feature request. My intentions is to show off the criteria that I am using when filtering a pivot table, so someone else will be aware of the filtering I am performing.

Steps to Reproduce:
1.Create a table with three columns and 20 rows (i.e. Text, Date, Amount columns, and generated values to populate the table)
2.Create a pivot table out of it, just showing the Date as rows labels, and Sum-Amount as other column)
3.Filter the pivot table using «Text<>'R'» as criteria

Actual Results:  
You see the Filter bitton, but NO indication/caption/message of what criteria is being used as filter

Expected Results:
To see «Text<>'R'» on the next cell, close to the Filter button (left-upper corner of the pivot table)


Reproducible: Always

User Profile Reset: No

Additional Info:
I asked this feature in AskLibreOffice, and Lupp suggested this should be a feature request.
 https://ask.libreoffice.org/en/question/128068/visible-criteria-when-filtering-a-pivot-table/


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36
Comment 1 Buovjaga 2017-09-09 16:23:03 UTC
(In reply to lobaluna from comment #0)
> Steps to Reproduce:
> 1.Create a table with three columns and 20 rows (i.e. Text, Date, Amount
> columns, and generated values to populate the table)
> 2.Create a pivot table out of it, just showing the Date as rows labels, and
> Sum-Amount as other column)

Even thought this is a feature request, please attach such an example file.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 2 lobaluna 2017-09-14 03:28:26 UTC
Created attachment 136235 [details]
A small example of the feature requested

This snmall example show how a caption of the criteria used to filter the Pivot Table would clarify the data shown.