I cannot find the option to repeat items labels on a pivot table. This is why I need to converting the output the pivot table into tabular table.
In excel, there is a option that permits you display the items labels in the same pivot table.
Please explain more what do you mean. Attach test file, screenshot etc. Is it this feature - http://www.extendoffice.com/documents/excel/1964-excel-repeat-item-labels.html ?
Created attachment 111856 [details]
display items labels in pivot table
When I create a pivot table the items labels get displaying in a grouping way, I need displaying in tabular way. Like in the example that I attach for.
Seeting as enhancement. Excel have this function.
Created attachment 111887 [details]
Excel file with feature "repeat items labels" on pivot table.
Submitted a patch that implements this feature request at https://gerrit.libreoffice.org/#/c/14504/
(Affiliation : Libre Data Consultancy Services)
Deena Francis committed a patch related to this issue.
It has been pushed to "master":
Enhancement tdf#87972 : Cannot repeat items labels on a pivot table
It will be available in 4.5.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:
Affected users are encouraged to test the fix and report feedback.
Deena's patch is now merged to master, and with it, Calc provides an additional option for repeating item labels. It doesn't handle Excel import export though, which will be a nice addition to this new feature if anyone is interested.
Also, Deena wrote a unit test for the core part of this feature. I would be nice to have additional unit test to cover ODF import / export as well.
I'll mark this as fixed. File a new bug for the Excel import export if anyone needs to.
nice :) Thanks!
I've already added a short description at the release notes page
Setting version to Inherited From OOo - the feature never existed in our code
Created attachment 114217 [details]
repeat items label
Verified, Version: 18.104.22.168.alpha0+
Build ID: e3167924fd28c8b854f23139dbf49f53e6282ef7
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-03-17_03:10:47
I already download and install the version LibreOffice with the included patch but I cant found the option for repeat item labels yet.
where exactly can I repeat items labes when create a pivot table?
This bug fix is mentioned in the release notes of the coming LibreOffice 5.0 (see release notes https://wiki.documentfoundation.org/ReleaseNotes/5.0). Therefore it would be wonderful if this feature really worked well, otherwise it should not be mentioned in the release notes. In the notes it reads:
Item labels in Pivot Tables can be repeated now. tdf#87972 (Deena Francis) Screenshot
(In reply to Mike §chinagl from comment #12)
> This bug fix is mentioned in the release notes of the coming LibreOffice 5.0
> (see release notes https://wiki.documentfoundation.org/ReleaseNotes/5.0).
> Therefore it would be wonderful if this feature really worked well,
> otherwise it should not be mentioned in the release notes. In the notes it
> Item labels in Pivot Tables can be repeated now. tdf#87972 (Deena Francis)
ID build: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Locale: ru-RU (ru_RU)
item labels in pivot table not repeat!
(In reply to kompilainenn from comment #13)
> (In reply to Mike §chinagl from comment #12)
> > This bug fix is mentioned in the release notes of the coming LibreOffice 5.0
> > (see release notes https://wiki.documentfoundation.org/ReleaseNotes/5.0).
> > Therefore it would be wonderful if this feature really worked well,
> > otherwise it should not be mentioned in the release notes. In the notes it
> > reads:
> > Item labels in Pivot Tables can be repeated now. tdf#87972 (Deena Francis)
> > Screenshot
> In LibreOffice
> Version: 22.214.171.124.beta1
> ID build: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
> Locale: ru-RU (ru_RU)
> item labels in pivot table not repeat!
how did you tested this? WFM in Version: 126.96.36.199.alpha1+
Build ID: 5b248f1348260f953686b20621255aece57358fe
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-05-21_12:28:08
This feature is only for ods files now, not for excel files.
(In reply to raal from comment #14)
> Hello kompilainenn,
> how did you tested this? WFM in Version: 188.8.131.52.alpha1+
> Build ID: 5b248f1348260f953686b20621255aece57358fe
> TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
> This feature is only for ods files now, not for excel files.
I created a pivot table, and saw that mark to items missing. Of course, I saved the file in the format .ods (see. screenshot)
Created attachment 116146 [details]
2raal: show me a screenshot of your results. maybe I'm not doing a pivot table?
Created attachment 116153 [details]
screnshot of How to
Open the Pivot Table layout dialog.
Double-click in the row field
click on Options.
See screenshot of successive dialogs.
(In reply to GerardF from comment #18)
> Created attachment 116153 [details]
> screnshot of How to
> Open the Pivot Table layout dialog.
> Double-click in the row field
> click on Options.
> See screenshot of successive dialogs.
very not obvious implemented. in Release Notes obviously you need to specify that this is an additional possibility, not a default behavior!