Bug 119807 - Add slicers to tables and Pivot tables in Calc
Summary: Add slicers to tables and Pivot tables in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 122475 134083 (view as bug list)
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2018-09-11 14:34 UTC by Roman Kuznetsov
Modified: 2020-08-19 12:48 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Overview of the slicer functionality (139.81 KB, image/png)
2020-06-17 21:57 UTC, Rafael Lima
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2018-09-11 14:34:03 UTC
Description:
Add slicers to Pivot table in Calc
like this
https://support.office.com/en-us/article/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d

Steps to Reproduce:
1. Just try to use it in the Excel
2. Then add it into Calc


Actual Results:
There isn't slicers functional in Calc

Expected Results:
There is slicers functional in Calc


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 2 Roman Kuznetsov 2018-09-11 21:02:10 UTC
Slicers will help you:

1. Filter many parameters in Pivot table or in Pivot chart without manual changing of Pivot table fields
2. Control several Pivot tables/Pivot charts from one slicer
3. Have opportunity to very fast re-customize view of data in your Pivot tables/Pivot charts

You have several slicers for one huge Pivot table with many initial datas.

It is really super feature, that can help you increase convenience of using of Pivot table/Pivot chart
Comment 3 Buovjaga 2018-10-05 10:33:37 UTC
OK -> NEW
Comment 4 Cor Nouws 2018-10-11 19:22:24 UTC
I think there is difference in slices for Pivot tables and one for tables. Is that correct?
Comment 5 Roman Kuznetsov 2018-10-11 19:30:24 UTC
(In reply to Cor Nouws from comment #4)
> I think there is difference in slices for Pivot tables and one for tables.
> Is that correct?

I don't know about slicers for tables. I used it only for Pivot tables
Comment 6 Gabor Kelemen 2019-01-04 13:05:55 UTC
*** Bug 122475 has been marked as a duplicate of this bug. ***
Comment 7 Aron Budea 2020-06-17 21:31:36 UTC
*** Bug 134083 has been marked as a duplicate of this bug. ***
Comment 8 Aron Budea 2020-06-17 21:34:19 UTC
Let's use this enhancement request both for tables and pivot tables. I don't know if/how much they differ, if anyone has details, do chime in.
Comment 9 Rafael Lima 2020-06-17 21:38:25 UTC
It is important to add the slicer functionality not only for Pivot Tables, but also for user-defined tables on a single spreadsheet. It would work as a simplified filtering functionality, making the spreadsheet more dynamic.

Today LO Calc can't import .xlsx files that contain slicers on tables.

Maybe the slicer functionality would entail the development of other features such as "Format as Table" (similar to MS Excel).
Comment 10 Rafael Lima 2020-06-17 21:56:14 UTC
(In reply to Aron Budea from comment #8)
> Let's use this enhancement request both for tables and pivot tables. I don't
> know if/how much they differ, if anyone has details, do chime in.

I believe the implementation of slicers for tables is much simpler that on Pivot Tables.

On tables it would function as a simplified filtering device. In my opinion, the workflow could be as follows:
1 - The user selects a range containing a table (with column headers) and define it as being a table (hence the "Format as Table")
2 - On the "Data" tab, a button "Insert Slicer" would appear if the spreadsheet has a table
3 - The user would be able to insert Slicers for the columns he/she desires
4 - The slicer would contain buttons with each single value in that column; then the user would be able to filter the table by clicking these buttons

I uploaded an image slicer_calc.png to give an idea of what I am talking about.
Comment 11 Rafael Lima 2020-06-17 21:57:41 UTC
Created attachment 162131 [details]
Overview of the slicer functionality