How-to use Sparklines in Collabora Online

What are Sparklines?

Sparklines are miniature charts that are heavily simplified and typically fit into a line of text or a cell on a spreadsheet. Their first appearances date back to 18th century chivalric novels and the display of barometric signatures of the notorious 19th century Krakatoa eruption. Unlike classic charts, Sparklines are meant to be succinct and located right where they are discussed. Microsoft’s XLSX format has included these mini-charts for quite some time. With the major release of Collabora Office 22.05, Sparklines became available within the LibreOffice Technology ecosystem. Shortly afterwards, they were also implemented in Collabora Online 22.05 and LibreOffice 7.4.

Creating Sparklines in Collabora Online

If you open a .XLSX or .ODS spreadsheet including Sparklines inside Collabora Online, the miniature charts will be preserved. If you want to create a new Sparklines chart from scratch in Collabora Online, you should start by selecting the row or column of cells you would like to visualize. Right-click, and chose “Sparklines > Insert Sparklines…” from the context menu. The “Sparklines Properties” dialog will appear including the chosen input range. The button besides the “Output range” field allows you to choose the cell the Sparkline will be created in.

Select the data range from the row or column, right-click and choose “Insert Sparkline” to create a new miniture chart
In the “Sparkline Properties” dialog click on the “Output range” icon to postion the chart

Formatting Sparklines in Collabora Online

If you would like to edit or customise the appearance of a group of mini charts, right-click on the Sparklines and chose “Edit Sparkline Group…”. This will summon the “Sparkline Properties” dialog and grant access to several different settings. You can for instance choose between three different types of Sparklines. Just like Office 365, Collabora Online allows you to create a miniature Line Chart, a Column Chart or a Stacked Chart (Win/Loss). You can also customise the visual appearance by adjusting the line width or choosing individual colours for special points in the graph (marker, high/low point, first/last point).

Right-click on a Sparkline and choose “Edit Sparkline Group…” for the formatting options
Adjust the appearance of Sparklines inside the “Sparkline Properties” dialog

Test this in Collabora Online or CODE

The Sparkline feature has been introduced to Collabora Online with the major release 22.05. You can test the feature in our free demo. Tech enthusiasts may also like to test it inside an installation of CODE, the free Collabora Online Development Edition, intended for home users and Developers who would like to help to test the bleeding-edge features first. Find all the instructions here.



Thank you for making this possible

This feature was made possible by funding from NGI and the European Union’s Horizon 2020 research and innovation programme under grant agreement No 871498. For more information on the technical background, see Tomaz Vajngerl’s blog.

Read More

Pivot charts in LibreOffice – part 2

Last week we informed you about the blog post of Collaboran Tomaž Vajngerl, about his work on Pivot charts in LibreOffice, funded for by Nantes Métropole and Ville de Nantes in France. Now he has published an update – Pivot charts in LibreOffice – part 2.

This time I’ll present some necessary changes to make pivot charts actually useful and one unique feature that pivot charts have and normal charts don’t – field buttons.

Pivot chart creation
If you watched the first video, you should notice that I showed the pivot chart was already created from the start. The reason for this was that the functionality to create a new pivot chart from the pivot table wasn’t implemented yet. I have fixed this, so it is now possible to create a new pivot chart if you position the cursor on the pivot table, and select from the menu to create a new chart. The chart creation code will detect the pivot table and create a pivot chart instead of a normal chart.

Continue reading on

(image and video by Tomaž Vajngerl)

Read the complete post at

Read More

Pivot charts in LibreOffice

Collaboran Tomaž Vajngerl has blogged about his work on Pivot charts in LibreOffice, funded for by Nantes Métropole and Ville de Nantes in France. Check it out!

Pivot tables are a powerful tool to reorganise, manipulate and summarise the data set in spreadsheets to get the valuable information from it. To get a quick visual representation of the information, pivot charts can be used. A pivot chart can be created from the output of the pivot tables, and if the pivot table gets changed, so does the pivot chart.

Support for pivot tables in LibreOffice is available for a long time, but there was no support for pivot charts until now. For the past week I was working on pivot charts in a feature branch (feature/pivotcharts) and I got to a first milestone. Pivot charts will be released in LibreOffice 5.4.

Continue reading on

(image and video by Tomaž Vajngerl)

Read the complete post at

Read More