Skip to content
Menu
Ryan and Debi & Toren
  • highpoints
  • Privacy Policy
  • R
  • tech
  • Where I’ve Been
Ryan and Debi & Toren

Tag: LibreOffice Calc

LibreOffice Calc – Conditional Formatting

Posted on March 2, 2022March 2, 2022

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…

 3,612 total views,  14 views today

Continue reading

LibreOffice Calc – VLookup with dates

Posted on August 22, 2021August 22, 2021

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…

 2,723 total views,  3 views today

Continue reading

LibreOffice – exporting high-resolution TIFF/TIF files

Posted on June 19, 2020June 19, 2020

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….

 6,951 total views

Continue reading

LibreOffice Calc: Graphs with Two y-axes with Different Scales

Posted on March 28, 2020March 28, 2020

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…

 31,648 total views,  12 views today

Continue reading

LibreOffice Calc: Interpolating Missing Values in Graphs

Posted on March 28, 2020March 28, 2020

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…

 9,725 total views,  2 views today

Continue reading

LibreOffice Calc – Creating Charts with Conditional Formatting

Posted on February 2, 2019August 16, 2021

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…

 5,864 total views,  2 views today

Continue reading

LibreOffice Calc – Comparing and Aligning Two Lists Using VLOOKUP

Posted on June 21, 2018July 12, 2022

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…

 29,500 total views,  12 views today

Continue reading

LibreOffice Calc – splitting contents of cells into multiple columns (e.g., splitting commas)

Posted on January 8, 2018

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,…

 71,136 total views,  48 views today

Continue reading
  • advice
  • country highpoints
  • funny stuff
  • general news
  • hiking
  • memories
  • movie reviews
  • opinions
  • other
  • politics
  • R
  • religion
  • sociology
  • state highpoints
  • stories
  • technology
  • Toren
  • travel
  • website feedback
©2023 Ryan and Debi & Toren | WordPress Theme by Superbthemes.com