Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes every weekday Monday through Friday.
This page was generated by The HPR Robot at


In-Depth Series: LibreOffice

  • Number of episodes: 72
  • Open/closed: open
  • Date of earliest show: 2012-09-12
  • Date of latest show: 2020-08-19
  • Series RSS feeds: ogg, spx, mp3
In this in-depth series on LibreOffice we examine Writer, Calc and Impress

hpr3143 :: LibreOffice 7.0 Released! hosted by Ahuka

2020-08-19. 00:15:27. Clean.
LibreOffice, new release.

LibreOffice releases a new major update, LibreOffice 7.0

Listen in ogg, spx, or mp3 format.

hpr2069 :: Counting Stuff in LibreOffice Calc hosted by Jon Kulp

2016-07-07. 00:19:55. Clean.
LibreOffice, formulas, tips and tricks.

I try to explain how to use the COUNTIF function in LibreOffice to generate reports

Listen in ogg, spx, or mp3 format.

hpr1915 :: 67 - LibreOffice Impress - Tables hosted by Ahuka

2015-12-04. 00:15:37. Clean.
LibreOffice, Impress, Tables.

Impress tables and how to format them

Listen in ogg, spx, or mp3 format.

hpr1905 :: 66 - LibreOffice Impress - Built-In Charts hosted by Ahuka

2015-11-20. 00:14:21. Clean.
LibreOffice, Impress, Charts.

Creating charts from inside Impress

Listen in ogg, spx, or mp3 format.

hpr1895 :: 65 - LibreOffice Impress - OLE Objects, Spreadsheets, and Charts hosted by Ahuka

2015-11-06. 00:16:06. Clean.
LibreOffice, Impress, OLE, Spreadsheets, Charts.

Using Calc modules and data in a presentation

Listen in ogg, spx, or mp3 format.

hpr1885 :: 64 - LibreOffice Impress - Multimedia hosted by Ahuka

2015-10-23. 00:14:13. Clean.
LibreOffice, Impress, Multimedia, Audio, Video.

Using Audio and Video files in Impress

Listen in ogg, spx, or mp3 format.

hpr1875 :: 63 - LibreOffice Impress - Formatting Text hosted by Ahuka

2015-10-09. 00:17:30. Explicit.
LibreOffice, Impress, Text.

Text formatting options are explored

Listen in ogg, spx, or mp3 format.

hpr1865 :: 62 - LibreOffice Impress - Working With Text Boxes hosted by Ahuka

2015-09-25. 00:16:05. Clean.
LibreOffice, Impress, Layouts, Text Boxes.

The use of Text Boxes from the Drawing Toolbar is explored

Listen in ogg, spx, or mp3 format.

hpr1855 :: 61 - LibreOffice Impress - Slide Layouts and AutoLayout Text Boxes hosted by Ahuka

2015-09-11. 00:17:46. Clean.
LibreOffice, Impress, Layouts, AutoLayout, Text Boxes.

LibreOffice Impress Slide Layouts and components are explored

Listen in ogg, spx, or mp3 format.

hpr1845 :: 60 - LibreOffice Impress - The Gallery and Themes hosted by Ahuka

2015-08-28. 00:14:29. Clean.
LibreOffice, Impress, Presentations, Clip Art, Gallery, Themes.

LibreOffice Clip Art Gallery and Theme collections

Listen in ogg, spx, or mp3 format.

hpr1835 :: 59 - LibreOffice Impress - Pictures hosted by Ahuka

2015-08-14. 00:23:16. Clean.
LibreOffice, Impress, Presentations, Pictures, Photo Album.

Using and formatting pictures, and creating a photo album

Listen in ogg, spx, or mp3 format.

hpr1825 :: 58 - LibreOffice Impress - Creating a Template for Hacker Public Radio hosted by Ahuka

2015-07-31. 00:14:10. Clean.
LibreOffice, Impress, Presentations, Template.

Creating a sample template illustrates these concepts

Listen in ogg, spx, or mp3 format.

hpr1819 :: LibreOffice Tips: Horizontal Lists and Headless Operation hosted by Jon Kulp

2015-07-23. 00:11:15. Clean.
LibreOffice, horizontal list, headless.

A workaround to create horizontal ordered lists in LibreOffice and run LO headless to convert files

Listen in ogg, spx, or mp3 format.

hpr1815 :: 57 - LibreOffice Impress - Styles and Objects 2 - Drawing Object Styles hosted by Ahuka

2015-07-17. 00:16:37. Clean.
LibreOffice, Impress, Presentations, Styles.

Drawing Object Styles and their use in LibreOffice Impress

Listen in ogg, spx, or mp3 format.

hpr1805 :: 56 - LibreOffice Impress - Styles and Objects 1 - Presentation Styles hosted by Ahuka

2015-07-03. 00:14:56. Clean.
LibreOffice, Impress, Presentations, Styles.

Presentation Styles and their use in LibreOffice Impress

Listen in ogg, spx, or mp3 format.

hpr1795 :: 54 - LibreOffice Impress - Templates and Master Pages hosted by Ahuka

2015-06-19. 00:17:14. Clean.
LibreOffice, Impress, Templates, Master Pages.

Using and acquiring Templates in Impress

Listen in ogg, spx, or mp3 format.

hpr1785 :: 54 - LibreOffice Impress - Creating a Presentation hosted by Ahuka

2015-06-05. 00:11:14. Clean.
Libreoffice, Libreoffice impress, creating presentation.

The mechanics of creating a presentation in Impress

Listen in ogg, spx, or mp3 format.

hpr1765 :: 53 - LibreOffice Impress - Outlining and Blank Presentations hosted by Ahuka

2015-05-08. 00:13:49. Clean.
Libreoffice, Libreoffice impress, outline.

Learning to start with the content and not the eye candy.

Listen in ogg, spx, or mp3 format.

hpr1755 :: 52 - LibreOffice Impress - Moving Around hosted by Ahuka

2015-04-24. 00:13:34. Clean.
LibreOffice, Impress, Presentations, navigation.

Introduction to the Impress application screen layout.

Listen in ogg, spx, or mp3 format.

hpr1745 :: 51 - LibreOffice Impress - Overview and Guidance hosted by Ahuka

2015-04-10. 00:11:13. Clean.
LibreOffice, Impress, Presentations.

Introduction to making Presentations, with some good advice.

Listen in ogg, spx, or mp3 format.

hpr1735 :: Free tutorials for teachers hosted by Ahuka

2015-03-27. 00:14:57. Explicit.
Teachers, tutorials.

Professor Bernard Poole makes free tutorials available aimed at teachers

Listen in ogg, spx, or mp3 format.

hpr1725 :: 49 - LibreOffice Calc - Creating a Template with Styles hosted by Ahuka

2015-03-13. 00:13:58. Clean.
LibreOffice, Calc, Spreadsheet, Styles, Templates.

We create Template (recording Billable Time) using Styles to illustrate the usage.

Listen in ogg, spx, or mp3 format.

hpr1715 :: 48 - LibreOffice Calc - Cell Styles hosted by Ahuka

2015-02-27. 00:14:57. Clean.
LibreOffice, Calc, Spreadsheet, Cells, Styles.

How to use Cell Styles to control the appearance of your cells.

Listen in ogg, spx, or mp3 format.

hpr1705 :: 47 - LibreOffice Calc - Page Styles and Page Settings hosted by Ahuka

2015-02-13. 00:20:34. Clean.
LibreOffice, Calc, Spreadsheet, Sheets, Styles.

How to control the overall appearance of a worksheet using Page Styles and Page Settings.

Listen in ogg, spx, or mp3 format.

hpr1695 :: 46 - LibreOffice Calc - The Object Model and Using Templates hosted by Ahuka

2015-01-30. 00:25:20. Clean.
LibreOffice, Calc, Spreadsheet, Objects, Templates.

Ubderstanding the Object Model and how Templates work.

Listen in ogg, spx, or mp3 format.

hpr1685 :: 45 - LibreOffice Calc - Styles and Templates Introduced hosted by Ahuka

2015-01-16. 00:15:05. Clean.
LibreOffice, Calc, Spreadsheet, Styles, Templates.

