LibreOffice 5.4 has been released

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post Reply
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

LibreOffice 5.4 has been released

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply