Tag: LibreOffice
-
LibreOffice – Set Image as Background/Watermark
I don’t do this very often, but occasionally I need to write a letter or something of that sort and I want to use an image as a background to the letter. A background image of this sort is often referred to as a “watermark.” (If we’re getting technical, a watermark is really a faint…
-
Replacing Paragraph Breaks with Double Paragraph Breaks in LibreOffice Writer
Here’s the problem I was facing. I had a document with a lot of text that I had to analyze. The text had been copied from a spreadsheet and pasted without formatting to get rid of the cells. As a result, there was a single “return” or “paragraph break” between each passage of text. That…
-
LibreOffice Calc – Conditional Formatting
I haven’t used this feature of spreadsheet software as much as I probably should, but I have a spreadsheet I have been working with a lot lately and conditional formatting has been key to helping me orient myself in the spreadsheet. However, in the process, I realized that I am really a noob when it…
-
LibreOffice – address label merge (from spreadsheet)
I’ve been using LibreOffice for over a decade and have only had to do an address label merge twice in that time – both of which have been in the last month. The first time, I actually did a form letter and a label merge; the second time I just had to do an address…
-
LibreOffice Calc – VLookup with dates
In a different post on this blog, I showed how to use Vlookup to match lists. Someone commented on that post and indicated that it didn’t work with dates. It turns out, it does, but… There is a slight tweak required to make it work. So, if you want to learn how to use VLookup,…
-
LibreOffice – KDE Integration Package for Skinning/Color Management
Super simple note for future reference and for anyone else running into this issue. I upgraded my version of LibreOffice in Kubuntu 20.10 to a pre-release version to fix a bug. I was running version 7.1.4.2. When I purged the version of LibreOffice that shipped with Kubuntu 20.10 (6.X – I don’t remember exactly which…
-
LibreOffice – How To Change Icons to a Darker Theme
I prefer darker themes for my desktop environment (Kubuntu 20.04) and browser (Brave). For the most part, this isn’t a problem, but it does cause an issue with some applications, including LibreOffice (6.4.4.2). One of the first things I do when I install Kubuntu is switch my desktop environment from the default theme (System Settings…
-
LibreOffice – exporting high-resolution TIFF/TIF files
As a scholar who regularly publishes work with charts and graphs, I’m often confronted with varied requirements from publishers for the format in which they want the charts and graphs. Most often, the format is as a TIFF/TIF file, typically with at least 300 dpi and somewhere around 1500×1500 pixels. I make most of my…
-
LibreOffice 6.4.3.2 – Not Showing Greek Letters/Symbols
I ran into an issue the other day that ended up taking me hours to solve, in part because I couldn’t find any other solutions online, which is pretty unusual these days. Here was the issue: I was evaluating a paper (I’m an academic and read lots of papers) that had a bunch of Greek…
-
LibreOffice Calc: Graphs with Two y-axes with Different Scales
While a bit technical, it’s occasionally useful to plot multiple data series that have very different scales in the same chart. Let me give an example to illustrate. Let’s say I want to see whether the number of Mormon temples being built aligns with the number of Mormon stakes (akin to a Catholic diocese) that…