How the concepts of Styles and Templates can be useful in Spreadsheets

Listen in ogg, spx, or mp3 format.

hpr1665 :: 44 - LibreOffice Calc - Working With Pivot Tables hosted by Ahuka

2014-12-19. 00:10:52. Explicit.
LibreOffice, Calc, Spreadsheet, pivot, tables.

When you have a pivot table, what are some of the things you can do with it to analyze your data?

Listen in ogg, spx, or mp3 format.

hpr1655 :: 43 - LibreOffice Calc - Creating Pivot Tables hosted by Ahuka

2014-12-05. 00:15:50. Clean.
LibreOffice, Calc, Spreadsheet, pivot, tables.

How to create a Pivot Table

Listen in ogg, spx, or mp3 format.

hpr1645 :: 42 - LibreOffice Calc - Data Manipulation 2: Standard and Advanced Filters hosted by Ahuka

2014-11-21. 00:16:29. Clean.
LibreOffice, Calc, Spreadsheet, filters.

A look at the more advanced filtering options for manipulating data in Calc.

Listen in ogg, spx, or mp3 format.

hpr1635 :: 41 - LibreOffice Calc - Data Manipulation 1: Sorting and AutoFilter hosted by Ahuka

2014-11-07. 00:12:42. Clean.
LibreOffice, Calc, Spreadsheet, sorting, autofilter.

A look at the most simple ways of manipulating data in Calc.

Listen in ogg, spx, or mp3 format.

hpr1625 :: 40 - LibreOffice Calc - Other Functions hosted by Ahuka

2014-10-24. 00:15:13. Clean.
LibreOffice, Calc, Spreadsheet, functions.

A quick look at some miscellaneous functions in Calc.

Listen in ogg, spx, or mp3 format.

hpr1615 :: 39 - LibreOffice Calc - Inferential Statistics Functions hosted by Ahuka

2014-10-10. 00:20:12. Clean.
LibreOffice, Calc, Spreadsheet, functions, inferential, statistics.

Inferential statistics is how we draw conclusions from data and make predictions.

Listen in ogg, spx, or mp3 format.

hpr1605 :: 38 - LibreOffice Calc - simple Descriptive Statistics hosted by Ahuka

2014-09-26. 00:19:09. Clean.
LibreOffice, Calc, Spreadsheet, functions, descriptive statistics.

Descriptive statistics is how we make basic measurements about a population

Listen in ogg, spx, or mp3 format.

hpr1595 :: 37 - LibreOffice Calc - More Financial Functions hosted by Ahuka

2014-09-12. 00:17:18. Clean.
LibreOffice, Calc, Spreadsheet, functions, finance, mortgage.

A look at financial functions and constructing a mortgage repayment schedule

Listen in ogg, spx, or mp3 format.

hpr1585 :: 36 - LibreOffice Calc - Financial Functions - Loan Payments hosted by Ahuka

2014-08-29. 00:22:26. Clean.
spreadsheet, financial function.

Financial Functions in LibreOffice Calc

Listen in ogg, spx, or mp3 format.

hpr1575 :: 35 - LibreOffice Calc - Introduction to Functions hosted by Ahuka

2014-08-15. 00:11:54. Clean.
Calc, Spreadsheet, function.

Introduction to working with functions in LibreOffice Calc

Listen in ogg, spx, or mp3 format.

hpr1565 :: 34 - LibreOffice Calc - More on Chart Editing hosted by Ahuka

2014-08-01. 00:13:13. Clean.
LibreOffice, Calc, Spreadsheet, chart, graph.

Editing charts, Calc

Listen in ogg, spx, or mp3 format.

hpr1555 :: 33 - LibreOffice Calc - Creating Charts hosted by Ahuka

2014-07-18. 00:14:41. Clean.
LibreOffice, Calc, Spreadsheet, chart, graph.

Creating Charts with LibreOffice Calc

Listen in ogg, spx, or mp3 format.

hpr1545 :: 32 - LibreOffice Calc - Introduction to Charts and Graphs hosted by Ahuka

2014-07-04. 00:19:44. Clean.
LibreOffice, Calc.

