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…
Tag: LibreOffice Calc
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…
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….
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…
LibreOffice Calc: Interpolating Missing Values in Graphs
Here’s my situation. I have some data over time but I’m missing values in specific years. I want to graph that data but would rather not have to estimate all…
LibreOffice Calc – Creating Charts with Conditional Formatting
I was working on creating a chart in LibreOffice Calc that was kind of weird. Basically, I wanted to show change over time in a dichotomous variable (e.g., political party…
LibreOffice Calc – Comparing and Aligning Two Lists Using VLOOKUP
One of the tasks I have to do regularly as part of my job is to compare two lists to see which items are missing on one list but not…
LibreOffice Calc – splitting contents of cells into multiple columns (e.g., splitting commas)
I periodically have to take a column of text in LibreOffice calc that has names like this “Lastname, Firstname” and split them into two columns. I figure it out every time,…