LibreOffice 5.4 has been released

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.

LibreOffice 5.4 has been released

Postby Villeroy » Sun Aug 27, 2017 9:29 pm

https://wiki.documentfoundation.org/ReleaseNotes/5.4
IMHO, the most outstanding new feature is pivot charts. I've been missing this since OOo version one. The new feature is undocumented and without any GUI. Click a cell in a pivot table and create a chart. The chart is linked to the pivot cache, series from column fields, categories (x-axis) from row fields, plotted values from data fields.
From a simple pivot with categories, aggregated values and dates grouped by years you can plot years by categories, categories by years and values by combined categories and years simply by dragging around the pivot fields. The chart always includes the full set of values regardless of the layout.
On the chart you have instances of the filter buttons for page, row and column fields.
This is a very elegant solution. I rebuilt 3 of my charts without any issues. The former versions of these charts required a manual adjustment every month since the pivot tables grew by one row per month.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26630
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to LibreOffice

Who is online

Users browsing this forum: Google [Bot] and 2 guests