LibreOffice, Calc, Spreadsheet, chart, graph

Listen in ogg, spx, or mp3 format.

hpr1535 :: 31 - LibreOffice Calc - Sheet Editing and Navigation hosted by Ahuka

2014-06-20. 00:20:38. Clean.
LibreOffice, Calc.

Editing and navigating sheets, rows and columns in LibreOffice Calc

Listen in ogg, spx, or mp3 format.

hpr1525 :: 30 - LibreOffice Calc - A Savings Model hosted by Ahuka

2014-06-06. 00:20:52. Clean.
LibreOffice, Calc.

LibreOffice, Calc, Spreadsheet, models, what-if analysis, savings

Listen in ogg, spx, or mp3 format.

hpr1515 :: 29 - LibreOffice Calc - Models and "What-If" Analysis hosted by Ahuka

2014-05-23. 00:12:54. Clean.
LibreOffice, Calc.

This episode looks at building models and doing "What-If?" Analysis.

Listen in ogg, spx, or mp3 format.

hpr1505 :: 28 - LibreOffice Calc - Fills, an Introduction hosted by Ahuka

2014-05-09. 00:15:03. Clean.
LibreOffice, Calc, Spreadsheet, fills.

This episode looks at the filling rows and columns using click-and-drag.

Listen in ogg, spx, or mp3 format.

hpr1495 :: 27 - LibreOffice Calc - Calculations and the Formula Bar hosted by Ahuka

2014-04-25. 00:23:21. Clean.
LibreOffice, Calc, Spreadsheet, formulas.

This episode looks at the creating and using formulas in spreadsheets.

Listen in ogg, spx, or mp3 format.

hpr1485 :: 26 - LibreOffice Calc Cells hosted by Ahuka

2014-04-11. 00:21:15. Clean.
LibreOffice, Calc, Spreadsheet.

This episode looks at the fundamental unit of a spreadsheet, the cell, and introduces addressing and

Listen in ogg, spx, or mp3 format.

hpr1475 :: 25 - LibreOffice Calc What Is A Spreadsheet hosted by Ahuka

2014-03-28. 00:13:40. Clean.
LibreOffice, Calc, Spreadsheet.

The origins and history of the spreadsheet

Listen in ogg, spx, or mp3 format.

hpr1465 :: 24 - LibreOffice Writer A Brochure Project hosted by Ahuka

2014-03-14. 00:26:12. Clean.
LibreOffice, Writer, Word Processing, Page Layout.

This concludes our look at page layout by showing these techniques at use in creating a Tri-fold bro

Listen in ogg, spx, or mp3 format.

hpr1455 :: 23 - LibreOffice Writer Other Page Layout Options hosted by Ahuka

2014-02-28. 00:15:52. Clean.
LibreOffice, Writer, Word Processing, Page Layout.

This continues our look at page layout by looking at ways to do this other than by using frames.

Listen in ogg, spx, or mp3 format.

hpr1445 :: 22 - LibreOffice Writer Other Frame Styles hosted by Ahuka

2014-02-14. 00:10:06. Clean.
LibreOffice, Writer, Word Processing, Page Layout.

This continues our look at frames by looking at frame styles for things other than text.

Listen in ogg, spx, or mp3 format.

hpr1435 :: 21 - LibreOffice Writer Frame Properties Completed hosted by Ahuka

2014-01-31. 00:16:40. Clean.
libreoffice, frame properties.

The second of two programs about Frame properties in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1425 :: 20 - LibreOffice Writer Frames - Introduction and the Type Tab hosted by Ahuka

2014-01-17. 00:30:49. Clean.
libreoffice, frames.

This episode introduces the discussion of Frames in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1415 :: 19 - LibreOffice Writer Working with Page Styles hosted by Ahuka

2014-01-03. 00:18:29. Clean.
LibreOffice, Writer.

Using page styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1405 :: 18 - LibreOffice Writer Page Styles Introduced hosted by Ahuka

2013-12-20. 00:20:49. Clean.
LibreOffice, Writer.

An introduction to page styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1395 :: 17 - LibreOffice Writer Overview of Page Layout Options hosted by Ahuka

