Conditional formatting in LibreOffice spreadsheets
Sparklines
Integrate graphical information alongside the data it represents with conditional formatting and sparklines.
Spreadsheets are all about detailed data and its manipulation. Sometimes, though, you need a summary for gathering general impressions and discerning trends. That is where conditional formatting becomes useful in LibreOffice Calc – as a graphical summary for interpreting general trends in data at a glance, rather than studying the figures closely.
Contrary to first impressions, Conditional Formatting in Calc shares only part of its name with Conditional Fields or Conditional Styles in Writer. All the three features have in common is that their appearance changes depending on context. In the case of conditional formatting, for instance, the format changes when the content of the involved cells changes.
Conditional formatting is an extension of the idea of sparklines, a concept named and popularized by data visualization theorist Edward Tufte, who devoted 20 pages to the concept in his book, Beautiful Evidence [1]. Sparklines are small line graphs that fit on a line of text or in a single spreadsheet cell. They contain no figures, but from their shape, you can see the general trends in the data they map.
[...]
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Working Exploit for a Linux Kernel Flaw Made Public
Even before a bug received its CVE identifier or an upstream fix, the local privilege escalation vulnerability exploit found its way into the wild.
-
r/opensource Bans AI-Assisted and AI-Related Projects
The de facto subreddit for all things open source has not only banned AI-related projects but also users who "don't speak English."
-
Bottlenecks Discovered by Meta Engineers Lead to Scalability Improvements
Thanks to a small group of engineers at Meta, the Linux kernel module kernfs has been improved, which has led to some serious gains.
-
PwnEscape Poses VM Vulnerability
A guest-to-host escape flaw in Linux KVM, named PwnEscape, might be yet another means of attacking Linux.
-
Linux Mint 27 Set for a Christmas Release
The developers behind Linux Mint have announced a Christmas release, and it looks like Santa's sack will be brimming with features.
-
Is Linus Torvalds Vibe Coding?
The creator of Linux has added AI into his process for Linux kernel development, and it's more than just for debugging.
-
openKylin 3.0 Released with Expanded AI Integration
The latest release features a pre-installed AI agent to help perform tasks.
-
DigitalOcean Ends Open Source Credits Program
In a change that has surprised many open source developers, DigitalOcean has decided to sunset its Open Source Credits Program.
-
Office 365 Available for Testing on Linux via Bottles
Linux users can now test the official Office 365, thanks to Mirko Brombin's work on Bottles.
-
Dutch Government Turns to Open Source for Digital Sovereignty
Following in the footsteps of other European countries, the Netherlands is looking to increase its sovereign digital infrastructure with open source software.