2013-12-06. 00:12:32. Clean.
LibreOffice, Writer.

Controlling page layout in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1385 :: LibreOffice 16 Writer Nested Lists Controlled via Styles hosted by Ahuka

2013-11-22. 00:25:00. Clean.
LibreOffice, Writer.

Controlling nested lists with styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1375 :: LibreOffice 15 Writer Nested Lists Introduced hosted by Ahuka

2013-11-08. 00:20:43. Clean.
LibreOffice, Writer.

Introducing nested lists in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1365 :: LibreOffice 14 Writer A Numbered List Style Deconstructed hosted by Ahuka

2013-10-25. 00:22:12. Clean.
LibreOffice, Writer.

How to define a numbered list style in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1355 :: LibreOffice 13 Writer A Bullet Style Deconstructed hosted by Ahuka

2013-10-11. 00:18:11. Explicit.
LibreOffice, Writer.

How to define a bullet list style in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1345 :: LibreOffice 12 Writer List Styles Introduced hosted by Ahuka

2013-09-27. 00:25:10. Explicit.
LibreOffice, Writer.

Introducing list styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1335 :: LibreOffice 11 Writer Character Styles hosted by Ahuka

2013-09-13. 00:19:42. Explicit.
LibreOffice, Writer.

Character styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1325 :: LibreOffice 10 Writer Paragraph Styles in Templates hosted by Ahuka

2013-08-30. 00:13:57. Explicit.
LibreOffice, Writer.

Using paragraph styles in templates in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1315 :: LibreOffice 09 Writer Working With Paragraph-Level Styles hosted by Ahuka

2013-08-16. 00:22:42. Explicit.
LibreOffice, Writer.

Details of paragraph-level styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1305 :: LibreOffice 08 Writer Tab Styles hosted by Ahuka

2013-08-02. 00:11:37. Explicit.
LibreOffice, Writer.

Tab styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1295 :: LibreOffice 07 Writer Heading Styles hosted by Ahuka

2013-07-19. 00:21:20. Explicit.
LibreOffice, Writer.

Heading styles in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1285 :: LibreOffice 06 Writer Creating a Paragraph Style LibreOffice hosted by Ahuka

2013-07-05. 00:17:59. Explicit.
LibreOffice, Writer.

Creating a Paragraph Style in LibreOffice

Listen in ogg, spx, or mp3 format.

hpr1275 :: LibreOffice 05 Writer Style Properties 2 hosted by Ahuka

2013-06-21. 00:21:34. Explicit.
LibreOffice, Writer.

Style properties in LibreOffice Writer, part 2

Listen in ogg, spx, or mp3 format.

hpr1267 :: LibreOffice 04 Writer Style Properties 1 hosted by Ahuka

2013-06-11. 00:25:22. Explicit.
LibreOffice, Writer.

Style properties in LibreOffice Writer, part 1

Listen in ogg, spx, or mp3 format.

hpr1190 :: LibreOffice 03 Writer Introduction to Styles hosted by Ahuka

2013-02-22. 00:21:40. Explicit.
LibreOffice, Writer.

Using styles to control the appearance of documents in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1149 :: LibreOffice 02 Writer Default Template hosted by Ahuka

2012-12-27. 00:17:18. Explicit.
LibreOffice, Writer.

The default template in LibreOffice Writer

Listen in ogg, spx, or mp3 format.

hpr1136 :: LibreOffice 01 Introduction to Office software hosted by Ahuka

2012-12-10. 00:27:00. Explicit.
LibreOffice, office software, introduction.

Introduction to Office Software

Listen in ogg, spx, or mp3 format.

hpr1093 :: Separate Presentation from Content - 2 Office Software hosted by Ahuka

2012-10-10. 00:23:54. Explicit.
presentation, content, office software, semantic encoding.

A continuation of the topic of presentation versus content

Listen in ogg, spx, or mp3 format.

hpr1073 :: Separate Presentation from Content - 1 The Web hosted by Ahuka

2012-09-12. 00:31:23. Explicit.
presentation, content, css.

An introduction to the concept of presentation versus content

Listen in ogg, spx, or mp3 format.